topic Re: Enhanced Search Widget Wildcard Search Syntax in ArcGIS Viewer for Flex Questions

Enhanced Search Widget Wildcard Search Syntax

MichaelVolz — Wed, 07 Nov 2012 13:20:58 GMT

To All Enhanced Search Widget Users:

I have a search with an ID field of 8 characters where I would like to just have a wildcard for the last character with a requirement of at least 7 characters before the Search is enabled. I would just like to change the config file and avoid modifying the uncompiled action script code, if that is possible.

This is the search I have for matching the end of the user input value, but it allows too many results to be found.
<value prompt="Example: M1234567" isvaluerequired="true">upper(ID) LIKE upper('[value]%')

I have values of say M1234561, M1234562, M1234563, M1234564, M1234565 and M1234559, M1239999, M1230000.

I want to just get back the first 5 values (M1234561, M1234562, M1234563, M1234564, M1234565) if I enter M123456. I would not want the user to be able to search for M123 which would retrieve all of these records. The feature class has thousands of entries so I am currently getting thousands of returns if I am able to perform a search with less than 7 characters.

Re: Enhanced Search Widget Wildcard Search Syntax

RobertScheitlin__GISP — Wed, 07 Nov 2012 13:38:24 GMT

Michael,

OK, what you need to look into is SQL syntax. The % symbol is a wildcard that allows any number of characters to be wild. If you want to limit it to one character than you use _ which says "one wild character"

ArcMap Help documentation:

% means that anything is acceptable in its place: one character, a hundred characters, or no character. Alternatively, if you want to search with a wildcard that represents one character, use _.

<value prompt="Example: M1234567" isvaluerequired="true">upper(ID) LIKE upper('[value]_')

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:11:57 GMT

this doesn't seem to work on 3.1

Re: Enhanced Search Widget Wildcard Search Syntax

RobertScheitlin__GISP — Thu, 03 Oct 2013 14:17:03 GMT

Slade,

That is standard SQL language that is not GIS specific and definitely not widget version specific. It should work in 3.1. What does your expression look like?

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:20:26 GMT

<value prompt="Example: NAME">upper(NAME) = upper ('[value]')</value>

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:29:02 GMT

Slade,

That is standard SQL language that is not GIS specific and definitely not widget version specific. It should work in 3.1. What does your expression look like?

Robert,
I simply want a wildcard, i realize this post is actually for limiting the returns after the initial user input.

Re: Enhanced Search Widget Wildcard Search Syntax

RobertScheitlin__GISP — Thu, 03 Oct 2013 14:30:41 GMT

Slade,

OK, I am not sure what your expression has to do with this forum post then. You do not seem to have any wild card or a like in the expression at all...

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:32:43 GMT

Slade,

OK, I am not sure what your expression has to do with this forum post then. You do not seem to have any wild card or a like in the expression at all...

yes, as i indicated, i want to be able to use a wildcard in my search. as you noted, i do not have one. when i use the syntax above my search widget fails.

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:35:03 GMT

when i do this: <value prompt="Example: NAME">upper(NAME) = LIKE upper ('%[value]%')</value>, i get the fault code 400

Re: Enhanced Search Widget Wildcard Search Syntax

RobertScheitlin__GISP — Thu, 03 Oct 2013 14:37:10 GMT

Slade,

OK, from your first post it sounded like you had already tried to add a wild card to your expression and it was not working.

Here is what you are looking for.

<value prompt="Example: NAME">upper(NAME) LIKE upper('[value]%')</value>

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:38:30 GMT

Slade,

OK, from your first post it sounded like you had already tried to add a wild card to your expression and it was not working.

Here is what you are looking for.
<value prompt="Example: NAME">upper(NAME) LIKE upper('[value]%')</value>                         

i get the same result, fault 400

Re: Enhanced Search Widget Wildcard Search Syntax

SladeBridges — Thu, 03 Oct 2013 14:39:51 GMT

i get the same result, fault 400

ahhhhh, take out the =, my fault

Re: Enhanced Search Widget Wildcard Search Syntax

RobertScheitlin__GISP — Thu, 03 Oct 2013 14:42:01 GMT

Slade,

Attach your whole eSearch.xml.

Re: Enhanced Search Widget Wildcard Search Syntax

RobertScheitlin__GISP — Thu, 03 Oct 2013 14:47:20 GMT

Slade,

Actually just email it to me.