![microsoft dynamics rms query to delete all items microsoft dynamics rms query to delete all items](https://community.dynamics.com/cfs-file/__key/communityserver-discussions-components-files/117/AdvFindNoDelete.png)
if I have to filter all Australian leads, I will look at ‘Business Phone’ starts with country code +61 my filter would be startswith(telephone1,’+61′)Į.g. if I have to filter leads where ‘Rating’ contains ‘Hot’ and ‘Lead Source’ contains ‘Advertisement’ my filter would be leadqualitycode eq 1 and leadsourcecode eq 1įilter query=startswith(fieldname,’startvalue’)Į.g. Filter by checking two different option setsįilter query= optionsetfieldname1 eq optionsetnumericvalue1 or optionsetfieldname2 eq optionsetnumericvalue2Į.g. if I have to filter where ‘Rating’ contains either ‘Hot’ or ‘Warm’ data my filter would be leadqualitycode eq 1 or leadqualitycode eq 2ġ0. if I have to filter where ‘Topic’ contains ‘New’ and ‘Interested’ my filter would be contains(subject,’new’) and contains(subject,’interested’) 9.Filter an option set checking two or more valuesĮ.g. Contains with ‘AND’ on same text fieldįilter query= contains(textfield1name,’value1′) and contains(textfield1name,’value2′)Į.g. if I have to filter where ‘Rating’ contains either ‘Hot’ or ‘Warm’ data my filter would be leadqualitycode eq 1 or leadqualitycode eq 2 8. if I have to filter where ‘Job title’ contains ‘Manager’ or ‘Consultant’ my filter would be contains(jobtitle,’manager’) or contains(jobtitle,’consultant’)Į.g. if I have to filter lead’s with rating ‘Hot’ (value =1) my filter would be leadqualitycode ne 1 7.Contains with ‘OR’ on same fieldįilter query= contains(field1name,’value1′) or contains(field1name,’value2′)įilter query= optionsetfieldname1 eq optionsetnumericvalue1 or optionsetfieldname1 eq optionsetnumericvalue2Į.g. 6.Does not contains for option setsįilter query= optionsetfieldschemaname ne optionsetnumericvalueĮ.g. Note: As per my understanding, you can’t check option set label in ODATA filter but you can in filter array. if I have to filter lead’s with rating ‘Hot’ (value =1) my filter would be leadqualitycode eq 1
![microsoft dynamics rms query to delete all items microsoft dynamics rms query to delete all items](https://technologyblog.rsmus.com/wp-content/uploads/2021/03/microsoft-dynamics_header_v4_revised-1.png)
This one is for option set fields like Rating, Lead Source, Industry, Type etc.įilter query= optionsetfieldschemaname eq optionsetnumericvalueĮ.g. if I have to filter where ‘Rating’ does not contains data or is blank my filter would be leadqualitycode eq null 5.Contains for option sets if I have to filter where ‘Job title’ does not contains data or is blank my filter would be jobtitle eq nullĮ.g. Does not contains data (Is blank)įilter query= textfieldschemaname eq nullįilter query= optionsetfieldschemaname eq nullĮ.g. if I have to filter where ‘Rating’ contains data or is not blank my filter would be leadqualitycode ne null 4. if I have to filter where ‘Job title’ contains data or is not blank my filter would be jobtitle ne nullĮ.g. This one is for both text and option set fieldsįilter query= textfieldschemaname ne nullįilter query= optionsetfieldschemaname ne nullĮ.g. if I have to check that the ‘Subject/Topic’ of a Lead record does not contains ‘New’ in it my filter would be not contains(subject,’new’) 3.Contains data (Is not blank) if I have to check whether the ‘Subject/Topic’ of a Lead record contains ‘New’ in it my filter would be contains(subject,’new’)įilter query= not contains(textfieldschemaname,’value’)Į.g.
![microsoft dynamics rms query to delete all items microsoft dynamics rms query to delete all items](https://dynamics.mittermair.pro/wp-content/uploads/2019/01/2019-01-02-Process_-Case-to-Work-Order-Business-Process-Microsoft-Dynamics-365-300x80.png)
This one is for text fields like Topic, Subject, Phone, City, Street 1 etc.įilter query= contains(textfieldschemaname,’value’)Į.g.
![microsoft dynamics rms query to delete all items microsoft dynamics rms query to delete all items](https://www.codetwo.com/admins-blog/wp-content/uploads/2016/03/How-to-export-Office-365-mailboxes-to-PST-1-1.png)
ODATA filter query 1.Contains for text fields Sequence: In most queries the sequence of the components remains like ‘fieldname operator fieldvalue’ but in some cases like contains/does not contains sequence and structure changes to ‘operator(fieldname,’fieldvalue’)’ This post will talk about the following two filter types you need while building a flow:īefore we commence with the filters, i will try to explain you the components of ODATA filter query: 1.Field or Column Name But here we are moving forward and learning together to be able to work with Flows. Most of this bottleneck is because as non-technical people we don’t know what ‘ODATA Query’ is?Ĭoming from Dynamics 365 background, I never required such filters for native workflows of D365. I am sure as a Business user or a functional consultant, you must have had a situation where you needed someone technical to complete your flow. We all know how easy it is to create a flow ( Watch #TGIF Episode 2 here, if not already). This blog is to help fellow consultants to start their journey on Power Automate.