Search Widget Expressions

WalterDziuba

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

RobertScheitlin__GISP

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.