USP_DATALIST_TASKREFERENCEDFEATURES

CREATE procedure dbo.USP_DATALIST_TASKREFERENCEDFEATURES
(
    @TASKID uniqueidentifier
)
as
    set nocount on;

    select 
        ITEMTYPE,
        ITEMID,
        case ITEMTYPE
            when 0 then 'Add Data Form'
            when 3 then 'Edit Data Form'
            when 6 then 'Page'
            when 7 then 'Query View'
            when 9 then 'Report'
            when 10 then 'Search List'
            when 19 then 'View Data Form'
            when 22 then 'Business Process'
            when 23 then 'Record Operation'
        end as ITEMTYPENAME,
        ITEMNAME,
        ITEMIMAGEKEY,
        INSTALLED
    from dbo.UFN_TASK_FEATURES(@TASKID)