Skip to main content
F
federicam0001
October 11, 2023
Solved

Ignore case sensitive in query record type

  • October 11, 2023
  • 2 replies
  • 0 views

Can I ignore case sensitive in Query Record Type as I do automatically in Query Entity?

The record type I'm using has data sync enabled and I need to put a validation on a text field to give evidence to the user that there is already a line with the string he is typing. I built the validation into an expression rule that invokes the Query Record Type and I noticed that the filter is case sensitive.

Thanks

2 replies

mathieud0001
mathieud0001Answer
Brainy
October 11, 2023

Did you try using in, starts with, and not in?

https://docs.appian.com/suite/help/23.3/fnc_system_a_queryfilter.html#case-sensitivity-on-record-types-with-data-sync-enabled

    F
    federicam0001Author
    October 11, 2023

    Thanks for the answer, I tried with the operator "in" and it works properly.

    Terms & ConditionsAccessibility statement