Hi,
I am working on NG Client and creating UI which is utilizing Servoy NG-Grids -> DataGrid.
Foundset which is bound to DataGrid contains following fields of interest:
[*] Text field (for Title of product.)
[*] Text field (for description/detail of product)
[*] Number (for stock quantity available)
[*] Date (for date of last stock updated)
[*] Number (for Product Status. On datagrid, text is being displayed. The text displayed is based on valuelist bound to this column. E.g. 0 maps to Discontinued, 1 maps to Local, 2 maps to Imported, etc.)
I have successfully mapped these fields in DataGrid and it displays my data as required.
On datagrid, when i tried to use Filter on Product Status column using display values(As mentioned earlier, this column is using valuelist), it failed to filter data and all data was eliminated which reflects no data matched. However, when I tried to use Filter using real column values which are stored in column(not display values), it worked.
While the requirement is to provide user with functionality to use Filter based on display values not real values.
Note: I have tried changing FilterType to Number and Text for this column separately, but same result.
Any assistance in resolving above will be highly appreciated.
Thanks