i am having a record with the data 2million rows. And in our db table we don't have primary key so we created a custom primary key using multiple fields in the table
when i am trying to fetch the data from records i am getting the value when i am using includes operator in filter
but when i am trying to fetch the data from records i am not getting the value when i am using equal to operator in filter.
Discussion posts and replies are publicly visible
Hi sairam satyanarayanam0001,
The value in plnrcd is "4T ". which is 3 characters. So if you test with "4T" in equal to operator, it wont work as "4T " is not equal to "4T".
Since its a text, includes worked in this scenario.
thanks