cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Query List Action

Jump to solution

Hi Guys, I have a list in which I have 2 fields "Technology" - Choice field (SharePoint, .Net, Oracle, All) and Department - Choice Field (A, B, C, All). I want to query this list to get the items and my query will be [(Technology="SharePoint") OR (Technology="All")] AND[(Department="A") OR (Department="All")] . Could you please help me how to create this query in "Query List" action. Thanks.

Labels: (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Newbie

Re: Query List Action

Jump to solution

Hi Vijai Anand Ramalingam​,

You can use Odata filter editor to get the result.

Example: (Technology eq 'Sharepoint' or Technology eq 'All') and (Department eq 'A' or Department eq 'All')

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: Query List Action

Jump to solution

Very helpful and timely for my situation. Thanks!

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Query List Action

Jump to solution

How would you structure the OData filter to compare two fields? Also, how does it handle spaces in column names? Simply negate the quotes to end up with something like:

(Contract Expiration ne contractExpirationHidden)

I basically have a hidden date field so that I can check and see if the user has changed the date by comparing it with the one they're able to edit

0 Kudos
Reply