Prevent auto-search/filter that occurs after editing cells/rows?

[Stephen]

RadGridView, for WPF .NET Framework 4.8, automatically hides rows that do not match the filter/search criteria after a row has been edited. How does one prevent the auto-filtering/searching?

A very important workflow for our customers is to search / filter for outliers and then edit the found rows. After they finish editing, they don't want the row to automatically disappear because of the search / filter doesn't match the row after the edits.

The customer only wants to search / filter if they actually initiated the action. They do not want auto searching and filtering.

[Stenly]

Hello Stephen,

I am not sure that I fully understand this requirement. Is there any possibility of sharing a bit more information about it?

[Stephen]

• Imagine a RadGridView with 1000s of rows.
• Someone tells you there is an issue with some of them.
• The rows in question have a specific value in a specific column that needs to be changed.
• There may be other issues with these rows too. So, you need to inspect all the cells for the rows in question and fix up whatever needs to be fixed.
• In the grid, you use the filter to narrow down the rows to edit.
• You edit a cell to fix an incorrect value. As soon as you move off that row, RadGridView hides it because it no longer matches the filter criteria.
• You would have like to have reviewed the rest of the cells in the row, you just changed but, RadGridView just filtered it out.

This isn't just some random request either, basically all our customers are displeased with this behavior. They only want filtering and searching if they initiated it, i.e. no auto filtering or searching.

[Stephen]

If it helps, users don't want auto-grouping, nor auto-sorting. They just want the rows to remain where they are when they are editing. And yeah, I know, the grid doesn't auto-filter/search/group/sort until after the user moves off the row but it is a wild stretch to expect users not to do that, especially if they are editing multiple rows.

[Stenly]

The RadGridView control does not provide an option to prevent the cells from being filtered out when they no longer match the filter criteria. After an edit operation is performed, the filters will be refreshed, which is the default behavior of the control.

With this being said, what comes to my mind would be to disable the filtering part when performing a search operation. This way, the required items will only be highlighted and after they are edited, they will not disappear.

To learn more about this suggestion, check this article.