FIlters in listgrid

[swatiagarwal]

Hi,

SmartClient Version: v11.0p_2017-02-11/PowerEdition Deployment (built 2017-02-11)

I am using a listgrid with filters. Is there a way to show dropdown in filters for each field where the dropdown contains all the values in the corresponding column.

[Blama]

Hi swatiagarwal,

assuming that this is data and not IDs where you already have a lookup table, you have to do sth for that:

1. New operationBinding in the DataSource of your ListGrid.
2. groupBy clause (for unique values)
3. Use that as optionDataSource and optionOperationId for the filterEditorProperties of the corresponding ListGridField.

Best regards
Blama

[swatiagarwal]

Thanks Blama. But i am not able to understand. Basically if a column in listgrid has values - A,A, B, C,C . Then in this case the filter should be a dropdown with options - A, B, C.
I am using ds.xml to bind listgrid to server side POJOs.

[Blama]

Yes, that's what I meant with unique. You only want A,B,C, so you need a way to make them unique. The linked doc shows how. The rest is basic filterEditor stuff you surly did before.