USP_DATAFORMTEMPLATE_VIEW_MKTAPPEALRECORDSOURCE
The load procedure used by the view dataform template "Record Source Appeal View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @APPEALRECORDSOURCENAME | nvarchar(255) | INOUT | Appeal record source |
| @APPEALIDFIELD | nvarchar(255) | INOUT | Appeal ID field |
| @DESCRIPTIONFIELD | nvarchar(255) | INOUT | Description field |
| @INACTIVEFIELD | nvarchar(255) | INOUT | Inactive field |
| @STARTDATEFIELD | nvarchar(255) | INOUT | Start date field |
| @ENDDATEFIELD | nvarchar(255) | INOUT | End date field |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTAPPEALRECORDSOURCE]
(
@ID uniqueidentifier,
@APPEALRECORDSOURCENAME nvarchar(255) = null output,
@APPEALIDFIELD nvarchar(255) = null output,
@DESCRIPTIONFIELD nvarchar(255) = null output,
@INACTIVEFIELD nvarchar(255) = null output,
@STARTDATEFIELD nvarchar(255) = null output,
@ENDDATEFIELD nvarchar(255) = null output,
@DATALOADED bit = 0 output
)
as
set nocount on;
set @DATALOADED = 0;
select
@DATALOADED = 1,
@APPEALRECORDSOURCENAME = [QUERYVIEWCATALOG].[DISPLAYNAME],
@APPEALIDFIELD = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTAPPEALRECORDSOURCE].[APPEALIDFIELD]),
@DESCRIPTIONFIELD = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTAPPEALRECORDSOURCE].[DESCRIPTIONFIELD]),
@INACTIVEFIELD = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTAPPEALRECORDSOURCE].[INACTIVEFIELD]),
@STARTDATEFIELD = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTAPPEALRECORDSOURCE].[STARTDATEFIELD]),
@ENDDATEFIELD = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTAPPEALRECORDSOURCE].[ENDDATEFIELD])
from dbo.[MKTAPPEALRECORDSOURCE]
inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTAPPEALRECORDSOURCE].[QUERYVIEWCATALOGID]
where [MKTAPPEALRECORDSOURCE].[ID] = @ID;
-- always return loaded as true
set @DATALOADED = 1
return 0;