topic Re: Search Widget Expressions in ArcGIS Viewer for Flex Questions

Search Widget Expressions

WalterDziuba — Tue, 18 Mar 2014 14:50:38 GMT

Is there a definitive reference manual that describes how to use the expression builder when you're trying to use
the search widget?

As an example, I'm trying to get this to run, but I keep getting a yellow triangle with an exclamation point indicating something is wrong with my expression.

BUILDINGTYPE like '[Apartment]'

Walter

Re: Search Widget Expressions

RobertScheitlin__GISP — Tue, 18 Mar 2014 15:21:18 GMT

Walter,

your expression should look like this:

BUILDINGTYPE like '[value]%'

The widget will always replace the [value] with what the user types in the input box.

When using a like expression you normally will want to specify a wild character such as the % symbol.

As far as a manual you knowing what to type... No there is not one. It is just basic SQL query syntax.

From the documentation:

Tip:'[value]' is a literal value that needs to be specified in the expression. The apostrophe's are needed if working with string values.

Re: Search Widget Expressions

WalterDziuba — Tue, 18 Mar 2014 16:16:21 GMT

Robert,

That's great thanks. But if you wanted to preset the value:

So rather than have a value that the client has to input, then could I not use this to find bulding types that have attribute values of "Appartment"

BUILDINGTYPE like '[Apartment]%'

Walter

Re: Search Widget Expressions

RobertScheitlin__GISP — Tue, 18 Mar 2014 16:52:51 GMT

Walter,

Sure just do not use the square brackets: App builder will continue to give you a warning (I think) but you can just ignore it.

BUILDINGTYPE like 'Apartment%'

Re: Search Widget Expressions

WalterDziuba — Tue, 18 Mar 2014 17:52:03 GMT

Robert,

Didn't realize that my BUILDINGTYPE was a domain with only coded values. So to use the word "Apartment" made no sense to Flex. But when I changed the value to "2" which equals Apartments, it worked like a charm.

Thanks again.....Walter