Hi
We are using xamdataGrid which has around 40 columns and we display around 40K rows. The way we designed it users don't have to refresh the Grid. the values will be updated real time.
Basically user opens the screen only once in the morning and keep looking at the data. since we have 40k rows on the screen they need to apply filters to look at the data. We have enabled the filter editors but it is not practical for them to keep changing the filters considering so many columns. they usually filter on some selected columns for there daily needs.
For example, col1 > 0 and col10 < 0 , col 6 > 1M and Name="ABC".
Is there any control where they can build the Filters (similar to your xamFormulaEditor) so that we can save those and provide them a combo where they can select those filters and apply to Grid
Pls advise
Thanks
Hello Kiran,
I have been investigating into your requirement on this matter, and there does not currently exist a "filter builder" alternative control similar to the XamFormulaEditor for usage with the XamDataGrid. The only UI that builds the filters is the built-in filtering functionality to the XamDataGrid.
With the above said, it is possible to persist the filters in the XamDataGrid by using the Save/Load Customizations support. You can read about saving and loading the customizations to and from the XamDataGrid here:
Saving: https://www.infragistics.com/help/wpf/xamdatapresenter-save-field-customizations
Loading: https://www.infragistics.com/help/wpf/xamdatapresenter-load-field-customizations
If you wish to cache the filters that are applied, it may be possible for you to do so by handling the RecordFilterChanged event of the XamDataGrid. This event can net you the RecordFilter object that is applied to your XamDataGrid FieldLayout and is placed in the FieldLayout.RecordFilters collection as it is either created or changed.
Please let me know if you have any other questions or concerns on this matter.
Sincerely,AndrewSoftware Developer
Hi Andrew
is it possible to make the Cross Field Record Filters dialog box(Custom Filter selection dialog) to bring up in a diff place other than on the Grid. We want to give separate button called Custom Filters and bring up the dialog box when user click on it
We want to add a button "Custom Filters" and user clicks on it wants to bring Cross field record Filters dialog box (Custom Filter selection dialog). Can you please advise
Are you looking for the DataPresenterCommands.ShowCrossFieldRecordFilters command which can be passed into ExecuteCommand on the XamDataGrid?