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
------------------------------
Original Message:
Sent: 02-06-2020 17:24
From: Shaw Shang
Subject: Admin defined queries
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
------------------------------