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. 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.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Enhanced Search Widget Wildcard Search Syntax

MikeVolz

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.

Vind meer berichten getagd met

Accepted answers

RobertScheitlin__GISP

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]_')

All comments

RobertScheitlin__GISP

Slade,

Actually just email it to me.

RobertScheitlin__GISP

Slade,

Attach your whole eSearch.xml.

Amanda__Huber_2-1649875035929.png

SladeBridges

i get the same result, fault 400

ahhhhh, take out the =, my fault

SladeBridges

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

JorgeKappa_0-1649875004941.png

RobertScheitlin__GISP

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>

RhettZufelt_1-1649873417878.png

Submitters can only access their own records.png

RhettZufelt_2-1649873439334.png

Amanda__Huber_0-1649874952097.png

Amanda__Huber_1-1649874979598.png

SladeBridges

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

SladeBridges

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.

RobertScheitlin__GISP

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...

SladeBridges

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.

SladeBridges

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

RobertScheitlin__GISP

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?

SladeBridges

this doesn't seem to work on 3.1

RobertScheitlin__GISP

% 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]_')

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.