My work with every field of the records each row points at: asset, assigned team, assigned vendor, contract, department, location, maintenance plan, site, work request.
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
200602006080200402002008020025080120502006020200Note:
This is a Foreign Key to asset_categories.id.
Note:
This is a Foreign Key to asset_contracts.asset_id.
2508060200200Note:
This is a Foreign Key to teams.id.
2002002502004060202006040250Note:
This is a Foreign Key to assignable_vendors.id.
2003030604015020012020020050200602020020060Note:
This is a Foreign Key to contract_cover.contract_id.
Note:
This is a Foreign Key to capex_invite_candidates.id.
2002005020020020020080Note: This is a Primary Key.
8015020020020050Note:
This is a Foreign Key to location_settings.id.
Note:
This is a Foreign Key to asset_maintenance_plans.next_occurrence_id.
200200200406025040150250602002004015050602010200304015080Note:
This is a Foreign Key to capex_invite_candidates.id.
200602002002005020020010050Note:
This is a Foreign Key to entry_currencies.for_site_id.
Note:
This is a Foreign Key to state_models.version_id.
6020Note: This is a Primary Key.
250Note:
This is a Foreign Key to asset_cost_to_keep.currency_id.
Note:
This is a Foreign Key to capex_invite_candidates.id.
20012040Note:
This is a Foreign Key to asset_categories.id.
60Note:
This is a Foreign Key to work_order_resolution_codes.id.
40Note:
This is a Foreign Key to work_order_types.id.
150250802002002006020020020602004060204015025020060Note:
This is a Foreign Key to work_requests.id.

