Today, I was working with LinkEntity for ‘PartyId’, So I want all appointment where specific account or contact is in the required field and is connected to a specific entity. Thus, I created 3 appointments on the entity and wrote following query…
Many times we need to joins with filters in one entity or both of them. Here is the simple sample …
Error: Key not found in Link Entity QueryExpression (Ref above image).
Generally, CRM not works alone, it includes many other application, such time we needs to move data from one application to another. In this situation we needs integration; We do integration with either “HttpWebRequest” or “BasicHttpBinding”.
We can create Rollup Queries using CRM SDK (plugin or workflow or some external tool). In this entity, MS CRM provided similar to advance find capability for Query attribute, CRM stores it in database as ‘fetchxml’ attribute in fetch-XML (XML) format.
Its walk-through for deactivating all associated (1:N) records. Steps for that are Create plugin Register and create steps Create plugin
Querying SQL database all the time may affect performance so some time we can pull the generic data and then query on that result collection may give better result. Here is the example of it,