Eric
  • Eric
  • Member Topic Starter
2016-09-09T15:52:59Z
I was wondering if igridAutofilterManager (or even igrid itself) has a way to filter programmatically. What I Had in mind would be something like a SQL Filter (Like .NET DataTable) where you could write something like " WHERE NAME='Eric' And Country ='US' " or even LINQ to access the row collection directly to filter the rows. One Way that I Have Solved this issue in the past is to keep a 'Copy' of the Datable that fills the iGrid as a member variable on the form to which I Can just Apply the standard .NET SQL filters , then use the fillwithdata() method to repopulate the iGrid with the Dataview of that table. Performance is fine for smaller data sets. I am, however, currently working with data that is well over 100000 rows and also applying row coloring based on rules in the row, so it seems it would be much more efficient to access the igrid filtering capabilities directly. Not sure if that is something Accessible or not? Thanks -Eric
Igor/10Tec
2016-09-10T07:47:36Z
The AutoFilterManager add-on does not support arbitrary queries (similar to the SQL WHERE clause, etc.)

If you need to apply a predefined set of filter criteria, you can prepare them in files using AutoFilterManager's SaveFilterToFile method and then apply to your grid using the RestoreFilterFromFile method.