Hi,
From the below screenshot in the Dropdown filter i am selecting "TEST" where every letter is capital so in the below grid the data has to display only the data which is exactly match the "TEST" filter but it is also displaying irrespective of case insensitive which means data like "test" also getting filtered & displaying the data in the grid. But we want exact match we are selecting in the dropdown filter that data only needs to display in the grid. Kindly Suggest on this
Grid Filter Code:
Grid Row Value:
Discussion posts and replies are publicly visible
Hi ashwinir5622 ,
If your dropdown values are in UPPER case in the query filter convert the ri!caseID to Upper and Lower and pass them in value so in the list if it has lowercase or uppercase you will the filtered data. This is one approach as per your code
Hi JayaPrakash Ravipati ,
Thanks for the response,
I am not getting it. Would please give me an example
the field ri!CaseId is integer or text. If it is text you are using "in" operator you can have like
Value:upper{(ri!caseId), lower(caseId)} in the record filter. So if the data has lower or upper case it will fetch the related data.