cancel
Showing results for 
Search instead for 
Did you mean: 
rdpDen
Nintex Newbie

Workflow Query list - FIlter - not returning equal fields

SharePoint list with single line of text field populated with alpha numeric value.  The value is identical to another lookup field.  When I query for field 1 = field 2 there are no results.

 

<Query>
  <Lists>
    <List ID="{FBB0E18C-7083-4C4E-B0CF-029A08B80003}" />
  </Lists>
  <ViewFields>
    <FieldRef Name="ID" />
    <FieldRef Name="OriginalInvoiceID" />
    <FieldRef Name="InvoiceID" />
  </ViewFields>
  <Where>
    <Eq>
      <FieldRef Name="OriginalInvoiceID"  />
      <Value Type="Text">{ItemProperty:InvoiceID}</Value>
    </Eq>
  </Where>
</Query>

Labels: (1)
0 Kudos
Reply
1 Reply
Nintex Employee
Nintex Employee

Re: Workflow Query list - FIlter - not returning equal fields

Hi,
The CAML Query looks correct. My question then is what does the alpha numeric value look like then?
Can you provide a sample so that I can test using data similar to yours.
Also make sure that the "XML encode inserted tokens" is ticked. It is usually ticked by default.
0 Kudos
Reply