List OvertimeReduction (find where)
Find a list of OvertimeReduction records that match the specified criteria.
Tip: All query parameters accept multiple values for array filtering — e.g. ?id=1&id=2 or ?id[]=1&id[]=2. This also works within the where parameter: ?where={"id":[1,2,3]}.
Note: The per-attribute filter parameters and the where parameter are mutually exclusive. If where is supplied, the per-attribute filters are ignored — put all filter criteria inside where instead. limit, skip, sort, and populate are unaffected.
query Parameters
userFilter by user ID
dateFilter by date (YYYY-MM-DD). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
idFilter by record ID
createdAtFilter by creation date (YYYY-MM-DD or YYYY-MM-DDTHH:mm:ss.sssZ). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
updatedAtFilter by last update date (YYYY-MM-DD or YYYY-MM-DDTHH:mm:ss.sssZ). This is an exact match filter; for range queries (greater than, less than), use the where parameter instead
whereA JSON-encoded Waterline criteria for advanced filtering. Only whitelisted criteria are supported: user, date, id, createdAt, updatedAt. Sub-attribute modifiers such as startsWith, >=, <=, >, <, and != are supported on any whitelisted criterion. The contains modifier is not supported on this model.
Note: If where is supplied, the per-attribute filter query parameters above are ignored — where is the entire criteria. (limit, skip, sort, and populate are unaffected.) To combine filters, put them all inside where.
e.g. ?where={"startDate":{">=":"2026-06-01","<":"2026-07-01"}}
limitThe maximum number of records to return. Defaults to 10000, capped at 50000.
skipThe number of records to skip (useful for pagination).
sortThe sort order. By default, returned records are sorted by primary key value in ascending order.
e.g. ?sort=lastName%20ASC
List OvertimeReduction (find where) › Responses
Responds with a paged list of OvertimeReduction records that match the specified criteria
Create OvertimeReduction
Create a new OvertimeReduction record.
Create OvertimeReduction › Request Body
Aerion model OvertimeReduction
Create OvertimeReduction › Responses
Responds with a JSON dictionary representing the newly created OvertimeReduction instance
Aerion model OvertimeReduction
Get OvertimeReduction (find one)
Look up the OvertimeReduction record with the specified ID.
path Parameters
idThe desired OvertimeReduction record's primary key value
Get OvertimeReduction (find one) › Responses
Responds with a single OvertimeReduction record as a JSON dictionary
Aerion model OvertimeReduction
Update OvertimeReduction
Partially update an existing OvertimeReduction record. Despite using PUT, this endpoint applies PATCH semantics — only the fields included in the request body are modified; omitted fields are left unchanged.
path Parameters
idThe desired OvertimeReduction record's primary key value
Update OvertimeReduction › Request Body
Aerion model OvertimeReduction
Update OvertimeReduction › Responses
Responds with the newly updated OvertimeReduction record as a JSON dictionary
Aerion model OvertimeReduction
Overtime / overtime-reduction breakdown for a year
Returns one row per overtime, overtime-reduction, or absence-derived reduction for the given year, split into previous, current, and future time frames. Negative quantity means overtime accrued; positive means a reduction. Without user the response covers every visible user (admins or canAccessUsers); with user, the caller must be the user themselves, an admin, have canAccessUsers, or limitedTeamStaffAccess to the user's team. The extra.amount field is omitted unless the caller has canAccessAdminRemunerations (or canAccessRemunerations when querying a non-admin user).
query Parameters
yearCalendar year.
userRestrict the response to one user. Omit to include every visible user.
end_dateEnd-of-window cutoff (YYYY-MM-DD) within the requested year. Defaults to year-end. Useful for snapshots like "overtime as of today".
Overtime / overtime-reduction breakdown for a year › Responses
Overtime rows for the requested year. Sum row quantities (or filter by year to scope to past / current / future) to compute totals.
userUser ID this row belongs to.
yearprevious: residual overtime carried over from prior years. current: rows dated within the requested year up to today. future: rows dated after today within the requested year.
quantityHours. Negative for overtime accrued; positive for a reduction (or absence-derived reduction).
overtimeCalcType1 overtime hours, 2 overtime reduction (OvertimeReduction model), 3 absence-derived reduction, 4 residual combined.
sortDateSort key — the row's primary date (reduction date or absence startDate).
extranull on previous rows. On current / future rows: identifiers and dates for the source overtime-reduction or absence. amount is included only when the caller has canAccessAdminRemunerations (or canAccessRemunerations against a non-admin user); otherwise null. extra itself is omitted when the caller lacks canAccessRemunerations, canAccessUsers, and root-admin status.