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 !
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.