Hi all!
I have a CAML query against a SP list and am trying to grab some fields where the Author field of the list = the current User in an Nintex collection (the collection is populated by a list query that returns SP users).
Currently I have:
<Where>
<Eq>
<FieldRef Name="Author"/>
<Value Type="Lookup">{WorkflowVariable:currCommentor}</Value>
</Eq>
</Where>
I've tried value Type = User which also doesn't work. I've also tried LookupId="True" in the fieldRef. The other bummer is that I don't know what's in that currCommentor at run time to be able to type it into the CAML editor to 'Run Now'.
Am I barking up the wrong tree? Seems like this should work in theory