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
Can you maybe add a screenshot of the datasubset you are getting from the DB? I want to see if these values are in a single field or they come as a list.
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.
Add a custom record type field and cast this field data as integer. Hope this will works.
Hi I tried with record type you can use like this...