Skip Navigation
Expand
Null assgn_acct_id results in a mismatch between workspace & report.
Answer ID 10319   |   Last Review Date 04/03/2019

Why does the Assigned value in a workspace not match the value in a report?

Environment:

All sites, Reporting, Workspaces.

Issue:

Incidents' assigned account ID does not match in both your workspace and a report.

Cause:

In an incident workspace, the Incidents.Assigned field typically shows the value of incidents.assgn_acct_id. However, if incidents.assgn_acct_id is null (has no value), then the workspace will show you the value of incidents.assgn_group_id instead.

Resolution:

You can force a report to match the workspace. To force the report to match the workspace, you will need to replace the column definition incidents.assgn_acct_id with the following:

       IF(incidents.assgn_acct_id IS NULL, incidents.assgn_group_id, incidents.assgn_acct_id)

Available Languages for this Answer:

Notify Me
The page will refresh upon submission. Any pending input will be lost.