Hi Team,
When I am filtering the record data, I am Geeting error. Pls find below screen shot.
Discussion posts and replies are publicly visible
If record field invcRfrncNMbr is text type, then use {"6010964510","6010867587"}
If record field invcRfrncNMbr is number type, then use tointeger(6010964510,6010867587) or {tointeger(6010964510,6010867587) }
invcRfrncNMbr is text type, but in i am passing. a integer value
If your field is text and your are trying to pass number, system throws an error which you are facing now.
You need to convert the values to text, so that your values will match with the field values.
no data its showing
replace to tostring by touniformstring.
tostring is for single text value.
touniformstring is for text array values.
Then check below things
Even though i pass uniformstring i am not getting data.
The values are not converting to the values in output its showing infinity
Hi Unnam Nageswara Rao ,
It seems, you are storing the value whose size is exceeding Appian allocated value for the integer.
Appian Integer numbers can range from -2,147,483,647 to 2,147,483,647 (or from -231+1 to 231-1 in scientific notation). https://docs.appian.com/suite/help/24.1/Appian_Data_Types.html#number-integer
-2,147,483,647
2,147,483,647
-231+1
231-1
To confirm this you can select Expression under Test Output
When an integer having a value more than its range, and turn that into a string, Appian returns the infinite symbol.
Your numbers are 6010964510,6010867587 which are greater than above range.
In order to proceed with your record query, you need to do the below
1. Change field invcRfrncNMbr data type to text in database
2. Change record field invcRfrncNMbr data type to text
Then query