V_QUERY_DATAFORMINSTANCE_ADDINS
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| DATAFORMINSTANCEID | uniqueidentifier | ||
| NAME | nvarchar(60) | ||
| DESCRIPTION | nvarchar(1000) | ||
| ASSEMBLYNAME | nvarchar(128) | ||
| CLASSNAME | nvarchar(128) | ||
| ENABLED | bit | ||
| SEQUENCE | int | ||
| DATAFORMADDINSPECXML | xml | ||
| ID | uniqueidentifier | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:30:53 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_DATAFORMINSTANCE_ADDINS AS
select
ADDIN.DATAFORMINSTANCEID,
ADDIN.NAME,
ADDIN.DESCRIPTION,
ADDIN.ASSEMBLYNAME,
ADDIN.CLASSNAME,
ADDIN.ENABLED,
ADDIN.SEQUENCE,
ADDIN.DATAFORMADDINSPECXML,
ADDIN.ID,
ADDIN.DATEADDED,
ADDIN.DATECHANGED,
ADDIN.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME
from dbo.DATAFORMADDINCATALOG as ADDIN
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = ADDIN.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = ADDIN.CHANGEDBYID