Spectrum Spatial (SSA/LIM)

Expand all | Collapse all

Admin defined queries

  • 1.  Admin defined queries

    Posted 02-06-2020 17:24
    It looks like the admin defined queries are case-sensitive by default . Is it possible to change it? I didn't see any options when I create the query. Thanks!


    ------------------------------
    Shaw Shang
    Tablelands Regional Council
    Atherton
    ------------------------------


  • 2.  RE: Admin defined queries

    Posted 02-24-2020 20:41
    Edited by Duri Bradshaw 02-24-2020 20:42
    Hi Shaw,

    If you are running SS 2019.1 you can force the query to evaluate in lower case by setting both sides of the WHERE clause with the lower() function.

    eg
    SELECT * FROM "/demo-data/demo-parcels" WHERE lower(CAD_TYPE) in (lower(@CAD_TYPE))

    This will not work in any version prior to 2019.1 as you need to use the new parameterised queries.

    ------------------------------
    Duri Bradshaw
    Spatial IT Consultant
    Insight GIS
    ------------------------------