The Basic queries screen contains the query list in ERP Manager. Opening a query record loads its editor. The list has the columns QUERY NAME, CONNECTION/COMPANY and USED BY.

Basic queries list with connection and name filters, Create and Universal request buttons, and the query table

List controls

Control	Description
Client connection	Client connection selector above the query table.
Name	Text field.
Create	Link above the query table.
+ Universal request	The separate Create Universal API request form contains a Universal API connection selector.
Select all	Checkbox in the table header. Each query row has a Select this row checkbox, and some of these checkboxes are disabled. The Unselect and Delete buttons and an items-selected counter sit above the table.
Rows per page	The selector sits next to the pagination buttons.
Pagination	The pagination controls include Go to previous page and Go to next page. Numbered page buttons sit between them.

Query editor stages

Opening a basic query record loads a stepped editor. The stepper names five stages: Select Entity, Selecting, Filtering, Ordering and Expanding. Selecting Next advances the editor one stage at a time, from Select Entity through Expanding.

Controls that span stages

Control	Description
View Live Params	Available on every stage.
Review & Save	Appears on each stage after Select Entity, and not on Select Entity itself.
Skip	Appears on the Filtering and Ordering stages only.
Finish	Replaces Next on the Expanding stage.

Fields on the first stage

Field	Description
Basic Query Name	The name of the query.
Select connection	Connection selector.
Select ERP Entity	ERP entity selector.
REST API	Toggle.

Locked queries

The editor identifies the query as locked because it is used in an API endpoint. On the locked query, all fields on the first stage are disabled. An alert appears at the top of the editor. The alert reads "Basic Query is locked due to it's used in API Endpoint". In a locked query, the Select field, the Order By, Order Mode and Display only one controls, and the Add buttons on the Filtering and Expanding stages are disabled.

Controls on later stages

Stage	Controls
Selecting	The Select field.
Filtering	Add, under Creating Filters, and Skip.
Ordering	Order By, Order Mode, Display only one and Skip.
Expanding	Add and Finish.

Universal API request form

Control	Description
Universal API connection	The helper text describes the connection as the request environment, including its HTTPS origin, authentication and secrets. The selector is disabled when the form reports no Universal API connection. When no such connection exists, the form shows an alert that links to Client settings → Connection.

Notes

Hash characters in query filter values are encoded before requests reach the ERP, including in previews. Values already encoded as %23 are preserved without double encoding.

For Priority and SAP B1, saved filters preserve negation, including when a query contains multiple filter rows. Business Central does not support negation in OData filters.

Basic queries screen