235
I have some records returned by a fetchxml.
I need to query same entity's records for user but exclude records got in above step via fetchxml.
Can you please guide how to do it ? I have tried Linq but probably Linq don't support Not-in and Contains with CRM
Share
Report var resutl3 =Context.CreateQuery("contract")
.Where(a => !results2.Entities.Contains(a.Attributes["contractid"]) ).ToList() ;
Kindly guide how I can write such a query.
Thanks
*This post is locked for comments
Hey,
There is a request that can convert a FetchXml request to a QueryExpression, see here: msdn.microsoft.com/.../hh547457.aspx
There is a builder for FetchXml queries: http://fxb.xrmtoolbox.com/
I would suggest to use this only for analysing how the corresponding query expression would look like, not for production use. You could of course just use plain FetchXml, but I would recommend to learn using QueryExpressions for the long term, since they are effective and the Visual Studio Intellisense helps you a lot, which it doesn't for FetchXml.
Kind Regards,
Florian
Hey there,
I like using CrmContext most when working early bound using classes generated by the CrmSvcUtil (msdn.microsoft.com/.../gg327844.aspx). If there are complex queries that include referenced entities however, QueryExpressions are more flexible. In most other cases I also use QueryExpressions, since they are flexible and good to use. I like FetchXml most when I want to be able to "stringify" my queries for configuration purposes.
Your safest bet imho are QueryExpressions. The OrganizationServiceContext is nice, especially for querying, however it has some specialities that you have to get used to (tracking and so on) and updating records is often easier using the Organization service.
Nice post regarding queries: www.inogic.com/.../fetchxml-vs-queryexpression
Kind Regards,
Florian
Hey there,
You're right in that the CRM context does not support In / Not In queries. This is however a pure CRM context limitation, Linq itself can handle that perfectly well.
If you have some other filter criteria, you could just apply those filters and call ToList afterwards. After that you can apply your contains / contains not filter, as you have already retrieved the records with ToList, so that all following filters will be applied locally.
So this would execute without errors:
All responses (
Answers (
var result = context.CreateQuery("contract")
.ToList()
.Where(a => !results2.Entities.Contains(a.Attributes["contractid"]) )
.ToList();
However if you don't have prefilters, like above, this is not a good idea performance wise, as it will retrieve all contacts from CRM, which can be quite a lot. In this case, either use a QueryExpression in combination with RetrieveMultiple, or FetchXml.
Kind Regards,
Florian
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156