Query List Action

[#1]

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.

[lkchiang · Accepted 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')

[deanvirag]

Very helpful and timely for my situation. Thanks!

[courtney_shelto]

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