USP_DATAFORMTEMPLATE_VIEW_MKTGIFTRECORDSOURCE
The load procedure used by the view dataform template "Record Source Gift View Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter used to load the fields defined on the form. |
| @DATALOADED | bit | INOUT | Output parameter indicating whether or not data was actually loaded. |
| @GIFTRECORDSOURCENAME | nvarchar(255) | INOUT | Gift record source |
| @APPEALSYSTEMIDFIELDNAME | nvarchar(255) | INOUT | Appeal system ID |
| @APPEALIDFIELDNAME | nvarchar(255) | INOUT | Appeal ID |
| @APPEALDESCRIPTIONFIELDNAME | nvarchar(255) | INOUT | Appeal description |
| @AMOUNTFIELDNAME | nvarchar(255) | INOUT | Gift amount |
| @DONORIDFIELDNAME | nvarchar(255) | INOUT | Donor ID |
| @SOURCECODEFIELDNAME | nvarchar(255) | INOUT | Source code |
| @MAILINGIDFIELDNAME | nvarchar(255) | INOUT | Effort ID |
| @DATEFIELDNAME | nvarchar(255) | INOUT | Gift date |
| @FINDERNUMBERFIELDNAME | nvarchar(255) | INOUT | Finder number |
| @DATEADDEDFIELDNAME | nvarchar(255) | INOUT | Date added |
| @DONOTACKNOWLEDGEFIELDNAME | nvarchar(255) | INOUT | Do not acknowledge |
| @DONOTRECEIPTFIELDNAME | nvarchar(255) | INOUT | Do not receipt |
| @DATECHANGEDFIELDNAME | nvarchar(255) | INOUT | Date changed |
| @LOOKUPIDFIELDNAME | nvarchar(255) | INOUT | Lookup ID |
| @BASECURRENCYIDFIELDNAME | nvarchar(255) | INOUT | Base currency ID |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MKTGIFTRECORDSOURCE
(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@GIFTRECORDSOURCENAME nvarchar(255) = null output,
@APPEALSYSTEMIDFIELDNAME nvarchar(255) = null output,
@APPEALIDFIELDNAME nvarchar(255) = null output,
@APPEALDESCRIPTIONFIELDNAME nvarchar(255) = null output,
@AMOUNTFIELDNAME nvarchar(255) = null output,
@DONORIDFIELDNAME nvarchar(255) = null output,
@SOURCECODEFIELDNAME nvarchar(255) = null output,
@MAILINGIDFIELDNAME nvarchar(255) = null output,
@DATEFIELDNAME nvarchar(255) = null output,
@FINDERNUMBERFIELDNAME nvarchar(255) = null output,
@DATEADDEDFIELDNAME nvarchar(255) = null output,
@DONOTACKNOWLEDGEFIELDNAME nvarchar(255) = null output,
@DONOTRECEIPTFIELDNAME nvarchar(255) = null output,
@DATECHANGEDFIELDNAME nvarchar(255) = null output,
@LOOKUPIDFIELDNAME nvarchar(255) = null output,
@BASECURRENCYIDFIELDNAME nvarchar(255) = null output
)
as
set nocount on;
set @DATALOADED = 0;
select
@DATALOADED = 1,
@GIFTRECORDSOURCENAME = [QUERYVIEWCATALOG].[DISPLAYNAME],
@APPEALSYSTEMIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[APPEALSYSTEMIDFIELD]),
@APPEALIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[APPEALIDFIELD]),
@APPEALDESCRIPTIONFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[APPEALDESCRIPTIONFIELD]),
@AMOUNTFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[AMOUNTFIELD]),
@DONORIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[DONORIDFIELD]),
@SOURCECODEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[SOURCECODEFIELD]),
@MAILINGIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[MAILINGIDFIELD]),
@DATEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[DATEFIELD]),
@FINDERNUMBERFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[FINDERNUMBERFIELD]),
@DATEADDEDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[DATEADDEDFIELD]),
@DONOTACKNOWLEDGEFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[DONOTACKNOWLEDGEFIELD]),
@DONOTRECEIPTFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[DONOTRECEIPTFIELD]),
@DATECHANGEDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[DATECHANGEDFIELD]),
@LOOKUPIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[LOOKUPIDFIELD]),
@BASECURRENCYIDFIELDNAME = dbo.[UFN_QUERYVIEW_GETFIELDCAPTION]([QUERYVIEWCATALOG].[ID], [MKTGIFTRECORDSOURCE].[BASECURRENCYIDFIELD])
from dbo.[MKTGIFTRECORDSOURCE]
inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTGIFTRECORDSOURCE].[QUERYVIEWCATALOGID]
where [MKTGIFTRECORDSOURCE].[ID] = @ID;
-- always return loaded as true
set @DATALOADED = 1
return 0;