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; } } }

Syntax for eSearch widget

SimonMorgan

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 \?

Vind meer berichten getagd met

Accepted answers

SimonMorgan

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.

All comments

AntGiles

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

rscheitlin

Ry,

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

SimonMorgan

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.

SimonMorgan

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.

SimonMorgan

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.

rscheitlin

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.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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