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