I am getting error in record type filter.

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

1. Please check whether the data present in the record for field invcRfrncNMbr. 
2. Please check whether the data present for field invcRfrncNMbr in the database table which is source for your record.
3. If data present in database table and not present in record, sync the record.
4. Check if you have access to Record and Datastore
5. Verify the data types for the field invcRfrncNMbr are same across database table and record

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

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

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?

I have resolve the issue.

Thank you @everyone for your support. 

 Unnam Nageswara Rao 

Please verify the answers which helped you above to close the thread.

 Unnam Nageswara Rao 

Please verify the answers which helped you above to close the thread.