UFN_EVENT_GETRELATEDEVENTAPPEALS_TOITEMLISTXML

Returns all linked appeals for a given event and its related events--in XML format

Return

Return Type
xml

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTIDS	UDT_GENERICID	IN

Definition

Copy



CREATE function dbo.UFN_EVENT_GETRELATEDEVENTAPPEALS_TOITEMLISTXML
(
    @EVENTIDS UDT_GENERICID readonly
)
returns XML
with execute as caller
as
begin
return(
    select
        EVENT.ID [EVENTID],
        EVENT.APPEALID
    from
        dbo.EVENT
    where
        EVENT.ID in (select ID from @EVENTIDS)
    order by EVENTID
    for xml raw('ITEM'),type,elements,root('MULTICOMPONENTEVENTAPPEALS'),BINARY BASE64
)
end