USP_SIMPLEDATALIST_MKTEXPORTDEFINITIONOUTPUTFIELD
Returns a list of output fields for an export definition.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EXPORTDEFINITIONID | uniqueidentifier | IN | Export definition ID |
| @QUERYVIEWCATALOGID | uniqueidentifier | IN | Query view catalog ID |
Definition
Copy
CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTEXPORTDEFINITIONOUTPUTFIELD]
(
@EXPORTDEFINITIONID uniqueidentifier,
@QUERYVIEWCATALOGID uniqueidentifier = null
)
as
set nocount on;
select
[QUERYFIELD] as [VALUE],
[NAME] as [LABEL]
from
dbo.[MKTEXPORTDEFINITIONOUTPUTFIELD]
where
[EXPORTDEFINITIONID] = @EXPORTDEFINITIONID
and
(@QUERYVIEWCATALOGID is null or [QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID)
order by
[QUERYVIEWCATALOGID], [SEQUENCE];
return 0;