Forum Discussion

FrancescoGallar's avatar
FrancescoGallar
Qrew Member
2 years ago

EX case sensitivity

While searching for data through the API I realized that the EX query is case sensitive.
In my specific table, this returns nothing:

"{'6'.EX.'JOHN DAVIS LLC'}"


while this returns a record:

"{'6'.EX.'John Davis Llc'}"

Is there a way make a search non-case sensitive?
Thanks,

// Francesco

------------------------------
Francesco Gallarotti
------------------------------
APIs and custom code

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    The low tech way would be to create a new field called [Company Upper Case] with a formula of

    Upper([Company])
    Then the .EX. will work as everything will be in upper case.  That Upper function does not change numbers or special characters so it's safe.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JeffPeterson1's avatar
      JeffPeterson1
      Qrew Captain
      2 years ago
      I think you can use CT (contains) instead of EX (exactly) as well.

      ------------------------------
      Jeff Peterson
      ------------------------------