topic Re: Search Widget Not Working in ArcGIS Viewer for Flex Questions

Search Widget Not Working

MarkSmith1 — Fri, 10 Dec 2010 13:07:27 GMT

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

Re: Search Widget Not Working

RobertScheitlin__GISP — Fri, 10 Dec 2010 13:23:47 GMT

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?

Re: Search Widget Not Working

MarkSmith1 — Fri, 10 Dec 2010 13:34:59 GMT

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

Re: Search Widget Not Working

EmilyLaMunyon — Mon, 03 Jan 2011 20:34:21 GMT

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!

Re: Search Widget Not Working

RobertScheitlin__GISP — Mon, 03 Jan 2011 20:46:39 GMT

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

Re: Search Widget Not Working

EmilyLaMunyon — Mon, 03 Jan 2011 21:08:29 GMT

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

Re: Search Widget Not Working

RobertScheitlin__GISP — Mon, 03 Jan 2011 21:24:02 GMT

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.

Re: Search Widget Not Working

EmilyLaMunyon — Tue, 04 Jan 2011 13:01:03 GMT

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

Re: Search Widget Not Working

RobertScheitlin__GISP — Tue, 04 Jan 2011 15:41:27 GMT

Emily,

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

Robert

Re: eSearch Widget Not Working

RocíoVega — Fri, 02 Nov 2012 12:46:22 GMT

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

Re: Search Widget Not Working

RobertScheitlin__GISP — Fri, 02 Nov 2012 13:25:59 GMT

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.

Re: Search Widget Not Working

RocíoVega — Sun, 04 Nov 2012 00:00:08 GMT

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!!!

Re: Search Widget Not Working

RobertScheitlin__GISP — Sun, 04 Nov 2012 00:10:44 GMT

Dew,

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

Re: Search Widget Not Working

RocíoVega — Sun, 04 Nov 2012 21:19:48 GMT

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!

Re: Search Widget Not Working

RobertScheitlin__GISP — Mon, 05 Nov 2012 11:28:32 GMT

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.

Re: Search Widget Not Working

RocíoVega — Mon, 05 Nov 2012 23:33:17 GMT

Thanks Robert for your time.

Re: Search Widget Not Working

RobertScheitlin__GISP — Thu, 08 Nov 2012 14:00:57 GMT

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

Re: Search Widget Not Working

RocíoVega — Fri, 09 Nov 2012 02:39:50 GMT

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