Workspace related lists count

[George_1]

When I open a record, the related tab “Diagnosis and Recovery Tasks” initially shows a count of 5. However, when I click and open the related list tab, it loads and displays the actual count, which is 149 records.

Any suggestions on where to debug this.

[Ankur Bawiskar]

@George_1 

was this working fine earlier and you recently upgraded?

if yes then raise a case with ServiceNow

[George_1]

@Ankur Bawiskar , it was noticed even before upgrade.

[Ankur Bawiskar]

@George_1 

how about other workspaces? like CSM etc

If same behavior then it seems some property is controlling it

[Dr Atul G- LNG]

not sure, but try to repair the plugin.

[Naveen20 · Accepted solution]

@George_1 

This is almost always a defined relationship script or a before-query business rule that evaluates differently for the count versus the list.

You may Debug as below

Open the related list definition (right-click the list header > Configure > Related Lists, or check sys_relationship). If "Diagnosis and Recovery Tasks" is a defined relationship, inspect its "Query with" script — the count and list often diverge here.

Check for before-query business rules on the target task table that conditionally add filters.

Enable session debug (SQL/Security) and compare the encoded query fired for the count tab vs. the opened list. Related lists can return the wrong number of records when a query rule or relationship is involved.