Quirky Search Issues with Parks Finder 10.2

[CraigMcDade]

I'm getting some quirky behavior when searching by park name in the Parks Finder 10.2 application.

For some letter combinations, the parks show up at 1 or 2 letters entered, however for others, the parks don't show up at all even though the combinations are valid. Additionally, some parks aren't being found when their full names are entered.
[ATTACH=CONFIG]31547[/ATTACH][ATTACH=CONFIG]31548[/ATTACH]
[ATTACH=CONFIG]31549[/ATTACH][ATTACH=CONFIG]31550[/ATTACH]

I tried this over on the Local Government Forum but there doesn't seem to be much activity over there. Any help is appreciated.

[Anonymous User]

Original User: jeff.pace

looks like your query is set up to be case sensitive

[CraigMcDade]

I thought about that but I get the same results if capitalized or any combination of capitals/lower case.

[Anonymous User]

Original User: jeff.pace

try rebuilding the index on name field of your source data

[CraigMcDade]

I rebuilt the attribute index but have the same results. Thanks for the suggestion.

[Anonymous User]

Original User: jeff.pace

Rats ok that was the easy answer

Is your rest end point public? Have you tried doing the query there to make sure you are getting the results you think you should?

[JeffPace]

The locate park by name function is doing this query

query.where = "UPPER" + "(" + nameAttribute + ")" + " LIKE '%" + dojo.byId("txtAddress").value.trim().toUpperCase() + "%'";

I am not sure what the "txtAddress" item is, but you can try that query directly on the rest endpoint.

[Anonymous User]

Original User: mcdade31

the rest is public:
http://bcc.marioncountyfl.org/arcgis/rest/services/Dynamic/ParksNew/FeatureServer/0

I'll see if it responds there, I'd assume it will because the parks are obviously in the database (since they can be seen with one character searching)...

[CraigMcDade]

so it looks like certain letter combinations are triggering something to go wild on my firewall and those queries are getting blocked by our forefront management.

Off to talk to the server team.

[Anonymous User · Accepted solution]

Original User: jeff.pace

query

UPPER(NAME) LIKE '%BE%'

fails (blocked by your security
http://bcc.marioncountyfl.org/arcgis/rest/services/Dynamic/ParksNew/FeatureServer/0/query?where=UPPE...


query

UPPER(NAME) LIKE '%VETERANS%'

http://bcc.marioncountyfl.org/arcgis/rest/services/Dynamic/ParksNew/FeatureServer/0/query?where=UPPE...

works


You likely need a sql injection firewall exception in your firewall rules