01
About this report
One row per active case whose status is not in a closed stage. Each row gives the case number, subject, company, status, priority, assignee, origin, start date, days open and last modified date.
Opened from Support cases by status and age, it arrives filtered to one status and priority. Sort by Days open, or filter Assigned to for one person's queue. The case number opens the case.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Case | Subject | Company | Status | Priority | Assigned to | Origin | Started | Days open | Last modified |
|---|---|---|---|---|---|---|---|---|---|
| 2471 | Invoice PDF missing logo | Harbor & Pine Co. | Re-Opened | Low | Priya Natarajan | 2026-08-11 | 44 | 2026-09-20 | |
| 2519 | Cannot approve purchase order | Northgate Supply | Escalated | High | Tom Okafor | Phone | 2026-09-10 | 14 | 2026-09-23 |
| 2533 | Report totals differ | Brightline Dental Group | In Progress | Medium | Priya Natarajan | Web | 2026-09-18 | 6 | 2026-09-22 |
| 2540 | Login locked | Maple Ridge Clinics | Not Started | High | 2026-09-23 | 1 | 2026-09-23 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT sc.id AS case__id,
sc.casenumber AS case_number,
sc.title AS subject,
BUILTIN.DF(sc.company) AS company,
NVL(BUILTIN.DF(sc.status), '(none)') AS status,
NVL(BUILTIN.DF(sc.priority), '(none)') AS priority,
BUILTIN.DF(sc.assigned) AS assigned_to,
BUILTIN.DF(sc.origin) AS origin,
TO_CHAR(sc.startdate, 'YYYY-MM-DD') AS start_date,
TRUNC(SYSDATE) - TRUNC(sc.startdate) AS days_open,
TO_CHAR(sc.lastmodifieddate, 'YYYY-MM-DD') AS last_modified
FROM supportcase sc
JOIN supportcasestatus s ON s.id = sc.status
WHERE s.stage <> 'CLOSED'
AND sc.isinactive = 'F'
ORDER BY sc.startdate04