USP_SIMPLEDATALIST_MKTRECORDSSOURCE
Returns a list of available record sources for a segment.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTRECORDSSOURCE]
(
@CURRENTAPPUSERID uniqueidentifier
)
as
set nocount on;
select
[QUERYVIEWCATALOG].[ID] as [VALUE],
[QUERYVIEWCATALOG].[DISPLAYNAME] as [LABEL]
from dbo.[MKTRECORDSOURCE]
inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([QUERYVIEWCATALOG].[ID]) = 1;
return 0;