Layer description in feature layer properties (including Contents hover-over functionality)
ArcGIS Pro 3.3.1
I create feature layers on underlying FCs/tables using tools like Make Query Table.
There are some crucial details about the feature layer/query table that I want to communicate to the user via a description in the Contents feature layer:
This Query Table has a SQL expression: TABLE_B.BINARY=1. The SQL expression behaves similar to a definition query, but with some differences:
- The SQL expression is hidden in ArcGIS Pro. It cannot be viewed or edited.
- The SQL expression acts as a pre-filter when the layer is used in a join which solves the following issue: Definition query on join table will effectively result in an inner join
The Query Table also omits the OBJECTID column. Purpose: to force a one-to-first join in older versions of Pro that don't have the option to choose the join type in the Add Join tool.
- Choose if join will be one-to-first or 1:Many
- A related post that has information about join types: https://community.esri.com/t5/arcgis-pro-ideas/indicate-what-caused-type-of-join-to-be-used-1-1/idi-...
More information about Query Tables can be found here: https://community.esri.com/t5/arcgis-pro-ideas/consistent-visible-sql-expressions-and-query/idi-p/13...
I'm not aware of a way to store a description in the Contents feature layer. Metadata does not seem to be supported for feature layers.
Right-click feature layer > Edit Metadata:
Could a description field be added to the layer properties > General tab? And could the description be displayed in a tooltip when the user hovers over the layer in the Contents pane?
Related: Query Table — Warning in layer properties that a SQL expression exists
