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.

Najděte více příspěvků označených jako

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

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

SladeBridges

this doesn't seem to work on 3.1

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

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

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.

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,

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.

SladeBridges

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

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

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

SladeBridges

i get the same result, fault 400

ahhhhh, take out the =, my fault

RobertScheitlin__GISP

Slade,

Attach your whole eSearch.xml.

Amanda__Huber_2-1649875035929.png

RobertScheitlin__GISP

Slade,

Actually just email it to me.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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