UFN_BBNC_GETCONSTITIDS_FROMSELECTION_ASXML

Returns an XML list of constituent IDs for a constituent query.

Return

Return Type
xml

Parameters

Parameter Parameter Type Mode Description
@SELECTION_MAPID int IN

Definition

Copy


            create function dbo.UFN_BBNC_GETCONSTITIDS_FROMSELECTION_ASXML
            (
                @SELECTION_MAPID int
            )
            returns xml
            as
            begin
                declare @IDSETID uniqueidentifier

                select @IDSETID = IDSETREGISTERID
                from dbo.BBNCIDSETIDMAP 
                where ID = @SELECTION_MAPID;

                return
                (
                    select 
                        CONSTITUENT.SEQUENCEID
                    from dbo.UFN_IDSETREADER_GETRESULTS_GUID(@IDSETID) as [IDSET]
                    inner join dbo.CONSTITUENT on CONSTITUENT.ID = [IDSET].ID 
                    for xml raw('ITEM'),type,elements,root('IDLIST'),binary base64
                )
            end