What is the limit for the amount of values in the 'In' filter in Fetch XML?

What is the limit for the amount of values in the 'In' filter in Fetch XML?

This question is answered

Does anyone know the limit for the amount of values that can be put in the 'In' filter in Fetch XML?

Verified Answer
  • 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.

All Replies