USP_REPORT_ACTIONITEMDETAIL
Return action items associated with given action center
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LINE | varchar(max) | IN |
Definition
Copy
create procedure dbo.USP_REPORT_ACTIONITEMDETAIL
@LINE VARCHAR(MAX) = NULL
as
begin
IF ISNULL(@LINE,'') = ''
BEGIN
select DISTINCT a.ACTIONITEMID as VALUE , b.NAME AS LABEL --, a.SITECONTENTID
from dbo.ACTIONCENTER a (NOLOCK)
JOIN dbo.ACTION_ITEM b (NOLOCK)
ON a.ACTIONITEMID = b.ID
END
ELSE
BEGIN
select DISTINCT a.ACTIONITEMID as VALUE , b.NAME AS LABEL --, a.SITECONTENTID
from dbo.ACTIONCENTER a (NOLOCK)
JOIN dbo.ACTION_ITEM b (NOLOCK)
ON a.ACTIONITEMID = b.ID
WHERE a.SITECONTENTID IN ( SELECT element_value FROM dbo.UFN_PARSE_STRING(@LINE,',') )
GROUP by a.ACTIONITEMID, b.name, a.SITECONTENTID
END
end