Filter String data types with "<" and ">" on a listpage

(0) Share

Report

Posted on by DJRM

1,447

Hi AX people,

As we all know, the field, "Priority" of the table smmLeadTable has a data type of STRING. Basically, my client wants to be able to filter Priorities having less than 30 (Meaning, on the listpage, hit Ctrl+G, type "<30" on the Priority column), but this will be unpredictable simply because the said field is string and not numeric (integer, real, etc.). My solution is to just change the data type from string to int on the smmLeadPriorityTable and smmLeadTable, so using mathematical filter criteria like "<30" or ">=100" will work fine. However, I think that this will have impact on AX. To see what I mean, go to Sales and Marketing > Common > All Leads, hit Ctrl+G and type "<30" or any value on the Priority column of the listpage and you'll see that the filtered results are wrong (the listpage will show values of Priority less than 30 but will also show values greater than 30. What do you think of my solution? I think that this problem is invalid because the user wants to do mathematical filtering on a field that is string data type.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi DJRM,

Check if there's no modification done in your environment? Works completely fine by default using above mathematical filtering in all forms and the results are correct. Except >=100 ... I would suggest to use >100,100 instead.

Regards,

V

Was this reply helpful? Yes No
DJRM 1,447 on at

Like (0)

Report
Copy link

Link copied!

No, there are no customizations. I even replicated this issue by creating new table and form. See below:

1) Here, I’ve created a form that has 2 columns, the column A has INTEGER data type, and the column B has STRING data type. Notice how AX correctly filters data on the first column.

2) Now, trying to filter on Column B, let’s do “<60%”. The expected result is that the rows that are less than 60 should appear and the rest shouldn’t. Notice that the last two rows are also displayed even though we entered a filter criteria.

This is because the field’s data type under column B is STRING, and AX is treating the values as string literals. What I want to do is without changing the data type of column B to integer (so that < 100, > 100, etc. will work fine), is to make the grid display the correct filtered data which is expected by the user. It's really hard to explain this to the user because what he/she wants is problematic in AX.

Was this reply helpful? Yes No
Muhammad Burhan Zahoor 145 on at

Like (0)

Report
Copy link

Link copied!

You have to use "save as cue" to add & view the record.

Was this reply helpful? Yes No
Rati Sharabidze 612 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can't filter a string like an integeer (number filtering). In your case, you are filtering it lexicographily, which means that such filter can even show 599999% because the char 6's code is more than the char 5's code. if you want to filter percents, make a new field for it or a computed column. Display methods can't be filtered.

Best regards

Was this reply helpful? Yes No