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
https://docs.appian.com/suite/help/24.1/fnc_system_a_queryfilter.html#case-sensitivity-on-record-types-with-data-sync-enabled
For case sensitive filters you have to use "=" or "<>" operators.
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 Stefan Helzle & Vyshnavi Naripeddi ,
Thanks for the Response.
I need to have multiple case id to be filter in such situation the operator "=" will not work right. So i want to check the case sensitive for array of values
Hi JayaPrakash Ravipati ,
Thanks for the response,
I am not getting it. Would please give me an example
ashwinir5622 said:I need to have multiple case id to be filter
Then you can use a Logical Expression with the "OR" operator and a list of Query Filters (all using "=") that loops over your input list of dropdown items.
Did you consider to fix the problem in the database? Do you have control on the values entered in this field?
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.