my forms have always start parameters. There are filled from the user on start or from another form. These parameters (can be required or not) are used to build a FixedFilterCriteria of a XPServerCollectionSource. This is the master source for the form and is connected to a GridControl. After start I am setting the same param's values in the filter row of the GridView and the GridView.ActiveFilterCriteria to the XPServerCollectionSource.FixedFilterCriteria. Now some questions:
1. How to allow, when user change a field in the filter row and this field is used from XPServerCollectionSource.FixedFilterCriteria, to change XPServerCollectionSource.FixedFilterCriteria and sync it with the GridView.ActiveFilterCriteria?
I have read in the questions here, that you combine both criteria. I have tried with '&', but if there is the same field in both criteria (for sample "part_nr") it is not replaced but added to the where condition.
As far as I understand, you need to synchronize the XPServerCollectionSource.FixedFilterCriteria with GridView.ActiveFilterCriteria after a user has changed the latter. You can do this in the GridView.ColumnFilterChanged event handler. If I misunderstood your scenario, please describe it in greater detail.
Is your intention to post an answer to your own question?
- If so, then proceed.
- If you simply wanted to post additional information, ask for further clarification, or to just say "Thanks!", please click Leave a Comment.
- If you wish to edit your original question, please use the Edit button in the Toolbox at the top right corner of that entry.