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