Hi @ShaidaC ,
Creating a list report in ServiceNow that combines RITM variables and Task SLA fields requires a database view or a report on the sc_req_item table with related list fields.
Method 1: Using a Database View (Recommended for complex reporting)
Create a Database View:
- Navigate to System Definition > Database Views.
- Click New.
- Provide a Name (e.g., u_ritm_sla_report).
- Add the following View Tables:
sc_req_item (Prefix: ritm)
task_sla (Prefix: sla) - Define Where Clause for the task_sla table: sla_task = ritm_sys_id. This links the SLA to the RITM.
- Save the Database View.
Create the Report:
- Navigate to Reports > Create New.
- Select Table as the Source type.
- Choose your newly created Database View (e.g., u_ritm_sla_report) as the Table.
- Select List as the Type.
- In the Configure tab, select the desired Columns. You can now access both RITM fields (e.g., ritm_number, ritm_short_description) and Task SLA fields (e.g., sla_business_elapsed_time, sla_stage) directly.
- Add RITM variables by scrolling to the bottom of the Available list and selecting Variables, then choosing the specific variables you want to display.
- Apply any necessary Filters.
- Save the report.
Method 2: Reporting directly on sc_req_item and adding related list fields
Create the Report:
- Navigate to Reports > Create New.
- Select Table as the Source type.
- Choose Requested Item [sc_req_item] as the Table.
- Select List as the Type.
- In the Configure tab, select the desired RITM fields as Columns.
- To add Task SLA fields, scroll down in the Available list and expand the Task SLA (or Task SLA > Task SLA) section under Related List Fields. Select fields like Business elapsed time or Stage.
- Add RITM variables by scrolling to the bottom of the Available list and selecting Variables, then choosing the specific variables you want to display.
- Apply any necessary Filters.
- Save the report.
Note: The Database View method provides more flexibility and potentially better performance for complex queries involving multiple tables, while the direct reporting method is simpler for straightforward scenarios. When adding variables, ensure the selected variables are relevant to the RITMs being reported on.
If you found my response helpful, could you please mark it as ‘Accept as Solution’ and ‘Helpful’? This small action goes a long way in helping other community members find the right answers more easily and supports the community.
