Database Reference
In-Depth Information
The string value for the outrigger is represented by the
[OutriggerName]Value
at-
tribute, which is
IncidentStatusValue
in this case:
SELECT
i.Id,
i.Status,
s.IncidentStatusValue
FROM
IncidentDimvw i
LEFT OUTER JOIN IncidentStatusvw s ON
i.Status_IncidentStatusId = s.IncidentStatusId
WHERE
i.IsDeleted = 0