Discussions

 View Only
  • 1.  EX case sensitivity

    Posted 06-16-2022 11:16
    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
    ------------------------------


  • 2.  RE: EX case sensitivity

    Posted 06-16-2022 11:20
    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
    ------------------------------



  • 3.  RE: EX case sensitivity

    Posted 06-20-2022 14:41
    I think you can use CT (contains) instead of EX (exactly) as well.

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