@MaxRows)
UNION ALL
SELECT TOP (@MaxRows)
'Document' AS [Class]
,[Owner]
,[Type]
,[Number]
,ItemId AS [HK100]
,Description AS [Name]
,CASE
WHEN [PendingRevision] IS NOT NULL THEN [PendingRevision]
ELSE [Revision]
END AS [Revision]
,CASE
WHEN [PendingLifecycle] IS NOT NULL THEN [PendingLifecycle]
ELSE [Lifecycle]
END AS [Lifecycle]
,CASE
WHEN [PendingRevision] IS NOT NULL THEN 'Pending'
WHEN [IsCanceled] = 'FALSE' THEN 'Released'
ELSE 'Canceled'
END AS [Status]
,CASE
WHEN [IsHomeItem] = 0 THEN 'Partner'
ELSE 'Home'
END AS [Issuer]
FROM
[viewer].[ItemView]
WHERE
[Class] = 2
ORDER BY
[Owner],[Type],[Number]
]]>
DataGrid