List Journal Entries
Journal Entries
List Journal Entries
Workspace-scoped, cursor-paginated list of journal_entry records. Served by the generic read-only resource handler over the data-views pipeline (Hasura row-level security).
GET
List Journal Entries
Filtering & sorting on related objects
Filter and sort on a related (included) object by nesting into the relationship — the same relationships you pass toinclude.
- To-one relations nest directly:
{ "issuer": { "name": { "_eq": "Acme" } } }, and sort by a dot-path:"orderBy": { "field": "issuer.name", "direction": "asc" }. - To-many relations must be quantified with
_some,_every, or_none:{ "items": { "_some": { "quantity": { "_gt": 1 } } } }. They are not directly sortable (a to-many sort needs an aggregate proxy). - Composite
composite_*columns are virtual — filter and sort on their underlying source fields, not on the composite.
include) and how to filter or sort on each:
| Relationship | Cardinality | Filter on a field | Sort by a field |
|---|---|---|---|
workspace | to-one (workspace) | { "workspace": { "name": { "_eq": … } } } | "field": "workspace.name" ✅ |
journal | to-one (journal) | { "journal": { "name": { "_eq": … } } } | "field": "journal.name" ✅ |
validated_by | to-one (people) | { "validated_by": { "full_name": { "_eq": … } } } | "field": "validated_by.full_name" ✅ |
invoice_transaction | to-one (invoice_transaction) | { "invoice_transaction": { "field_name": { "_eq": … } } } | "field": "invoice_transaction.field_name" ✅ |
lines | to-many (journal_entry_line) | { "lines": { "_some": { "field_name": { "_eq": … } } } } | aggregate proxy only ⚠️ |
sourceWorkspaceConnector | to-one (workspace_connector) | { "sourceWorkspaceConnector": { "name": { "_eq": … } } } | "field": "sourceWorkspaceConnector.name" ✅ |
field_name with any field of the related object. See its object-reference page for the full field list.
Filter by a to-one relation (and sort by it):
Query Parameters
Page size (max 200).
Required range:
x <= 200Opaque keyset cursor; omit for the first page.
Field to order by.
Available options:
asc, desc Optional explicit workspace scope (Firebase-authenticated callers).
Response
A page of journal_entry records.