Report on extended tables
-
- UpdatedJan 30, 2025
- 5 minutes to read
- Yokohama
- Reporting
Learn how to include fields from tables that extend the Task table in a single report. For example, you could include both incidents and problems in a single report.
Before you begin
Role required: itil, report_user, report_group, report_global, report_admin, or admin. To include the columns in the report that are unique to the extended tables, a user with the admin role must enable a system property [glide.ui.list.allow_extended_fields]:
- Navigate to .
- Enable the property Allow base table lists (task, cmdb_ci, and so on) to include extended table fields (incident_state, os_version, and the like), and allow filtering on extended table fields (glide.ui.list.allow_extended_fields).
- Click Save at the bottom of the page.
Role required: report_admin.
About this task
Watch this six-minute video to learn how to include fields on extended tables in reports by starting with the parent table.
The video shows how to create a report with data from multiple tables using the Report Designer. The report contains both incidents and problems, which are child tables of the Task table. Here's how to create the report, Active Incidents and Problems of Priority 1 or 2.
Procedure
Related tables in reporting
Watch the video to learn how to use dot-walking, dynamic filters, and database views to access data on extended, or related, tables.
Watch this five-minute video to learn how to use dot walking to include data from extended or related tables in reports. The video also discusses using dynamic filters in reports and reporting on database views.
Reporting on extended table fields using dot-walking
Dot-walking provides access to fields on extended, or related, tables, enabling you to report on fields from those tables.
When creating or editing a report, you can access references on extended tables from the Group
by/Stack by, column/row, or Trend by fields on the Configure tab. The Add Sort option also
enables you to configure the sort order of applicable reference fields on extended tables. Tables
that reference other tables are denoted with an arrow () icon.
Dot-walking references a field by building a chain of field names separated by dots (periods). For example, incident.assigned_to.company references the company of the user assigned to an incident. The recommended limit for chain length is three levels.
- In a report on the incident table, select Additional Group By on the Configure tab.
- Select Assigned to [+] and then the structure icon (
).
You now see the related fields in the user table.
- Move Company [+] to the Selected column and select OK.
- Save the report.Assigned to Company is an option in the report's Group by list. In this example, you see Assigned to Active because the Active field is a configured Stack by option.