Hi Everyone,
I am retrieving column data from db using a!queryselection but need to truncate the values for some columns. Can anyone please help me out, how to achieve this?
Many Thanks!
Discussion posts and replies are publicly visible
What do you mean by truncate? The round off the value or to delete the column data?
Need to remove the last four digits from the values in a column.
You cannot do that with any parts of a!queryEntity. This will happen once you have fetched the data from the DB if you are using a query entity. I will recommend using a custom record field and it will be much more efficient. docs.appian.com/.../custom-record-fields.html