USP_DATALIST_ACTION_ITEM_FOLDER
Returns all Action Item Folder records.
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@FOLDERID | int | IN | Folder ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_ACTION_ITEM_FOLDER (@FOLDERID int = NULL) with execute as owner
as
set nocount on;
select
ACTIONITEMFOLDER.[ID],
ACTIONITEMFOLDER.[FOLDERID],
ACTIONITEMFOLDER.[ACTIONITEMID]
from
dbo.ACTIONITEMFOLDER
where
FOLDERID = ISNULL(@FOLDERID,FOLDERID)