Queries
This page explains the Queries tab in the Specification Data Field Editor, which shows all queries that include a specification field as a column. Use this tab to understand the impact of changes to a specification field and to navigate quickly to related queries.
Viewing the Queries Tab
- Navigate to Admin > Custom Fields (Specification Data).
- Click the field name to open the editor.
- Switch to the Queries tab.
The tab displays a list of all queries that reference this specification field as a column in their query builder definition.
What You Can Do
- Click a query name to open it in the Query Editor for viewing or modification.
- Review the list before renaming or deleting a specification field to understand which queries will be affected.
What Is Not Shown
User SQL queries that reference this field will not appear in this list. User SQL queries embed their column references in custom SQL text rather than using the query builder's column registry, so the system cannot automatically detect the reference.
If you are planning to rename or delete a specification field, search through User SQL queries manually to check for any references. You can do this by:
- Navigating to Admin > Queries > Queries and Reports.
- Filtering the list to show User SQL queries (type = User SQL).
- Searching the SQL text for the field name.
Tip: When you rename a specification field, the query builder automatically updates queries that reference it through the column registry. However, any User SQL queries, AMSX scripts, or transformations that reference the field by name must be updated manually.
Related Articles
- Specification Data — creating and managing specification fields
- Queries and Reports — the query builder and query editor
- Advanced Query Techniques — User SQL queries