Open Basic queries in ERP Manager. Use the screen to browse, filter, and open individual query records for editing.
Fields and controls
Control | Purpose |
Client connection | This filter limits the list to queries belonging to the selected client connection. |
Name | This text field filters the list by query name. |
Create | This control opens the stepped editor to create a new basic query. |
Clear filters | This control resets all active filters and reloads the full list. |
Rows per page | This control sets how many rows appear per page. |
Pagination | Go to previous page and Go to next page navigate between pages of results. |
Control | Options / values |
Client connection | The options include All and any configured connections. |
Rows per page | The available values are 5, 10, 25, and 50. |
When no records match the active filters, the list displays “No Basic queries found using the current filters”.
Query editor controls
Opening a basic query record loads a stepped editor. The editor opens at step 1.
Control | Purpose |
View Live Params | This control opens a panel showing live parameters for the query as it runs against the ERP. |
Step 1 fields
Field | Description |
Basic Query Name | This field contains the query name and is disabled when the query is locked. |
Select connection | This field specifies the client connection that the query runs against and is disabled when the query is locked. |
Select ERP Entity | This field specifies the ERP entity that the query reads from and is disabled when the query is locked. |
REST API | This control enables REST API access for the query and is disabled when the query is locked. |
Notes
A query used by an existing API endpoint is locked. When a query is locked, all step 1 fields become read-only. The editor displays the alert “Basic Query is locked due to it's used in API Endpoint”. This reference covers step 1 of the editor; later steps are not included.
Related