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)