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

Trouble Selecting from FeatureLayer containing Definition Query

MikeRatcliffe

My Definition Queried featurelayer clearly contains the field# "Material;" however, my Select() returns the exception: "GeodatabaseFieldException," field does not exist or is unaccessible.

The source FeatureLayer is a Complex Edge from a Geometric Network...(Problem?)

If I first remove the Definition Query from the FeatureLayer, the Select executes properly (Material = CI).

Select Method is supposed to drill through Definition Queries appropriately:

"...If there is a definition query set on the MapMember, the Select() method will automatically work on the subset of rows in the MapMember that meet the definition criteria. You specify an additional query that will be applied after the MapMember's definition query by passing valid QueryFilter object for the QueryFilter parameter.
If the MapMember has any joins, this Select() method takes that into account.

To ensure maximum robustness, callers should explicitly dispose of the returned ArcGIS.Core.Data.Selection in either a using statement or a finally block."

Can someone point me in the right direction?

Find more posts tagged with

Accepted answers

MikeRatcliffe

The issue was with my handling of SQL Syntax in the whereclause for the queryfilter. When a codedvalue data type is String, the value must be enclosed in SINGLE QUOTES.

failed syntax: WhereValue = Form1.GVar.ms_attfn + Form1.GVar.Oper8tr + Form1.GVar.ms_v;

proper syntax: WhereValue = Form1.GVar.ms_attfn + Form1.GVar.Oper8tr + "'" + Form1.GVar.ms_v + "'";

All comments

MikeRatcliffe

The issue was with my handling of SQL Syntax in the whereclause for the queryfilter. When a codedvalue data type is String, the value must be enclosed in SINGLE QUOTES.

failed syntax: WhereValue = Form1.GVar.ms_attfn + Form1.GVar.Oper8tr + Form1.GVar.ms_v;

proper syntax: WhereValue = Form1.GVar.ms_attfn + Form1.GVar.Oper8tr + "'" + Form1.GVar.ms_v + "'";

MikeRatcliffe

.cs provided (not necessarily short...) Thanks.

Ruh_snippet.cs.zip

forwardplanning.zip

RichRuh

Could you send me a short code snippet showing me how you are building the WhereClause and other properties of the QueryFilter that you are passing into FeatureLayer.Select()?

Thanks.

MikeRatcliffe

The FeatureLayer represents water mains, Definition Queried by DATASET = ABANDONED.

Here is a sequence of step that lead to the issue:

1. Grab the search layer from the active map

2. Populate a list of field names from it using List<FieldDescription>. (I am absolutely making available the same field from the Definition Query to the user, which is "DATASET.")

3. User selects which field to search/select. Based on selected field, it is routed to an appropriate whereclause and fieldtype for conversion that sets up the actual feature selection.

4. DATASET = Abandoned is a CodedValueDomain. Fields with CodedValueDomains are sent to an IList<string> of codedvaluepairs.values, which are then selectable by the user.

5. Finally, a spatialqueryfilter is applied to a FeatureLayer Select().

If I do not SetDefinitionQuery(""); select() returns the exception: "geodatabasefieldexception," field does not exist or is inaccessible. *I get this exception when trying to select out of any fieldtype (string, integer, CodedValueDomain, etc.). *Seems none of the table fields are accessible through the Definition Query.

If I grab the DefinitionQuery before setting it to nothing, and re-instate it after the selection, the features are selected without the original DefinitionQuery, but show VISUALLY as you'd expect with the DefinitionQuery intact. (cheating). Not what I need.

RichRuh

Hi Mike,

I set up a similar situation and tried to reproduce your issue. I have a map in Pro which contains a feature layer that points to a feature class that is a complex edge in a geometric network. The feature layer has a query definition set up on it (Phase Designation is Equal to 4).

I then wrote an add-in that grabbed that feature layer and executed a Select() and a Search() on that layer. Both worked fine.

bool DoTest(Layer myLayer)
{
   FeatureLayer featureLayer = myLayer as FeatureLayer;
   string definitionQuery = featureLayer.DefinitionQuery; // to confirm that it is set when stepping through debugger

   // Create a query definition
   QueryFilter queryFilter = new QueryFilter
   {
      WhereClause = "FEEDERID = 'GR-202'"
   };

   int searchCount = 0;
   using (RowCursor cursor = featureLayer.Search(queryFilter))
   {
      while (cursor.MoveNext())
      {
         searchCount++;
      }
   }

   using (Selection selection = featureLayer.Select(queryFilter, SelectionCombinationMethod.New))
   {
      int selectcount = selection.GetCount();
   }
   return true;
}

Could you send me some information about what you are trying to do? If you are using a QueryFilter, is it possible that you are using the same field that appears in the definition query? Could the layer definition be hiding the table field that you are trying to use?

Thanks,

--Rich

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.