Hello, I'm trying to configure a search widget to work with my operational data and I'm getting this error: [RPC Fault faultString="Unable to complete operation." faultCode="400" faultDetail="Unable to complete Query operation."] Here's my configuration for the search widget: LegacySites http://dcc-gis/ArcGIS/rest/services/LegacySites/MapServer/0 LegacySite = '[value]' Search by Legacy Site ID [ Example: MB900-020 ]: Use one of the graphical search tools to select Legacy Sites SiteName One question: for the field names should I specify the actual field name of the alias? Thanks, Mark

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

Search Widget Not Working

MarkSmith1

Hello,

I'm trying to configure a search widget to work with my operational data and I'm getting this error:

[RPC Fault faultString="Unable to complete operation." faultCode="400" faultDetail="Unable to complete Query operation."]

Here's my configuration for the search widget:

        <layer>
            <name>LegacySites</name>
            <url>http://dcc-gis/ArcGIS/rest/services/LegacySites/MapServer/0</url>
            <expression>LegacySite = '[value]'</expression>
            <textsearchlabel>Search by Legacy Site ID [ Example: MB900-020 ]:</textsearchlabel>
            <graphicalsearchlabel>Use one of the graphical search tools to select Legacy Sites</graphicalsearchlabel>
            <titlefield>SiteName</titlefield>
            <linkfield></linkfield>
            <fields all="true">
                <field name="LegacySite"/>
            </fields>
        </layer>

One question: for the field names should I specify the actual field name of the alias?

Thanks,
Mark

Vind meer berichten getagd met

Accepted answers

All comments

RocíoVega

Hi!!

Don't worry...thanks for your help and your time...
Yes, the layer Parcels has a join and several relationship classes...and i want to use both...the join field to setup a search and the relates to show in the results table.
Dew

rscheitlin

Rocío Vega,

I am just now getting time to look at this. Is the layer with the join the same layer that has the relates configured as well (i.e. one <layer> parent that has the expression with the join fields and <relates>)?

RocíoVega

Thanks Robert for your time.

rscheitlin

Dew,

I will have to check and see if I can duplicate the fact that relates do not function in my widget when you have a layer using a JOIN.

RocíoVega

Hi Robert!

Thanks for your answer.
One last question...i hope.

So...i asked you about query expression using related field because if i have JOIN the query expression work but the relationship configured dont.....this is an error? exist a way to resolve the problem for me?

thanks!

rscheitlin

Dew,

OK, I think I understand your question now. The answer is no. You can not use a relationship field in a query expression.

RocíoVega

Hi Robert!

Thanks for your answer.

I know the difference within relationship class and join, and i have the two things for the parcels layer.
I have 2 relationshipclass

   <relates>
    <relate id="4" label="Juridico" enableexport="false" icon="assets/images/i_bookmark3.png">
     <fields all="true" />
    </relate>
    <relate id="2" label="Persona" enableexport="false" icon="assets/images/i_demographics.png">
     <fields all="true" />
      
    </relate>

but also, i setup a search using a field from a join between parcel layer and one table (expression with Matricula Inmobliaria)

<expressions>
    <expression alias="Código del Predio" textsearchlabel="Buscar Predio por Código:" isvaluerequired="false">
     <values>
      <value prompt="Ejemplo: 1-1003-00" isvaluerequired="false">CSIT LIKE '[value]'</value>
     </values>
    </expression>
    <expression alias="Nombre del Predio" textsearchlabel="Buscar Predio por Nombre:">
     <values>
      <value prompt="Ejemplo: BUENOS AIRES" isvaluerequired="true">upper(Nombre) LIKE upper('%[value]%')</value>
     </values>
    </expression>
    <expression alias="Matricula Inmobiliaria" textsearchlabel="Buscar Predio por Matrícula:">
     <values>
      <value prompt="Ejemplo: 470-27443" isvaluerequired="true">upper(odlgdb.DBO.PredioJuridico.MatriculaInmobiliaria) LIKE '[value]'</value>
     </values>
    </expression>
   </expressions>

So the problem is ...when i used search with join (for the Matricula Inmobiliaria search) the relationships doesnt work....so i eliminate join and relationships info works...but i need the search....

Question,

can i configurate one expression using a relation - not join field?

Well i hope that you understand me.
thanks!!!

rscheitlin

Dew,

So let me see if I understand correctly because it sounds like you are mixing the use of the terms Relationships and Joins, which are very different terms.

I created a join and I have kept in the mxd map service

If your map service has a JOIN than you have to change the field names to use the fully qualified field name (i.e. parcels.sde.parcelNum instead of parcelNum). See if that is your issue first.

RocíoVega

Hi Robert,
I want to thank you for all your help people like me who are not developers but we want to improve our applications.
I going to bother you with a question
1. I configured the esearch widget with an information layer (Parcels) having several classes relationship. I just need to display information from two of these relationships. Additionally, in this layer I set up a search for an attribute that is in a related table for which I created a join and I have kept in the mxd map service. When I have the join on the map does not show the relationships and get a message that says "no results for this search", if I delete the join if it shows the related tables but could not do my query.
No way to fix this?

I would greatly appreciate if you can guide me to a solution.

Sincerely,
Sorry for my english....

dew

rscheitlin

Emily,

I have not seen this issue before and would suggest a call to esri tech support.

Robert

EmilyLaMunyon

I am joining the table to the feature class (not the other way around) and have retried the join several times with the same result. I am not sure what to do differently. Do you think it is a problem with the way the service is reading the layer? Have you ever seen this before?

As always, thanks!

Emily

rscheitlin

Emily,

Looks like the opposite of what you want is what you published. I would try again and make sure you add the table join to the featureclass. The join issue is definitely your problem with the search widget though, because you can not even do a query from the REST services directory on that layer without error.

EmilyLaMunyon

Thanks for replying Robert.

I am not sure what happend to my service, but the joined, or first 4 in the rest layer are the original fields that I joined to a SQL table. It seems like those should have retained the original names and the rest (SQL fields) should have the joined names. Do you think this is the reason the search is not working?
Emily

rscheitlin

Emily,

I don't see the shape field or ObjectID of the main feature class as being visible, looks like only the joined data has those fields visible?..

EmilyLaMunyon

I am having the same problem, but am unable to resolve it. My search widget is not working on a joined map service layer. I have tried typing the full field name with no luck, I have also tried using various fields for the query. Will the search widget be affected if the join is to a SQL table through an ODBC connection?

<layer>
            <name>Survey Number</name>
            <url>http://gis.slco.org/wwwrest/services/public/Surveyor/MapServer/1</url>
            <expression>surveyor.SLCOSU.Surveys.DOCUMENT_N LIKE'%[value]%'</expression>
            <textsearchlabel>Search by Document Number:</textsearchlabel>
            <graphicalsearchlabel>Use one of the graphical search tools to select</graphicalsearchlabel>
            <titlefield>surveyor.SLCOSU.Surveys.DOCUMENT_N</titlefield>
            <linkfield></linkfield>
            <fields all="false">
                <field name="surveyor.SLCOSU.Surveys.DOCUMENT_N" alias="Survey Number"/>
    </fields>
        </layer>

Thanks!

MarkSmith1

Thanks Robert. That seems to have been the problem (I also cleared the REST cache which seemed to resolve some inconsistencies between the layer name I was using and what the service had).

Cheers!

Mark

rscheitlin

Mark,

You should use actual field names and if you have a join on that layer than you need to use the full name with the join info. Also do you have the OBJECTID and Shape fields visible for that layer in your MXD?

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.