Maintenance plans with every field of the records each row points at: assigned team, preferred technician, preferred vendor, site.
Choose this source when one report needs columns from more than one register. Every list, export and dashboard reads the base view instead, which costs none of these joins — and the planner does not remove them when the columns go unnamed, so the two are separate sources on purpose.
Headers
Limiting and Pagination
Limiting and Pagination
Preference
count=none Query Parameters
Filtering Columns
Ordering
Limiting and Pagination
Limiting and Pagination
Response
OK
60200200Note:
This is a Foreign Key to teams.id.
200Note:
This is a Foreign Key to capex_invite_candidates.id.
200Note:
This is a Foreign Key to capex_invite_candidates.id.
20040Note: This is a Primary Key.
60Note:
This is a Foreign Key to inspection_template_settings.id.
25040150250602002502004060202006040250Note:
This is a Foreign Key to assignable_vendors.id.
200200200302004050200200200306040Note:
This is a Foreign Key to assignable_workers.id.
200401502002005020020010050Note:
This is a Foreign Key to entry_currencies.for_site_id.
602010Note:
This is a Foreign Key to capex_invite_candidates.id.
200Note:
This is a Foreign Key to request_severity_priorities.work_order_priority_id.
Note:
This is a Foreign Key to work_order_types.id.

