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?