UFN_SALESORDERITEM_GETMEMBERSHIPFIELDS_TOXML
Returns an xml representation of memberships for a sales order.
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESORDERITEMID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SALESORDERITEM_GETMEMBERSHIPFIELDS_TOXML(@SALESORDERITEMID uniqueidentifier)
returns xml
as begin
return (select
MEMBERSHIPID,
MEMBERSHIPPROGRAMID,
MEMBERSHIPLEVELID,
MEMBERSHIPLEVELTERMID,
MEMBERSHIPLEVELTYPECODEID [MEMBERSHIPTYPECODEID],
NUMBEROFCHILDREN,
COMMENTS,
ISGIFT,
SENDRENEWALCODE,
EXPIRATIONDATE,
GIVENBYID,
(select
MEMBER.MEMBERID [ID],
MEMBER.CONSTITUENTID,
MEMBER.ISPRIMARY,
(select
MEMBERSHIPCARD.MEMBERSHIPCARDID [ID],
MEMBERSHIPCARD.NAMEONCARD,
MEMBERSHIPCARD.EXPIRATIONDATE
from dbo.SALESORDERITEMMEMBERSHIPCARD as MEMBERSHIPCARD
where MEMBERSHIPCARD.SALESORDERITEMMEMBERID = MEMBER.ID
for xml raw('ITEM'),type,elements,BINARY BASE64) MEMBERSHIPCARDS
from dbo.SALESORDERITEMMEMBER as MEMBER
where MEMBER.SALESORDERITEMMEMBERSHIPID = MEMBERSHIP.ID
for xml raw('ITEM'),type,elements,BINARY BASE64) MEMBERS
from dbo.SALESORDERITEMMEMBERSHIP as MEMBERSHIP
where MEMBERSHIP.ID = @SALESORDERITEMID
for xml raw('ITEM'),type,elements,root('MEMBERSHIPFIELDS'),BINARY BASE64
)
end