V_QUERY_MKTASKLADDER
Provides the ability to query ask ladders.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | System record ID | |
| NAME | nvarchar(100) | Name | |
| STATUS | varchar(8) | Status | |
| ENTRYAMOUNT | nvarchar(514) | yes | Entry amount |
| ISINUSE | bit | yes | Is in use? |
| RECORDSOURCE | nvarchar(255) | yes | Record source |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | Added by application |
| ADDEDBY_USERNAME | nvarchar(128) | yes | Added by user name |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | Changed by application |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | Changed by user name |
| DATEADDED | datetime | Date added | |
| DATECHANGED | datetime | Date changed | |
| TSLONG | bigint | yes | Timestamp value |
| SITEID | uniqueidentifier | yes | Site ID |
| BASECURRENCYID | uniqueidentifier | yes | Base currency ID |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 11/11/2014 4:14:09 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.2.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_MKTASKLADDER AS
select
[MKTASKLADDER].[ID],
[MKTASKLADDER].[NAME],
(case when [MKTASKLADDER].[ISACTIVE] = 1 then 'Active' else 'Inactive' end) as [STATUS],
coalesce([FIELDINFO].[PARENTTYPE] + ' \ ' + [FIELDINFO].[DISPLAYNAME],[SMARTFIELDINFO].[PARENTTYPE] + ' \ ' + [SMARTFIELDINFO].[DISPLAYNAME],[MKTASKLADDER].[OBJECTKEY]) as [ENTRYAMOUNT],
dbo.[UFN_MKTASKLADDER_ISINUSE]([MKTASKLADDER].[ID]) as [ISINUSE],
(select [DISPLAYNAME] from dbo.[QUERYVIEWCATALOG] where [ID]=[MKTASKLADDER].[RECORDSOURCEID]) as [RECORDSOURCE],
/* System fields */
[ADDEDBY].[APPLICATIONNAME] as [ADDEDBY_APPLICATION],
[ADDEDBY].[USERNAME] as [ADDEDBY_USERNAME],
[CHANGEDBY].[APPLICATIONNAME] as [CHANGEDBY_APPLICATION],
[CHANGEDBY].[USERNAME] as [CHANGEDBY_USERNAME],
[MKTASKLADDER].[DATEADDED],
[MKTASKLADDER].[DATECHANGED],
[MKTASKLADDER].[TSLONG],
[MKTASKLADDER].[SITEID],
[MKTASKLADDER].[BASECURRENCYID]
/*#EXTENSION*/
from dbo.[MKTASKLADDER]
left join (select
[QUERYVIEWCATALOG].[DISPLAYNAME] as [PARENTTYPE],
(select isnull(T.c.value('(@Caption)[1]','nvarchar(255)'), T.c.value('(@Name)[1]','nvarchar(255)')) from [QUERYVIEWCATALOG].OUTPUTDEFINITIONXML.nodes('declare namespace QV="bb_appfx_queryview";/QueryViewOutput/QV:OutputFields/QV:OutputField') T(c) where T.c.value('(@Name)[1]','nvarchar(255)') = [SYSCOLUMNS].[NAME]) as [DISPLAYNAME],
[SYSCOLUMNS].[NAME] + '.' + [QUERYVIEWCATALOG].[OBJECTNAME] as [OBJECTKEY]
from dbo.[QUERYVIEWCATALOG]
left join dbo.[SYSOBJECTS] on [SYSOBJECTS].[NAME] = [QUERYVIEWCATALOG].[OBJECTNAME]
left join dbo.[SYSCOLUMNS] on [SYSCOLUMNS].[ID] = [SYSOBJECTS].[ID]
) as [FIELDINFO] on [FIELDINFO].[OBJECTKEY] = [MKTASKLADDER].[OBJECTKEY]
left join (select
'Smart Field' as [PARENTTYPE],
[SMARTFIELD].[NAME] as [DISPLAYNAME],
[SMARTFIELD].[VALUECOLUMNNAME] + '.' + [TABLECATALOG].[TABLENAME] as [OBJECTKEY]
from dbo.[SMARTFIELD]
inner join dbo.[SMARTFIELDCATALOG] on [SMARTFIELDCATALOG].[ID] = [SMARTFIELD].[SMARTFIELDCATALOGID]
inner join dbo.[TABLECATALOG] on [TABLECATALOG].[ID] = [SMARTFIELD].[TABLECATALOGID]
) as [SMARTFIELDINFO] on [SMARTFIELDINFO].[OBJECTKEY] = [MKTASKLADDER].[OBJECTKEY]
left outer join dbo.[CHANGEAGENT] as [ADDEDBY] on [ADDEDBY].[ID] = [MKTASKLADDER].[ADDEDBYID]
left outer join dbo.[CHANGEAGENT] as [CHANGEDBY] on [CHANGEDBY].[ID] = [MKTASKLADDER].[CHANGEDBYID]