Filter Descriptor Limit?

[Nick Anderson]

Is there a limit to the number of FilterDescriptors that can be added to the FilterCollection? I seem to be receiveing a StackOverflowException in System.Core.dll if i try to add a significant number.

I need to limit the records in my Grid based upon specific ID numbers, so I am trying to add a filter desciptor for each ID to have it show only those records. My Grid has about 53,000 records, and in one example, I have 17,151 records that I need to display. How can I handle this? It works if i don't have a large number of results (i'm unsure of what the record limit before i get the error is)

I am just declaring a filter descriptor like this:
Dim filterDescriptor As New FilterDescriptor("ID", FilterOperator.IsEqualTo, id)
And then adding it to the collection

[Rossen Hristov]

Hello,

It's not the FilterDescriptors that have a limit. We build a LINQ Where expression from them and LINQ Expressions have their limits apparently.

You can use different filters which use the operators IsGreaterThan or IsLessThan. The general idea would be to "cover" as many data items with one FilterDescriptor in order to avoid this .NET Framework limitation which we can't do anything about unfortunately.

In other words, if you were using pure LINQ, i.e. from myItems select item where ???

how would you construct the where part. There must be a more concise way to express the where clause. FilterDescriptors do the same -- they express the Where clause.

I hope this helps.

All the best,
Ross
the Telerik team

[Nick Anderson]

Okay thanks. Instead of using the FilterDescriptors, I just decided to re-query the data and refill the grid with only the records i wanted.