topic Re: eSearch widget fails to display results, xml syntax error ? in ArcGIS Viewer for Flex Questions

eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 15:37:14 GMT

I am using ArcGIS Viewer for Flex Application Builder version 3.6 with build date 2013-12-13. The eSearch (version 3.6.1) widget in my Collision Application is not throwing errors but fails to display results. I can tab through the "text", "spatial", and "graphic" options but basically it locks up the application. Could someone help get me back on track? I have included the eSearch xml and a graphic of the "results" page. The "results" page does show the number of selected features.

Re: eSearch widget fails to display results, xml syntax error ?

RobertScheitlin__GISP — Wed, 05 Nov 2014 15:52:40 GMT

Dorothea,

Do any of the searches work or is it just one that has the issue? I notice that in the url you have "arcgissecure" does that mean that these map service layers are secured? If so then are you getting the secure login prompt when querying these layers, since you do not have a token defined for them?

Re: eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 18:58:37 GMT

The "arcgissecure" is part of our internal user Authentication. This Flexviewer app is not public facing.

The portion that is working: searching the 'Route Centerline' by a road name, switching to 'Spatial Search' and applying a search distance of 10' to catch any collisions not snapped to road, then search entities of 'Collisions' and using search option 'add to selection' and then clicking 'Entirely contained in' will select all the collisions on that road. The date range search section appears to need help.

Re: eSearch widget fails to display results, xml syntax error ?

RobertScheitlin__GISP — Wed, 05 Nov 2014 19:15:15 GMT

Dorothea,

OK that helps narrow things down a lot. So first question. Is COL_DATE field an actual Date field type?

Re: eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 19:24:03 GMT

Ok, I see where that may be a problem. The 'COL_DATE' and 'COL_YEAR ' both have a Data Type of LONG.

Re: eSearch widget fails to display results, xml syntax error ?

RobertScheitlin__GISP — Wed, 05 Nov 2014 19:28:17 GMT

Dorothea,

Here is an example that I have for querying a true date field:

                <expression alias="Incident date" textsearchlabel="Search Incidents on or after date:">
                    <values>
                        <value prompt="Example: 2012/04/16">datetime >= '[value] 00:00:00'</value>
                    </values>
                </expression>

Re: eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 19:36:03 GMT

You wouldn't have a method for using 'LONG' fields, would you?

How would you go about making this work?

Re: eSearch widget fails to display results, xml syntax error ?

RobertScheitlin__GISP — Wed, 05 Nov 2014 19:42:01 GMT

Dorothea,

So you are saying that your COL_DATE field is a long? I can not say I have ever heard of anyone doing that. So what do values in that field look like then?

Re: eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 19:55:33 GMT

It stems from quite a few years back. We started to maintain a database of all collisions within the County by in-put from hard-copy reports from the CHP. We found our records were much more accurate than SWITERS data.

Re: eSearch widget fails to display results, xml syntax error ?

RobertScheitlin__GISP — Wed, 05 Nov 2014 20:05:32 GMT

Dorothea,

OK so you are just querying numbers then. So the only issue I see is a syntax issue in your XML. You are missing whitespace between your alias attribute and your sort attribute in the COL_Date field tag:

incorrect (syntax error):

<field name="COL_DATE" gridfield="true" alias="COLLISION DATE"sort="asc|1|numeric"/>

Correct:

<field name="COL_DATE" gridfield="true" alias="COLLISION DATE" sort="asc|1|numeric"/>

Re: eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 21:07:12 GMT

Hi Robert,

I added the white space but it still didn't work. I then removed the "operator="AND" in prompt="3" thinking it might make a difference but it still didn't work. I'll have to keep looking.

I really appreciate your help with this.

Re: eSearch widget fails to display results, xml syntax error ?

DorotheaKnigge — Wed, 05 Nov 2014 21:59:00 GMT

Just to let you know how blind I had become.....I just noticed that my 'End Date' prompt in each expression didn't have the '=' character after the '<' !!! With your 'white space' recommendation and the new '=' characters added, my application now works!

Thank you for working with me, it was much appreciated. Dorothea