Query orders
Orders
Query orders
Search and filter orders from the local database.
Available Filters
- text: Free-text search across multiple fields
- plate: Filter by license plate (partial match)
- person: Filter by customer name (partial match)
- phone: Filter by phone number
- email: Filter by email address
- status: Filter by project status
- damage: Filter by damage category
- station: Filter by station ID
- missing_parts: Only show orders with missing parts
- zu_verplanen: Filter by “zu verplanen” status (true=unplanned, false=planned)
- after/before: Filter by shop date range (YYYY-MM-DD)
- finish_after/finish_before: Filter by finish date range
Pagination
Use limit and offset for pagination. Maximum 1000 results per request.
GET
Query orders
Authorizations
Query Parameters
Free-text search query
License plate filter
Person name filter
Phone number filter
Email filter
Project status filter
Damage category filter
Station ID filter
Filter orders with missing parts
Filter by zu verplanen status (true=unplanned, false=planned)
Shop date >= YYYY-MM-DD
Shop date <= YYYY-MM-DD
Finish date >= YYYY-MM-DD
Finish date <= YYYY-MM-DD
Maximum results per page
Required range:
1 <= x <= 1000Number of results to skip
Required range:
x >= 0