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

Workflow - Query List with filtering by a lookup column produces empty results

Hello everybody,


i am new to this forum and i am stucked for a while now with a problem - so i would appreciate if someone could help me out.

 

I am using the "Query List" action for a multiple filter action (3 filters in total) on a "rule table"  - the filters with the 2 numbers work as expected but the third filter option is a lookup column where i compare two lookup-fields with each other.

I want to filter by the lookup-Number of my actual table ("lookupNumberA") applied on the rule table which also has a lookupNumber (lets call it "ruleTable:lookupNumber")

 

It is like this

query list "ruleTable"

Filter action:

where "ruleTable:lookupNumber" is equal to "lookupNumberB"

 

I always receive an empty result eventhough the numbers are the same. I guess i have to parse it somehow and already tried already fn-Trim, but i just continuing getting empty results.

 

Does anyone have an idea?


Thanks a lot and best regards

Schmidty

Labels: (1)
Tags (2)
0 Kudos
Reply
1 Reply
Highlighted
Schmidt85
Nintex Newbie

Re: Workflow - Query List with filtering by a lookup column produces empty results

ps. the CAML looks like this
<Query>
<Lists>
<List ID="{06AA60D5-796E-43DC-826C-8EB83BC3AA56}" />
</Lists>
<ViewFields>
<FieldRef Name="Kostengenehmiger" />
</ViewFields>
<Where>
<Eq>
<FieldRef Name="lookupNumber" />
<Value Type="Lookup">{ItemProperty:lookupNumberB}</Value>
</Eq>
</Where>
</Query>
0 Kudos
Reply