topic Re: Query SQL Expression without input in ArcGIS Experience Builder Questions

Query SQL Expression without input

PriscillaThoopthong — Mon, 26 Aug 2024 14:15:12 GMT

I would like to be able to query something like this:

If the owner or the secondary owner contain the input value

without the user having to enter the value in both places. So one input, but it searches both owner and secondary owner.

Re: Query SQL Expression without input

ToddW_stl — Mon, 26 Aug 2024 15:28:25 GMT

hi @PriscillaThoopthong - the question is a bit vague - where and how are you trying to implement this query? I would think something like this could work:

OWNER1 LIKE '%partial_string_search%' OR OWNER2 LIKE '%partial_string_search%'

Here's the SQL reference for query expressions for additional reference.

Re: Query SQL Expression without input

PriscillaThoopthong — Mon, 26 Aug 2024 21:01:14 GMT

Thanks Todd. This is in Enterprise Experience builder. There is no option to actually type the SQL. I am building the query with the UI. There doesn't seem to be a way to type the SQL. When I add the query, it displays the SQL like this:

but this causes two input boxes to be displayed to the user. One for the Owner and one for Second Owner. I want one input box, but want to search both fields for the same value that the user enter.