Skip to main content
A
ashwinir5622
May 22, 2024
Question

Grid has to display data in Case Sensitive based on selection in the dropdown filter

  • May 22, 2024
  • 8 replies
  • 0 views

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:

8 replies

V
vyshnavin653512
May 22, 2024

For case sensitive filters you have to use "=" or "<>" operators.

A
ashwinir5622Author
May 23, 2024

Hi [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] & [mention:1c6f36915a6c4d3a8444dd997b2ebc07:e9ed411860ed4f2ba0265705b8793d05] ,

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

mikes0011
mikes0011
Brainy
May 23, 2024
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.

jayaprakashr0001
jayaprakashr0001
Participating Frequently
May 22, 2024

Hi [mention:bfd227c27aea444eb49c1c9c963d1ba5:e9ed411860ed4f2ba0265705b8793d05] ,

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

A
ashwinir5622Author
May 23, 2024

Hi [mention:44bed26f1d96482687e4003414c7d8ec:e9ed411860ed4f2ba0265705b8793d05] ,

Thanks for the response,

I am not getting it. Would please give me an example

jayaprakashr0001
jayaprakashr0001
Participating Frequently
May 30, 2024

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.

Terms & ConditionsAccessibility statement