USP_DATALIST_FAFHELPCONFIG

Get List of Help configs available in faf.

Parameters

Parameter	Parameter Type	Mode	Description
@PARTID	uniqueidentifier	IN	Partid
@CONTENTTYPESID	int	IN	Contenttype
@HELPID	int	IN	Helpid

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FAFHELPCONFIG
       (    @PARTID uniqueidentifier = null, 
                    @CONTENTTYPESID int = NULL, 
                    @HELPID int = NULL
                )with execute as caller
as
    set nocount on;

    select ID,
        PARTID, 
        CONTENTTYPESID, 
        HELPID,
            HELPIDDESCRIPTION, 
        HELPSTATUSCODE, 
        HELPSTATUS,
        CUSTOMHELPURL, 
        CUSTOMTOOLTIP
    from dbo.FAFHELPCONFIG
    where PARTID = ISNULL(@PARTID,PARTID) 
      and CONTENTTYPESID = ISNULL(@CONTENTTYPESID,CONTENTTYPESID) 
      and HELPID = ISNULL(@HELPID,HELPID)