Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
In Advanced Find is there a way of constructing a "Where <ID> IN" type Clause with a list of ID's, instead of having to do lots of "ID equals" joined with an OR.
Don't think its possible. Using Contains or equals group by an OR block is the only way. To do what you're asking CRM would have to provide the list and check the field is in the list, but CRM ony works be checking the list is in the field.
In CRM, for text, you cannot have in clause, but for option set or lookup, you can construct in:
But, if you are looking the entity records by the list of ID, which is you can find it by this column (ID), can be name, email, custom ID, or anything that you can set through Quick Find Account.
This is can be another fast way as workaround.
In Adv Find, since the In value can be used in Lookup type, so you can use this method.
So, assume you are going to find Open Opportunity with ID (topic I use as example of ID) : Enrico and contain Order
I can use this:
I have to write many ID equals and contains with OR as many ID as I need to show.
Imagine, have more than 10 Topic I have to search.
So, instead, I can use this method, In adv find view, you just select the criteria to the same entity, for example this Opportunity
Then, you can see the lookup button, right.
Then, you are actually can search the record, either by ID, name, or any fields, that you've been setting in the Quick Find
So, first I search ID (in this example= topic) = enrico
Then I search another ID, can use * wildcard
Then, I select them all.
Click the Add button then see the result in Adv Find
So, you can use Search Find from the lookup, you can find by any columns from the entity as long as you set in the Quick Find.
Then it will be your IN Clause with a list of ID's, instead you join OR and OR.
Hope this helps!
You can use this tool to build queries with "In Clause" for string fields : http://cvndynamicstools.azurewebsites.net/Tools/InQuery
Business Applications communities