Related Lists

The Related Lists tool scans all reference relationships for the current record's table hierarchy and shows you exactly which related lists have data, which ones are on the form, and which ones are hidden. It's the fastest way to discover relationships you didn't know existed.

Open it with /skrl or /skrelatedlists, or select Related Lists from the Sidekick menu. The tool requires a form to be open — it reads the table and record from g_form.

How It Works

When you open the tool, it:

1. Resolves the table hierarchy — Walks the inheritance chain (e.g., incident → task → cmdb) to find all parent tables
2. Discovers related lists — Queries sys_dictionary for all reference fields pointing to any table in the hierarchy
3. Counts records — Uses batched GraphQL queries to efficiently count matching records for each related list, with automatic REST fallback when needed
4. Detects form presence — Checks which related lists are currently displayed on the form and in what order

Sections

Results are organized into three collapsible sections:

Not on Form (with records)

The most actionable section. These are related lists that have matching records for the current record but are not displayed on the form. This helps you discover data relationships you might be missing.

Each item shows the table label, technical name (e.g., task_ci.task), record count, and a link icon to open that related list in a new tab.

On Form

Related lists currently displayed on the form, ordered to match their visual position on the page. Each item shows:

• on form badge — Confirms the related list is present
• hidden badge — Appears if the related list is on the form configuration but not currently rendered (e.g., in a collapsed tab or hidden by a UI policy)
• Record count and open-in-new-tab link

Not on Form (empty)

Related lists with zero matching records that aren't on the form. This section is collapsed by default to keep the view clean.

Filtering

Use the search box at the top to filter related lists by table label or technical name. The filter applies across all three sections in real-time.

Exclusions

The tool automatically excludes tables that typically produce noise:

• Tables starting with var__ (variable tables)
• Tables starting with ecc_ (ECC queue tables)
• Tables containing 00 (internal/system tables)

Scripted Relations

Scripted related lists (prefixed with REL:) can appear on the form but cannot have their record counts queried through standard APIs. These are noted in the summary with the message: "Scripted relations are not in this list."

Record Counting

Counts are fetched using GraphQL _rowCount queries in batches of 40 for performance. If GraphQL is unavailable or returns an error for specific tables (e.g., due to ACL restrictions), the tool automatically falls back to the REST Stats API for those tables. Items where neither method succeeds show ? as the count.

Tips

• Start here when investigating a record — The "Not on Form (with records)" section often reveals related data that explains unexpected behavior.
• Check for hidden related lists — The "hidden" badge on the On Form section helps identify related lists that are configured but not visible to the user.
• Open in new tab — Click the arrow icon on any related list to navigate directly to that list filtered for the current record.
• Combine with Form Analyzer — Use Form Analyzer to understand why a related list might be hidden (UI policies, view rules), then use Related Lists to see what data exists.

Related

• Sidekick Overview — All Sidekick tools
• Form Analyzer — Analyze UI policies, client scripts, and business rules
• Log Viewer — Real-time system log monitoring