I am getting error in record type filter.

Question

Hi Team, 
 When I am filtering the record data, I am Geeting error. Pls find below screen shot.

Dastagiri · Answer

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) }

Dastagiri · Answer

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 
 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

Harsh Kumar Agarwal · Answer

Unnam Nageswara Rao , 
 You need a double quote first before using touniformstring. 
 Have you tried the option I already suggested you in my previous reply to wrap the value in double quote?

Wrap the value in double quotes for text, {"6010964510","6010867587"}. 
 It was a simple fix if you follow the reply already, I will recommended you to go through all the Appian functions/recipes again to get the better understanding of basic SAIL functionality.

Harsh Kumar Agarwal · Answer

Wrap the value in double quotes for text, {"6010964510","6010867587"}.

I am getting error in record type filter.

Top Replies