Found items with every field of the records each row points at: found at, found by, matched report, site, stored at.
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
80150603015040Note:
This is a Foreign Key to capex_invite_candidates.id.
20030Note:
This is a Foreign Key to asset_cost_to_keep.currency_id.
2004030200601502015040Note:
This is a Foreign Key to capex_invite_candidates.id.
200Note:
This is a Foreign Key to location_settings.id.
200Note: This is a Primary Key.
8015020020020050Note:
This is a Foreign Key to lost_found_categories.id.
8015012015040200402002002002556030201504040200805020020200Note:
This is a Foreign Key to lost_item_reports.id.
40Note:
This is a Foreign Key to capex_invite_candidates.id.
2551504040200Note:
This is a Foreign Key to capex_invite_candidates.id.
802002005020020010050Note:
This is a Foreign Key to entry_currencies.for_site_id.
200202008015020020020050Note:
This is a Foreign Key to location_settings.id.
200200Note:
This is a Foreign Key to capex_invite_candidates.id.
Note:
This is a Foreign Key to capex_invite_candidates.id.
200
