USP_COMMUNICATIONS_GETSELECTIONGROUPNAMES
Return the selection group names for the given record type ID as an xml collection name SELECTIONLISTS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDTYPEID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_COMMUNICATIONS_GETSELECTIONGROUPNAMES
(
@RECORDTYPEID uniqueidentifier
)
as
begin
select (
select
[NAME] as GROUPNAME
from dbo.[UFN_SELECTION_GETGROUPNAMES](@RECORDTYPEID)
for xml raw('ITEM'),type,elements,root('SELECTIONLISTS'),binary base64
) as SELECTIONLISTS
return 0;
end