topic Re: How to use definitionexpression in <sublayer>? in ArcGIS Viewer for Flex Questions

How to use definitionexpression in <sublayer>?

BenKane — Fri, 26 Aug 2011 19:34:08 GMT

How do I implement a definition query using definitionexpression in the sublayer tag? I see that it's possible but I can't find anywhere any sample code or syntax for how to implement this.

Re: How to use definitionexpression in ?

RobertScheitlin__GISP — Fri, 26 Aug 2011 20:04:15 GMT

Ben,

You can find the documentation on this here:

http://help.arcgis.com/en/webapps/flexviewer/help/01m3/01m30000000p000000.htm

<sublayer id="1" definitionexpression="ObjectId = 23"/>

Re: How to use definitionexpression in ?

BenKane — Sat, 11 Dec 2021 13:21:14 GMT

Robert,
The only documentation there is:

Child tag specific to layers of type dynamic and tiles
<sublayer> supports the following properties:
    * id - the id, usually a number, of the sublayer within the Map Service.
    * popupconfig - URL to the xml configuration file the pop-up window. See Pop-up configuration files for more information.
    * definitionexpression - Limits the data to a subset of the available features in the map service layer. It is similar to the definition query for a layer in ArcMap.

Can sublayers support a popup and a definitionexpression simultaneously?
I have tried the format you specified, grouped with a popup as well as without the popup - neither works to limit the drawing of the feature in the viewer to the specified query.

Here is a sample from my config:

 <operationallayers> 
     <layer label="Tacoma M7.1" type="dynamic" visible="true" alpha="0.75" preload="open"
                   url="http://140.160.114.190/ArcGIS/rest/services/Seismic/Tacoma/MapServer"> 
      <sublayer id="1" definitionxpression="countyname = King" popupconfig="popups/PopUp_DBs_EF_CareFlty.xml"/>
     <sublayer id="2" popupconfig="popups/PopUp_DBs_UTIL_OilFlty.xml"/>

Thanks,
Ben

Re: How to use definitionexpression in ?

RobertScheitlin__GISP — Fri, 26 Aug 2011 22:31:44 GMT

Ben,

The secret is going to be the right SQL syntax. You are searching for a string so you need to have king in single quotes. 'King'

Re: How to use definitionexpression in ?

BenKane — Fri, 26 Aug 2011 23:19:05 GMT

I thought you might say that...but unfortunately that doesn't help. I had a brief moment of excitement when I noticed that I had a typo in the config with "definitionxpression" instead of "definitionexpression", but upon changing that still no luck...

I have tried the definitionexpression on other layers as well to avail.

-Ben

Re: How to use definitionexpression in ?

RobertScheitlin__GISP — Sat, 11 Dec 2021 13:21:17 GMT

Ben,

I'm not sure what you are doing wrong then... Here is one I got to work just fine on my end.

            <layer label="Louisville Landbase" type="dynamic" visible="true" alpha="0.4"
                   url="http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Louisville/LOJIC_LandRecords_Louisville/MapServer">
                   <sublayer id="1" definitionexpression="LANDUSE_NAME = 'GENERAL COMM. AND OFFICE'"/>
            </layer>

Re: How to use definitionexpression in ?

BrianOevermann — Sat, 11 Dec 2021 13:21:19 GMT

Ben,

Aside from the attribute value quoting, it appears that you simply haven't "closed" the layer tag, although you may have simply not included it in your code sample.

 <operationallayers> 
     <layer label="Tacoma M7.1" type="dynamic" visible="true" alpha="0.75" preload="open"
                   url="http://140.160.114.190/ArcGIS/rest/services/Seismic/Tacoma/MapServer"> 
      <sublayer id="1" definitionexpression="countyname = 'King'" popupconfig="popups/PopUp_DBs_EF_CareFlty.xml"/>
     <sublayer id="2" popupconfig="popups/PopUp_DBs_UTIL_OilFlty.xml"/>
            </layer>

Re: How to use definitionexpression in ?

CharlesHarris — Tue, 30 Aug 2011 18:09:11 GMT

I'm having this same problem. I know that I've structured my definitionexpression properly because I can place the syntax into the Where portion of the rest query and it returns the records just fine.

Any ideas?

Re: How to use definitionexpression in ?

BrianOevermann — Sat, 11 Dec 2021 13:21:22 GMT

Jeremy,

Can you post the config code that isn't working? Like Robert, I have been able to get this to work. My example is below. I used a service whose feature class has a joined table, so I needed to fully qualify my field name. Since you are able to query successfully via the REST dialog you have probably taken care of that if it is necessary.

            <layer label="General Data" type="dynamic" visible="true" alpha="0.4"
                   url="http://myServer/ArcGIS/rest/services/General_Mapservices/general/MapServer">
                   <sublayer id="0" definitionexpression="myDB.COI.SiteAddress.BusinessName='TARGET'"/>
            </layer>

Re: How to use definitionexpression in ?

CharlesHarris — Sat, 11 Dec 2021 13:21:24 GMT

Since this is a public service you can try it in your own viewer. If I put "AGBUR = 'BIA' into the query at http://maps1.arcgisonline.com/ArcGIS/rest/services/USA_Federal_Lands/MapServer/2 it works fine. I'm not sure what's missing

<layer label="USA Federal Lands - Reservations" type="dynamic" visible="false" alpha=".7"
                   url="http://maps1.arcgisonline.com/ArcGIS/rest/services/USA_Federal_Lands/MapServer"> 
                   <sublayer id="2" definitionexpression="AGBUR = 'BIA'"/> 
            </layer>

Re: How to use definitionexpression in ?

BrianOevermann — Tue, 30 Aug 2011 20:32:26 GMT

Jeremy,

I'm at a loss. The only difference I noticed is that the map service you are using has your layer ID 2 as part of a group layer. Admittedly this is a very thin hypothesis, but maybe there is a quirky sort of bug related to group layers and definition expressions?

Ben's example is not directly using a layer within a group layer, but his service contains group layers. Robert's example is using a service that has no group layers present. My example also has no group layers present. I'm not sure if there is any merit to the idea, and I don't have the time available to exhaustively test this, but maybe you do have the time?

As an exercise, I copy/pasted your code block into the v2.4 viewer I am upgrading to. I did change the value from 'BIA' to 'FS' because I know that we have U.S. Forest Service lands in reasonable proximity to our city. I kept zooming out and noted that there are other labels (part of the map service group layer) that indicate features that the definition expression is eliminating, so your code appears to be working correctly for me. See the attached screen shot. There goes the group layer bug theory! [maybe]

It probably goes without saying, but you are using this tag against API 2.4 and not an earlier version, correct? Just trying to cover the possibilities...

Re: How to use definitionexpression in ?

RobertScheitlin__GISP — Wed, 31 Aug 2011 02:48:04 GMT

Jeremy,

I have tested the map service your provided as well, and as Brian, I was able to get the layer definition to work.

Re: How to use definitionexpression in ?

CharlesHarris — Wed, 31 Aug 2011 12:42:26 GMT

Thanks guys...I did realize what the problem was late last night as I tested this further. The application that we were testing this in is still 2.3.x. We will be upgrading it to v. 2.4 during our next release cycle. I tested it in a fresh 2.4 viewer last night and it worked fine. Thanks for the help!

Jeremy

Re: How to use definitionexpression in ?

BenKane — Tue, 06 Sep 2011 22:12:24 GMT

Oops, yeah I made the same mistake...I've upgraded to Flexviewer 2.4 and now my definitionexpression works. Thanks Robert and Jeremy for your help.

Ben

Re: How to use definitionexpression in ?

BrianKaplan — Tue, 20 Sep 2011 20:48:48 GMT

Here's one that I cannot get to work..

<layer label="USGS National Hazard System 1" type="dynamic" visible="false" alpha="1.0"
      url="http://rmgsc.cr.usgs.gov/ArcGIS/rest/services/nhss_haz/MapServer">
      <sublayer id="5" popupconfig="popups/PopUp_USGS_NHSS_Wildfire.xml"/>
      <sublayer id="6" definitionexpression="ACTIVE='Y'" popupconfig="popups/PopUp_USGS_NHSS_WildfirePerimeters.xml" />
         </layer>

Adding this definitionexpression makes this whole layer not show up. Does anyone see anything obvious. I'm using 2.4 thanks Brian Kaplan

Re: How to use definitionexpression in ?

RobertScheitlin__GISP — Wed, 21 Sep 2011 12:55:56 GMT

Brian,

I don't see anything wrong here and I have tested and verified the issue you are having. I sorry to say I have not found a resolution though.

Re: How to use definitionexpression in ?

BrianKaplan — Wed, 21 Sep 2011 16:02:33 GMT

Thanks for checking. When I add the rest layer to ArcMap, the legend comes up with the polygon symbol and a Y. The polygon represents multiple datarows. When I use the info buttom, I get all records with N and Y, so something may be funky with the data feed. Brian