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

Attribute Query - return Groups?

ducksunlimited

Dear All,

I used ESRI attribute query sample and returned all the values (commercial, commercial, agricultural, agricultural, etc) for that field. But I want only the groups (commericial, agricultural, etc) returned. How to construct the query so I can achieve this. thanks for the help,

Russel

Find more posts tagged with

Accepted answers

All comments

JenniferNery

Yes you're right CodedValueDomain is new to 2.0.

ducksunlimited

I think what you can do is first know the groups, which you can do by:
  foreach (Field field in fl.LayerInfo.Fields)
   {
    if (field.Domain is CodedValueDomain)
    {
     CodedValueDomain domain = field.Domain as CodedValueDomain;
     foreach (var item in domain.CodedValues)
     {
//item.Key is an object this is what you need in your query

     }
    }
   }
If your FeatureLayer was HomelandSecurity as in my previous post, you can see that ftype is CodedValueDomain and you can perform your query where "ftype = 10801".

Thanks for the help. I see this will work.

But CodedDomain is only supported in 2.0 not 1.2 right?

JenniferNery

I think what you can do is first know the groups, which you can do by:

  foreach (Field field in fl.LayerInfo.Fields)
   {
    if (field.Domain is CodedValueDomain)
    {
     CodedValueDomain domain = field.Domain as CodedValueDomain;
     foreach (var item in domain.CodedValues)
     {
//item.Key is an object this is what you need in your query

     }
    }
   }

If your FeatureLayer was HomelandSecurity as in my previous post, you can see that ftype is CodedValueDomain and you can perform your query where "ftype = 10801".

ducksunlimited

Do you mean this?

In this feature service http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/HomelandSecurity/operations/FeatureServer/0

ftype is CodedValueDomain, each number represent a category that can be one of the following values (Hydro-Meteorlogical, Public Health, ... Vehicle)

If I want to see only features that are "Vehicle", my query's Where is "ftype = 10801"

Thanks for the reply. I would like to return each group (like Hydro-Meteorlogical, Vehicle, etc) as a row in a datagrid, so users can select a row and zoom to that group (multiple polygons). Can I construt the Query.Where clause to do this? Thanks,

JenniferNery

Do you mean this?

In this feature service http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/HomelandSecurity/operations/FeatureServer/0

ftype is CodedValueDomain, each number represent a category that can be one of the following values (Hydro-Meteorlogical, Public Health, ... Vehicle)

If I want to see only features that are "Vehicle", my query's Where is "ftype = 10801"

BrianPangtay

ESRI attribute queries are based on SQL queries. Since the ESRI API only allows one to specify the WHERE clause of a SQL query, I don't think one can perform a group query in this manner.

Using transaction SQL,

If you want grouping to perform calculations, then one would need a GROUP BY clause in the SQL query.

If you only want the unique values for a given field, then one would need a DISTINCT keyword in the SQL query.

ducksunlimited

You can set your query's OutFields property so that it will return only the fields that you want it to return.
            query.OutFields.AddRange(new string[] { "FIELD_NAME" });

thanks for your reply!

I want to return only catogories for a field. For instance, I have a "LanUseType" field with values like commercial, agriculatural, wetlands, etc. How can I group by features using "LandUseType"? Help would be appreciated.

Russel

JenniferNery

You can set your query's OutFields property so that it will return only the fields that you want it to return.

            query.OutFields.AddRange(new string[] { "FIELD_NAME" });

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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