Well the problem I have is like this, the first is that I do not have access to the database, and the main problem is, I get from this database, data, it turns out that when I get a column with values, they do not respect the numerical order, for example; 1,11,132,145,186,2,22,234,257,3,4. that is an example, it only respects the first digit to the left. Another thing I noticed is that in the db, they use varchars instead of an integer, my question is, if I can not access the database, is it possible to change by means of a filter, or by means of some expression the format? I already tried to call my recordtype, with a cast, but it sends me an error when I do it from my recordlist for filters.
for example
tointeger(recordtypebdd.fields.values) and I get an error...
I hope you can help me.
Discussion posts and replies are publicly visible
When referring to "an error", it is always a good idea to include that error message.
You would also want to sort the data in the DB, before it is transferred to Appian. Changing the field type in Appian will not really help here. Fetching all data into Appian and sorting it in memory is a bad idea.