Adding the IN Operator to Advanced Query Builder
Hi,
Would it be a good idea to have the 'IN' SQL operator added to the Advanced Query Builder, I have been finding it useful for searching for muiltiple values.
Would probably have to add the comma ',' operator as well.
For example
Select * from [QueryLayer] WHERE Field Name in ('value1','value2') or for our land rating id's
SELECT * FROM Parcel Valuation WHERE ASSESSMENT IN ('0771001700','071001600A','081600501')
It works well on our File geodatabase, not sure what kind of performance hit an enterprise geodatabase would take though with too many values.
I guess the other option is to use the global search, but I have'nt been able to get this to work entering values like '0771001700','071001600A','081600501'
0
-
FYI, another option is to use the 'OR' option of the Query builder and include an 'OR' for each 'IN' item
WHERE ASSESSMENT IN ('0771001700','071001600A','081600501') could be transformed into
WHERE ASSESSMENT = '0771001700' OR ASSESSMENT = '071001600A' OR ASSESSMENT = '081600501'
You can now save queries in Essentials Manager and reload them in the viewer so it could potentially be created once and used many times.
Wayne Richard
Latitude Geographics Group Ltd.
Head Office: 300 – 1117 Wharf Street Victoria, BC Canada V8W 1T7
Tel: (250) 381-8130 | Fax: (250) 381-8132 | wrichard@latitudegeo.com
Developers of Geocortex web-based mapping software | www.geocortex.com
An Esri Platinum Business Partner0
Please sign in to leave a comment.
Comments
1 comment