Read Customer objects visible to this session. Filter the returned objects in client-side code, then pass selected IDs to pivot, set or aggregate tools.

Fetch a single Customer by primary key (id).

union two Customer sets, identified by primary keys and reloaded for this session.

intersect two Customer sets, identified by primary keys and reloaded for this session.

subtract two Customer sets, identified by primary keys and reloaded for this session.

Count the selected Customer objects and optionally sum a numeric property. Omit group_by for one whole-set total (key: null, zero metrics for an empty set), or group by a property. Returns set and values; each row has a key, member pks and numeric metrics. Filter rows in client-side code and use their pks to continue exploring.

Read Order objects visible to this session. Filter the returned objects in client-side code, then pass selected IDs to pivot, set or aggregate tools.

Fetch a single Order by primary key (id).

union two Order sets, identified by primary keys and reloaded for this session.

intersect two Order sets, identified by primary keys and reloaded for this session.

subtract two Order sets, identified by primary keys and reloaded for this session.

Count the selected Order objects and optionally sum a numeric property. Omit group_by for one whole-set total (key: null, zero metrics for an empty set), or group by a property. Returns set and values; each row has a key, member pks and numeric metrics. Filter rows in client-side code and use their pks to continue exploring.

Read Product objects visible to this session. Filter the returned objects in client-side code, then pass selected IDs to pivot, set or aggregate tools.

Fetch a single Product by primary key (id).

union two Product sets, identified by primary keys and reloaded for this session.

intersect two Product sets, identified by primary keys and reloaded for this session.

subtract two Product sets, identified by primary keys and reloaded for this session.

Count the selected Product objects and optionally sum a numeric property. Omit group_by for one whole-set total (key: null, zero metrics for an empty set), or group by a property. Returns set and values; each row has a key, member pks and numeric metrics. Filter rows in client-side code and use their pks to continue exploring.

Read Note objects visible to this session. Filter the returned objects in client-side code, then pass selected IDs to pivot, set or aggregate tools.

Fetch a single Note by primary key (id).

union two Note sets, identified by primary keys and reloaded for this session.

intersect two Note sets, identified by primary keys and reloaded for this session.

subtract two Note sets, identified by primary keys and reloaded for this session.

Count the selected Note objects and optionally sum a numeric property. Omit group_by for one whole-set total (key: null, zero metrics for an empty set), or group by a property. Returns set and values; each row has a key, member pks and numeric metrics. Filter rows in client-side code and use their pks to continue exploring.

Traverse the Customer → Order link "customerOrders" (one-to-many). Pass an instance returned by get or search; its properties are a snapshot, not authority. Direction is inferred from source.type; an explicit direction must agree.

Traverse the Order → Product link "orderProducts" (many-to-many). Pass an instance returned by get or search; its properties are a snapshot, not authority. Direction is inferred from source.type; an explicit direction must agree.

Traverse the Order → Note link "orderNotes" (one-to-many). Pass an instance returned by get or search; its properties are a snapshot, not authority. Direction is inferred from source.type; an explicit direction must agree.

Follow customerOrders from a set of Customer or Order. Duplicate target identities are removed. Direction is required when both ends have the same type.

Follow orderProducts from a set of Order or Product. Duplicate target identities are removed. Direction is required when both ends have the same type.

Follow orderNotes from a set of Order or Note. Duplicate target identities are removed. Direction is required when both ends have the same type.

Cancel an order. Shipped orders cannot be cancelled. Writes are gated: if a business rule rejects this call, the error is machine-readable ({ code, message }) and the attempt is recorded in the audit log.

Assign a pending order to a person for fulfilment. Writes are gated: if a business rule rejects this call, the error is machine-readable ({ code, message }) and the attempt is recorded in the audit log.

File a triage note against an order. Writes are gated: if a business rule rejects this call, the error is machine-readable ({ code, message }) and the attempt is recorded in the audit log.

Read the append-only audit log: every applied and rejected action, with actor and params. This is an unscoped administrative view — entries are not filtered by visibility (fail-open, declared).