topic Re: Syntax for eSearch widget in ArcGIS Viewer for Flex Questions

Syntax for eSearch widget

SimonMorgan — Thu, 07 Mar 2013 03:19:58 GMT

I have a joined field I would like to reference in the easearch widget. I have a table joined to my GIS layer from a database in another instance. The join exists within the map. The field in the rest endpoint is called :

maximo_production."EARTH\GIS".%GIS_NurseryFlat.nORth_itemnum

How do I add this given it has quotes within it and a \?

Re: Syntax for eSearch widget

RobertScheitlin__GISP — Thu, 07 Mar 2013 11:24:05 GMT

Simon,

Try using:

<field name='maximo_production."EARTH\GIS".%GIS_NurseryFlat.nORth_itemnum' visible="true" gridfield="true"/>

BTW using quotes is not really a good DBA practice.

Re: Syntax for eSearch widget

SimonMorgan — Fri, 08 Mar 2013 04:58:51 GMT

Simon,

Try using:
<field name='maximo_production."EARTH\GIS".%GIS_NurseryFlat.nORth_itemnum' visible="true" gridfield="true"/>
BTW using quotes is not really a good DBA practice.

I am aware this is not a good practice, and in fact I did not do it. The table in question is actually a view in my Maximo database (IBM asset management system). When I look at that view from any non GIS client, I do not see the "EARTH\gis." But when I publish it as a service, the REST endpoint adds the user name it is using, to access the view, to the field name as part of the join.

I have tried bringing the view into my GIS database as a cross-instance view. In this case, I do not get the "EARTH\gis" but the join does not work within the flex viewer. I will post again with whether the above worked.

Re: Syntax for eSearch widget

SimonMorgan — Fri, 08 Mar 2013 05:15:20 GMT

I am aware this is not a good practice, and in fact I did not do it. The table in question is actually a view in my Maximo database (IBM asset management system). When I look at that view from any non GIS client, I do not see the "EARTH\gis." But when I publish it as a service, the REST endpoint adds the user name it is using, to access the view, to the field name as part of the join.

I have tried bringing the view into my GIS database as a cross-instance view. In this case, I do not get the "EARTH\gis" but the join does not work within the flex viewer. I will post again with whether the above worked.

Unfortunately, you suggestion did not work. I get an error that says "Invalid or missing input parameters" "Fault code 400"

I think I need to figure out how to do this join such that ArcGIS does not add the quoted user name.

Re: Syntax for eSearch widget

SimonMorgan — Fri, 08 Mar 2013 13:19:27 GMT

I got it figured out, I managed to setup a database authenticated user. This now makes the field appear in the REST endpoint as maximo_production.user.fieldname without any quotations, thanks for your help.

Re: Syntax for eSearch widget

RobertScheitlin__GISP — Mon, 11 Mar 2013 20:04:35 GMT

Ry,

Did you try Simon's fix of setting up the database connection for the join using database authentication instead of windows authentication?

Re: Syntax for eSearch widget

AnthonyGiles — Mon, 11 Mar 2013 20:16:28 GMT

Ry,

You can set the updategeometry tag to false in the edit widget so that users cannot change the geometry of features when editing:

http://resources.arcgis.com/en/help/flex-viewer/concepts/index.html#/Edit_widget_tags/01m30000000v000000/

Regards

Anthony