AnsweredAssumed Answered

Dynamic CAML query in Query list action with IN clause returns Value not in Range error.

Question asked by altaf263 on Feb 24, 2015
Latest reply on Nov 19, 2015 by markuden

Hi ,

 

I am using Nintex workflow 2010 where the scenario is like the user will select multiple values from multi lookup column and saves the item.

Once saved it triggers my workflow wher i have to dynamically build query based on number of options selected.

 

The scenario is similar to

user defined functions - How to give Nintex Query List Action a dynamic CAML query - Stack Overflow

 

I have used IN clause of CAML query which i  built using string build function  and store it in variable. The variable is inturn used in CAML query as shown in the above link.

 

I keep getting value is not with in the range. Where as if i hard code like below it returns me results

 

<In>

<FieldRef Name='Designation' />

 

<Values>

 

<Value Type='Text'>Engineer</Value>

 

<Value Type='Text'>Architect</Value>

 

</Values>

 

</In>

 

but if i give like below it throws "Value is not within the range".

 

<In>

<FieldRef Name='Designation' />

 

<Values>

 

{workflowvariable:valuesQuery}

</Values>

 

</In>

 

 

Can anyone please help in this regard

Outcomes