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)