Multiple data type filter inside data grid2

0
Hello team , I’m working on datagrid2 filters . In grid one of the column is having a integer field . For that column I’m using a number filter . Here what is the problem is some data’s are ending with -1 . Like 187956-1 . If I enter this value in the filter simply it is showing all values in grid . Means the filter is not working in the column . Do we have a any other widget in mendix, It will support all types of data and we need to use inside the datagrid . Means in the filter section of each and every column . Can anyone please help on this ?   Thanks in advance !
asked
2 answers
0

Hi Vinodhini,

 

Happy to help! Are you sure you are using an integer? To my understanding, the example you give (187956-1) should be a string, not an integer. I would suggest to change that field to a string and use the datagrid filter on strings, not on integer.

 

Hope this helps and good luck! :)

answered
0

Hi Vinodhini, 

 

Use Text filter with equals 

answered