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

Enhanced-Search-Widget-for-FlexViewer Part II

RobertScheitlin__GISP

All,

I am pleased to announce the next release of my eSearch Widget.

http://www.arcgis.com/home/item.html?id=5d4995ccdb99429185dfd8d8fb2a513e

Version 2.5.1.7 - 4/19/2012
* Added ability to search (flat/standalone/no geometry) tables.
* This time all Zooming uses the same scaling (popup, datagrid, widget results, zoom to all).
* Added Relates icon/button to datagrids so that you can click on it in the datagrid to
open relates choice dialog.
* Move all skins to a skins package for cleaner organization.
* Links that are not associated with a field now work.
* Ability to disable the relates tab in the fixed widget is now configurable.

Encontre mais publicações marcadas com

Accepted answers

All comments

RobertScheitlin__GISP

Jorge,

<expression alias="Project Railroads" textsearchlabel="Enter NAME or FEATURE_ID below">
    <values>
           <value>1=1</value>
    </values>
  </expression>

RobertScheitlin__GISP

Rhett,

I guess I neglected to test sorting using joined data. I will get this fixed in the next release.

Here is the fix for the JoinDataGridColumn.as

        public function labelCompareFunction1(obj1:Object, obj2:Object, column:GridColumn = null):int

MattRogers

Rob,

Is it possible to disable the results to only have them show in the FixedDG and leave the text search still showing? Not sure if this is something that can be done in the compiled version 3.07 or not.

Thanks,

Matt

RobertScheitlin__GISP

Matt,

No that is not an option in the compiled version.

RhettZufelt

Gabriel,

Bug with the label being ignored is fixed for next release (thanks for reporting this).
I will add this as an enhancement request. Currently there are checks made to ensure all fields are filled before executing the search. The draw back to this being changed is that the search will no longer be able to be triggered by pressing the enter key as I will not know if the user pressed enter unintentionally or not.

Hi Robert,

Been trying to figure out where/how you removed the ability to trigger search by pressing enter.

Would that be something pretty simple for me to add back in? In my "particular" case, it is prefered.

Thanks again,

R_

RobertScheitlin__GISP

Rhett,

If you only have one field than the enter key still works.

MattRogers

Sorry Rob...I'm new to this and should have asked if there was a way to do this in the uncompiled or compiled version. When searching the forum I found this topic where it was done, just wondering if you can point me in the right direction on how to go about doing this.

http://forums.arcgis.com/threads/64335-eSearch-disable-Results-state

Thanks,

Matt

Matt,

No that is not an option in the compiled version.

Rob,

Is it possible to disable the results to only have them show in the FixedDG and leave the text search still showing? Not sure if this is something that can be done in the compiled version 3.07 or not.

Thanks,

Matt

RobertScheitlin__GISP

Matt,

Well that thread speaks of a way to prevent the widget from switching to the results state but it does not prevent the widget from having the result. If this is what you are after than all you need to do is search for the queryFeatureText function and comment out the

showStateResults();

line.

JORGELAGOS2

hello Robert,

Now i would like to use your eSearch tool with two value option using the same layer and fields. Is that possible?

Something like this:

     <values>

       <value userlist="Select All Records">1=1</value>
          <value>upper(PRJTRACTNO) like upper('%[value]%')</value>

     </values>

    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Property Parcels</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>PRJTRACTNO</titlefield>
   <fields all="false">
    <field name="PRJTRACTNO" gridfield="true"/>
    <field name="OWNER" gridfield="true"/>
    <field name="MOD_DATE" gridfield="true" dateformat="MM/DD/YYYY"/>
    <field name="CLASS" gridfield="true" gridfieldonly="true"/>
    <field name="ROW_IMPACT" gridfield="true" gridfieldonly="true"/>
    <field name="ADDITIONAL_IMPACT" gridfield="true" gridfieldonly="true"/>

twoSearchOptions.png

RhettZufelt

do you mean something like the search centerline example from the example site (though it actually has three value statements) http://gis.calhouncounty.org/FlexViewer3.0/index.html?config=config-eSearch.xml&search=2&slayer=3&exprnum=1 ?

If so, here is the snippet from the eSearchWidget.xml Robert has supplied with the widget that does that.

   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Road Centerlines</name>
   <url>http://gislap134/ArcGIS/rest/services/Highway/MapServer/5</url&gt;
   <expressions>
    <expression alias="Road Name and Zip" textsearchlabel="Search by Road Name and Left Zipcode and Right Zip:">
     <values>
      <value prompt="Exmaple: ANDREW">RD_NAME = '[value]'</value>
      <value prompt="Exmaple: 36201"> AND ZIP_L = [value]</value>
      <value prompt="Exmaple: 36201"> AND ZIP_R = [value]</value>
     </values>
    </expression>
   </expressions>

(I deleted the other expressions that didn't seem to apply)
(Don't forget the space before the AND as it is not in the example.xml this way) Can also use OR instead if that is what you need.

Is this what you are after?

Below is a snippet that I am using. It puts two options on the search widget, one lets you put in partial and does a LIKE operation, the other only finds exact matches. But, they are both searching the same layer, same field.

    <expression alias="SiteCode" textsearchlabel="Search by SiteCode: (enter search text in one box only)">
     <values>
      <value  prompt="Search for Matches:  Example: 100-D-" field="SITECODE">UPPER(SITECODE) LIKE UPPER('%[value]%')</value>
     </values>
     <values>
      <value  prompt="Search EXACT SiteCode" field="SITECODE">UPPER(SITECODE) = UPPER('[value]')</value>
     </values>
    </expression>

    <expression alias="SiteCode" textsearchlabel="Search by SiteCode: (enter search text in one box only)">
     <values>
      <value  prompt="Search for Matches:  Example: 100-D-" field="SITECODE">UPPER(SITECODE) LIKE UPPER('%[value]%')</value>
     </values>
     <values>
      <value  prompt="Search EXACT SiteCode" field="SITECODE"> OR UPPER(SITECODE) = UPPER('[value]')</value>
     </values>
    </expression>

In the first example, multiple fields are searched, in the second example, you choose which input to use and it searches the same fields but with different expression. The third is similar to the second but will take inputs from both text box's, and if either match, you get the results. Just remember, if you use an AND or OR statement, the first text box MUST have a value in it.

If I understand you correctly, below is what you need.

<expression alias="Tract" textsearchlabel="Search by Tract Number:
 <values>
  <value  prompt="Select All Records"   userlist="Select All Records" field="PRJTRACTNO">1=1</value>
 </values>
 <values>
  <value  prompt="Search Tract Number" field="PRJTRACTNO">UPPER(PRJTRACTNO) LIKE UPPER(%'[value]'%)</value>
 </values>
</expression>

JORGELAGOS2

do you mean something like the search centerline example from the example site (though it actually has three value statements) http://gis.calhouncounty.org/FlexViewer3.0/index.html?config=config-eSearch.xml&search=2&slayer=3&exprnum=1 ?

If so, here is the snippet from the eSearchWidget.xml Robert has supplied with the widget that does that.
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Road Centerlines</name>
   <url>http://gislap134/ArcGIS/rest/services/Highway/MapServer/5</url&gt;
   <expressions>
    <expression alias="Road Name and Zip" textsearchlabel="Search by Road Name and Left Zipcode and Right Zip:">
     <values>
      <value prompt="Exmaple: ANDREW">RD_NAME = '[value]'</value>
      <value prompt="Exmaple: 36201"> AND ZIP_L = [value]</value>
      <value prompt="Exmaple: 36201"> AND ZIP_R = [value]</value>
     </values>
    </expression>
   </expressions>
(I deleted the other expressions that didn't seem to apply)
(Don't forget the space before the AND as it is not in the example.xml this way) Can also use OR instead if that is what you need.

Is this what you are after?

Below is a snippet that I am using. It puts two options on the search widget, one lets you put in partial and does a LIKE operation, the other only finds exact matches. But, they are both searching the same layer, same field.
    <expression alias="SiteCode" textsearchlabel="Search by SiteCode: (enter search text in one box only)">
     <values>
      <value  prompt="Search for Matches:  Example: 100-D-" field="SITECODE">UPPER(SITECODE) LIKE UPPER('%[value]%')</value>
     </values>
     <values>
      <value  prompt="Search EXACT SiteCode" field="SITECODE">UPPER(SITECODE) = UPPER('[value]')</value>
     </values>
    </expression>
    <expression alias="SiteCode" textsearchlabel="Search by SiteCode: (enter search text in one box only)">
     <values>
      <value  prompt="Search for Matches:  Example: 100-D-" field="SITECODE">UPPER(SITECODE) LIKE UPPER('%[value]%')</value>
     </values>
     <values>
      <value  prompt="Search EXACT SiteCode" field="SITECODE"> OR UPPER(SITECODE) = UPPER('[value]')</value>
     </values>
    </expression>
In the first example, multiple fields are searched, in the second example, you choose which input to use and it searches the same fields but with different expression. The third is similar to the second but will take inputs from both text box's, and if either match, you get the results. Just remember, if you use an AND or OR statement, the first text box MUST have a value in it.

If I understand you correctly, below is what you need.
<expression alias="Tract" textsearchlabel="Search by Tract Number:
 <values>
  <value  prompt="Select All Records"   userlist="Select All Records" field="PRJTRACTNO">1=1</value>
 </values>
 <values>
  <value  prompt="Search Tract Number" field="PRJTRACTNO">UPPER(PRJTRACTNO) LIKE UPPER(%'[value]'%)</value>
 </values>
</expression>
R_

Thanks so much. I am trying to implement the search with the AND using two fields.
<expressions>
    <expression alias="Property Parcels" textsearchlabel="Search by PRJTRACTNO AND OWNER">
        <values>
<value prompt="Enter Project Number">UPPER(PRJTRACTNO) LIKE UPPER(%'[value]'%)</value>
<value prompt="Enter Owner"> AND UPPER(OWNER) LIKE UPPER(%'[value]'%)</value>
       </values>
   </expression>
</expressions>

However I got the error which is showinfg in the attached image

Thanks

Jorge

error.png

RobertScheitlin__GISP

Jorge,

Your expression needs some work:

            <expressions>
                <expression alias="Property Parcels" textsearchlabel="Search by PRJTRACTNO AND OWNER">
                    <values>
                        <value prompt="Enter Project Number">UPPER(PRJTRACTNO) LIKE UPPER('%[value]%')</value>
                        <value prompt="Enter Owner"> AND UPPER(OWNER) LIKE UPPER('%[value]%')</value>
                    </values>
                </expression>
            </expressions>

Also you need to consider if you really need both % symbol. Let me explain what that is doing if you don't already know. If you enter a value of drew then the query would find values like 'Andrew Jones Rd' and 'Drew Pennington Rd', where id you were to use UPPER('[value]%') then it would only find 'Drew Pennington Rd'.

RobertScheitlin__GISP

All,

Version 3.0.8 is now available:

Version 3.0.8 - 9/4/2012
* Added attribute to not display links that have null values.
* Fixed bug with sorting on joined data.
* Fixed bug with datefomat not being specified throwing error.
* Added a isvaluerequired attribute to expression values and expressions (see documentation for details).
* Added ability to define symbology at the layer level and widget level.

RhettZufelt

Thanks so much. I am trying to implement the search with the AND using two fields.
<expressions>
<expression alias="Property Parcels" textsearchlabel="Search by PRJTRACTNO AND OWNER">
<values>
<value prompt="Enter Project Number">UPPER(PRJTRACTNO) LIKE UPPER(%'[value]'%)</value>
<value prompt="Enter Owner"> AND UPPER(OWNER) LIKE UPPER(%'[value]'%)</value>
</values>
</expression>
</expressions>

However I got the error which is showinfg in the attached image

Thanks

Jorge

I would guess that your PRJTRACTNO is actualy a number field and not a text field. If so:

<expressions>
    <expression alias="Property Parcels" textsearchlabel="Search by PRJTRACTNO AND OWNER">
        <values>
 <value prompt="Enter Project Number">PRJTRACTNO = [value]<value>
 <value prompt="Enter Owner"> AND UPPER(OWNER) LIKE UPPER(%'[value]'%)</value>
       </values>
   </expression>
</expressions>

If I try to search a numeric field using text input, I get the same error that you posted.

R_

Of course, as Robert pointed out, the double wildcards can/will match a LOT of values.

JORGELAGOS2

I would guess that your PRJTRACTNO is actualy a number field and not a text field. If so:
<expressions>
    <expression alias="Property Parcels" textsearchlabel="Search by PRJTRACTNO AND OWNER">
        <values>
 <value prompt="Enter Project Number">PRJTRACTNO = [value]<value>
 <value prompt="Enter Owner"> AND UPPER(OWNER) LIKE UPPER(%'[value]'%)</value>
       </values>
   </expression>
</expressions>
If I try to search a numeric field using text input, I get the same error that you posted.

R_

Of course, as Robert pointed out, the double wildcards can/will match a LOT of values.

Thanks so much for trying to help me with this issue. Unfortunately, I got the same error and none of my fields are numeric (see my search boxes in the attached file)). Any more ideas?

This is how my code look now.

<expressions>
<expression alias="Property Parcels" textsearchlabel="Search by PRJTRACTNO AND OWNER">
<values>
<value prompt="Enter Project Number">PRJTRACTNO = [value]</value>
<value prompt="Enter Owner"> AND UPPER(OWNER) LIKE UPPER(%'[value]'%)</value>
</values>
</expression>
</expressions>

Thanks

jorge

twoSearchOptions.png

RobertScheitlin__GISP

Jorge,

As this widgets developer I would suggest that you pay close attention to my responses to your inquiry. In my last post I corrected some of the text in your expression. Go back to my last post and copy the expression as your had the order of the single qoutes and the percent symbol backwards.

AndrewThorup

Robert,

Great job on this fantastic widget.

I am having an issue with the link functionality on one of my viewers. There is supposed to be a url string with the parcel number (YPNO field) attached at the end to comlete the link. Here is the code I have used in the eSearch.xml file:

                        <links>
    <link includeinresults="true" alias="Lyon Co Assessor Parcel Search">
     <![CDATA[http://www1.lyon-county.org:403/cgi-bin/asw101?Parcel={YPNO}]]&gt;
     <icon><![CDATA[assets/images/i_table.png]]></icon>
    </link>
   </links>

When the link is clicked in the viewer, the url appears in the address bar without the attached YPNO number. I know I am supposed to wrap the field name in curly braces, and this same method works on all of the other viewers I have created for other counties. I have had this problem for this viewer using versions 3.0.6, 3.0.7, and 3.0.8. I have confirmed that YPNO is indeed the correct name for the field by checking at the rest endpoint. I have also tried making the link work as a text field as well as a number field. So far I have had no success.

RobertScheitlin__GISP

Jay,

I would start with some simple trouble shooting. Test by removing the link prefix and just have the field itself in the link and see if once clicked it provides the fields value. Is the field YPNO one of the field in your fields tag? I notice that you have the includeinresults as true do you see the value of the YPNO field in the results?

                        <links>
                <link includeinresults="true" alias="Lyon Co Assessor Parcel Search">
                    <=!=[=C=D=A=T=A=[{YPNO}]=]=>
                    <icon><=!=[=C=D=A=T=A=[assets/images/i_table.png]=]=></icon>
                </link>
            </links>

RhettZufelt

Jorge,

As this widgets developer I would suggest that you pay close attention to my responses to your inquiry. In my last post I corrected some of the text in your expression. Go back to my last post and copy the expression as your had the order of the single qoutes and the percent symbol backwards.

Guess I should pay more attention to that also as if I put the percents outside the quotes, I get the fault code 400 error also...

AndrewThorup

Robert,

It's fixed, thank you very much for your help. Once I included the YPNO field as part of the fields tag, it started showing up in the url. I was unaware that the field had to be in the fields tag. Thanks again!

RobertScheitlin__GISP

Jay,

The only way the widget is going to know what fields to ask back from the query task is for them to be listed in the fields list. So any field you intent to use, for a link, the datagrid, etc has to be listed as a field in the fields list but that does not mean it has to be displayed in the widgets results. All you have to do is set the fields visible attribute to false and it will not be displayed in the results, but it still can be used for a link or a gridfield.

Don't forget to click the top arrow (promote).
Follow the step as shown in the below graphic:

RobertScheitlin__GISP

All,

New version is now available:

Version 3.0.9 - 9/13/2012
* Added an auto sync between the text search layer and the graphical search layer dropdowns.
* Depreciated the disablerelatestabinfixed attribute in favor of automatically setting the
visibility of the relates tab for the fixed datagrid based on, if the layer has relates
configured or not.
* Fixed datagrid now has configuration options for height and animation duration. Thanks to Kenny Horan
* Added an auto hide check box on the fixed datagrid to toggle the auto hide capability.
* Disablelinksifnull attribute now checks for empty strings as well as null values in the link fields.

JORGELAGOS2

Jorge,

As this widgets developer I would suggest that you pay close attention to my responses to your inquiry. In my last post I corrected some of the text in your expression. Go back to my last post and copy the expression as your had the order of the single qoutes and the percent symbol backwards.

Ups Sorry Robert I guess I was overlooking and I didn't see your response.

Thanks for the input though.

Jorge

MagalyC_

Hi Robert!

I am updating your widget to version 3.0.9.
I have a small problem when I test the display of a number.
The XML config:
[HTML]<field name="SURFACE" alias="Surface" gridfield="true" currencyformat="m2|0| |." />[/HTML]

The new version displays: USD72 288
The current version: 72 288m2

(see captures)

Have I missed something?

Thanks for help ! 🙂

after.PNG

before.PNG

RobertScheitlin__GISP

Magaly,

Thanks for reporting this. The issue is one line of code that was mistakenly omitted from the eSearchWidget.mxml. If you are using the source code of the widget my first suggestion is to go get 3.0.10 released yesterday and then open the eSearchWidget.mxml and search for this code block and make the addition indicated in red:

                            if(curFormat){
                                var args2:Array = curFormat.split("|");
                                if(args2[0]){
                                    currFormatter.currencySymbol = args2[0];
                                    currFormatter.useCurrencySymbol = true;
                                }
                                if(args2[1])
                                    currFormatter.fractionalDigits = args2[1];
                                if(args2[2]){
                                    currFormatter.useGrouping = true;
                                    currFormatter.groupingSeparator = args2[2];
                                }else{
                                    currFormatter.useGrouping = false;
                                }
                                if(args2[3]){
                                    currFormatter.decimalSeparator = args2[3];
                                }
                                value = currFormatter.format(value);
                            }

I will have this fixed and re-released for version 3.0.10.

MagalyC_

Thanks!
Now I have :

Superficie: 9761.078281560

instead of

Superficie: 9761m2

It's better but it's not like before 😕

MagalyC_

The currencyformat attribute allows you to format a numeric field that represents currency values.

!!

currency!!

I never paid attention to it!
It worked for the previous version, while it was not a data "currency"... 😕

How should I do to display a number with default text after?

ex: 1000 m, 650 km... ?

Is it possible ?

RobertScheitlin__GISP

All,

The next new release is available:

Version 3.0.11 - 10/17/2012
* Added uniquevalsfromfield as a source for search drop down (like usedomain and userlist options).
This now queries the map service for unique values of a field to use in the dropdown.
* Changed the default spatialreference in the xml to 102100.
* Fixed bug with spatial search using symbology from first text search layer instead of chosen spatial
search layer.
* Changed the line width stepper in the GUI to use whole numbers (thanks to Bjorn for point this out).

MichaelNelson1

Robert,

I saw that you made updates to your eSearch widget yesterday. Will you be making a compiled version available? Or am I missing something on github?

Thanks for your work, tools work great.

Michael

RobertScheitlin__GISP

Michael,

GitHub is only for source code.

At the code gallery page:

http://www.arcgis.com/home/item.html?id=5d4995ccdb99429185dfd8d8fb2a513e

scroll down to the:

Code Attachment eSearch.zip Download

and click the download button.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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