The maintenance rounds behind one row of the maintenance explorer, with what became of each.

The maintenance rounds behind one row of the maintenance explorer, with what became of each.

p_filter narrows by the keys it has: site_id, location_id (with everything inside it, unless location_exact is true), plan_id, asset_id, category_id (the asset’s category, with the categories under it, unless category_exact is true), team_id and worker_id. A key present with a null value means the rounds with none; asset_id null is the rounds against a place. The site and location are the asset’s, or the round’s own for a round against a place. The team and worker are the work order’s once one is raised, and the plan’s own team and preferred worker before then. p_from and p_to bound the due date, p_to exclusive.

outcome is one of COVERED (stood down by a less frequent round that did its work), ON_TIME, LATE, OVERDUE (open and past due), UPCOMING (open and not yet due) or SKIPPED (closed without being done, cancelled included). was_deferred is true for a round whose date was moved. counts_for_compliance is true for a round the PM compliance figure counts: due or done, not stood down, and on a work order type that counts towards compliance. p_measure narrows to one figure: an outcome, DEFERRED or COUNTED. Rows are the rounds the caller can already see.