USP_DATALIST_SELECTIONSBYGROUPNAME

CREATE procedure dbo.USP_DATALIST_SELECTIONSBYGROUPNAME
(
    @RECORDTYPEID uniqueidentifier,
    @GROUPNAME nvarchar(50)
)
as
    set nocount on;

    select
        IDSETREGISTER.ID as ID,
        IDSETREGISTER.NAME as NAME
    from
        dbo.IDSETREGISTER

        -- Filter by installed products

        left join dbo.SQLFUNCTIONCATALOG
            on SQLFUNCTIONCATALOG.FUNCTIONNAME = IDSETREGISTER.DBOBJECTNAME

    where
        (ACTIVE = 1) and
        (RECORDTYPEID = @RECORDTYPEID) and 
        (GROUPNAME = @GROUPNAME) and 
        (
            (SQLFUNCTIONCATALOG.ID is null)
            or dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED (
                SQLFUNCTIONCATALOG.SQLFUNCTIONSPECXML.query (
                    'declare namespace common="bb_appfx_commontypes";
                    /*/common:InstalledProductList'
                )
            ) = 1
        )
        and IDSETREGISTER.ISSYSTEM = 0

    order by
        NAME