USP_SIMPLEDATALIST_CONSTITUENTMERGETASK

List of available merge tasks that can be used with constituent merge

Definition



CREATE procedure dbo.USP_SIMPLEDATALIST_CONSTITUENTMERGETASK
as
    set nocount on;

    select 
        m.ID as [VALUE], 
        m.NAME as [LABEL],
        m.SPNAME as [DESCRIPTION]
    from 
        dbo.MERGETASKCATALOG m
        inner join dbo.RECORDTYPE r on m.RECORDTYPEID = r.ID and r.NAME = 'Constituent'
    where
        dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(m.SPECXML.query(
                        'declare namespace common="bb_appfx_commontypes";
                        /*/common:InstalledProductList'
                  )
        ) = 1
    order by
        m.NAME;