How to validate if current row being entered in editable grid already exits in grid

How you differentiating rows? Any unique fields. We got many ways of comparing arrays for example  Contains(). 

How you differentiating rows? Any unique fields. We got many ways of comparing arrays for example  Contains(). 

I tried using whereContains() but it is giving me error,

Expression evaluation error at function 'wherecontains' [line 273]: Invalid types, can only act on data of the same type (Text, Number (Integer))

My line of code is this

count(wherecontains(fv!item['recordType!SMA StudentMarksData.fields.computer'], local!DB.data['recordType!SMA StudentMarksData.fields.computer']) )>0

Niharika said:

can only act on data of the same type (Text, Number (Integer))

Approach is almost good but you lost it in transition .

Isn't this error saying it clearly. Your trying to compare Invalid types. What you are entering in the grid is a text value but what you are getting from Backend to compare is Integer so look into it how data structured in DB and how you are entering it .

Or On grid if you are  capturing  integer value in a text field try wrapping it with tointeger()