Table "Query Metadata"
Virtual table that provides metadata information about all queries in the system. This table enables introspection of query properties, API configurations, and data access characteristics.
Remarks
The Query Metadata table is essential for understanding query definitions and their capabilities. It includes detailed information about query structures, API exposure settings, permissions, and categorization. This table is crucial for query management tools, API configuration, data access monitoring, and administrative utilities that need to understand query behaviors and constraints. The information covers all query types including those exposed as APIs, providing visibility into the data query infrastructure across all applications. Queries are fundamental for data aggregation, reporting, and API-based data access scenarios.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
| InherentPermissions | rX |
Fields
| Name | Type | Description |
|---|---|---|
| ID | Integer | The unique identifier number of the query. |
| Name | Text[30] | The name of the query as defined in the AL source code. |
| Caption | Text[80] | The caption text displayed for this query in the user interface. |
| APIPublisher | Text[40] | The publisher name for API queries when exposed through web services. |
| APIGroup | Text[40] | The API group classification for API queries. |
| APIVersion | Text[250] | The API version identifier for API queries. |
| EntitySetName | Text[250] | The entity set name used in OData APIs for this query. |
| EntityName | Text[250] | The entity name used in OData APIs for this query. |
| Category | Text[250] | The category classification for organizing and grouping related queries. |
| "App ID" | Guid | The application identifier that contains this query. |
| InherentPermissions | Text[5] | The inherent permissions defined for this query (Read, Insert, Modify, Delete). |
| InherentEntitlements | Text[5] | The inherent entitlements required to access this query. |
| "AL Namespace" | Text[500] | The AL namespace of the object. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |