topic Re: Quirky Search Issues with Parks Finder 10.2 in ArcGIS JavaScript Maps SDK Questions

Quirky Search Issues with Parks Finder 10.2

CraigMcDade — Tue, 18 Feb 2014 12:10:03 GMT

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.

Re: Quirky Search Issues with Parks Finder 10.2

Anonymous User — Tue, 18 Feb 2014 12:12:53 GMT

Original User: jeff.pace

looks like your query is set up to be case sensitive

Re: Quirky Search Issues with Parks Finder 10.2

CraigMcDade — Tue, 18 Feb 2014 12:22:31 GMT

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

Re: Quirky Search Issues with Parks Finder 10.2

Anonymous User — Tue, 18 Feb 2014 12:28:20 GMT

Original User: jeff.pace

try rebuilding the index on name field of your source data

Re: Quirky Search Issues with Parks Finder 10.2

CraigMcDade — Tue, 18 Feb 2014 14:22:05 GMT

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

Re: Quirky Search Issues with Parks Finder 10.2

Anonymous User — Tue, 18 Feb 2014 15:26:17 GMT

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?

Re: Quirky Search Issues with Parks Finder 10.2

JeffPace — Tue, 18 Feb 2014 15:31:04 GMT

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.

Re: Quirky Search Issues with Parks Finder 10.2

Anonymous User — Tue, 18 Feb 2014 16:45:26 GMT

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

Re: Quirky Search Issues with Parks Finder 10.2

CraigMcDade — Tue, 18 Feb 2014 16:52:34 GMT

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.

Re: Quirky Search Issues with Parks Finder 10.2

Anonymous User — Tue, 18 Feb 2014 16:58:06 GMT

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=UPPER%28NAME%29+LIKE+%27%25BE%25%27&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&gdbVersion=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&f=html

query

UPPER(NAME) LIKE '%VETERANS%'

http://bcc.marioncountyfl.org/arcgis/rest/services/Dynamic/ParksNew/FeatureServer/0/query?where=UPPER%28NAME%29+LIKE+%27%25VETERANS%25%27&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&outFields=&returnGeometry=true&maxAllowableOffset=&geometryPrecision=&outSR=&gdbVersion=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&f=html

works

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

Re: Quirky Search Issues with Parks Finder 10.2

JeffPace — Tue, 18 Feb 2014 18:09:38 GMT

Looks like we figured it out at the same time

Im in Manatee County just a couple hours down I-75

Re: Quirky Search Issues with Parks Finder 10.2

Anonymous User — Wed, 19 Feb 2014 11:29:24 GMT

Original User: mcdade31

thanks for your help. glad to know there are some florida locals on here.