V_SIMPLEDATALIST_MKTRECORDSSOURCE
Returns a list of available record sources for a segment.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| LABEL | nvarchar(255) |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/2/2010 7:20:43 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.7.1654.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_SIMPLEDATALIST_MKTRECORDSSOURCE AS
select
[QUERYVIEWCATALOG].[DISPLAYNAME] as [LABEL]
from dbo.[MKTRECORDSOURCE]
inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTRECORDSOURCE].[ID]
where dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT]([QUERYVIEWCATALOG].[ID]) = 1;