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.
Solved! Go 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')
Very helpful and timely for my situation. Thanks!
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