Get Ready for the Next Release of Microsoft Dynamics CRM
Problems configuring the CRM Outlook client? Use the wizard!
Customer Center for Microsoft Dynamics CRM 2013
Customer Center for Microsoft Dynamics CRM 2011
Technical Support FAQ: Online | On-Premise
Developer Center and SDK
Does anyone know the limit for the amount of values that can be put in the 'In' filter in Fetch XML?
Blog: http://blog.sonomapartners.com Twitter: https://www.twitter.com/bscarlav
The "In" filter should translate directly to SQL's "In" statement, and according to this reference, there is only the limitation of the query's total size: stackoverflow.com/.../mysql-in-condition-limit
The "condition" limitation, as identified in the materials Vijay presented, would apply if you were simulating "In" with a bunch of "Or" grouped conditions--which is terrible form--and I suspect you knew that when asking about "In".
I've used "In" successfully up to 8000+ references; and haven't found a limit yet. Again, according to the SQL documentation, the limit will likely be with the total size of the query message, rather than the number entries in the "In" set.
Please refer below URLs for help.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics