Custom filtering in grids

(1) Share

Report

Posted on by Jason0810M

Hello,

I have a scenario in which I have added a FormComboBox control to filter in a grid.

I have added a logic in the Modified method of the control to clear and add range whenever the user is changing the control value.

I then made the form data source execute query call.

However, I have noticed that if ever I have manually added a range on another field via the form UI (i.e. right clicking on the grid field value and used the UI to apply a filter), then the said range is being cleared when I change the combo control value.

Example of my scenario. The table is a TSTProductTable. The combo control is filtering on ProductType field. If ever the user manually filters on the ProductId, then the filter on the productId needs to be applied whenever the control value changes.
Is there any way to do it such that any other manually applied filter is still being applied?

All responses (1)

Answers (1)

Verified answer

Martin Dráb 230,379 Most Valuable Professional on at

Like (0)

Report

Custom filtering in grids

It seems that you delete all ranges in your code. Stop doing it if you don't want it.

Instead of clearing all ranges, you may want to use findOrCreateRange() for your field. If a range exists, you'll change its value, instead of removing the range and creating a new one.

The safest solution is deleting all ranges for the field, because there could be more than one. But it's questionable whether you need this more complex approach.