V_QUERY_CATALOGITEM
Used to query catalog items loaded in the system.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CATALOGTABLENAME | nvarchar(26) | Catalog table name | |
| TYPENAMEVALUE | int | yes | Type name value |
| TYPENAME | nvarchar(24) | yes | Type name |
| ID | uniqueidentifier | Feature ID | |
| NAME | nvarchar(255) | Name | |
| DESCRIPTION | nvarchar(max) | yes | Description |
| 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 |
| SPECUINAME | nvarchar(100) | Name override | |
| UINAME | nvarchar(255) | Display name |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:41:34 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CATALOGITEM AS
select
[CATALOGUNION].CATALOGTABLENAME,
[CATALOGUNION].TYPENAMEVALUE,
[CATALOGUNION].TYPENAME,
[CATALOGUNION].ID,
[CATALOGUNION].NAME,
[CATALOGUNION].DESCRIPTION,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME],
[CATALOGUNION].DATEADDED,
[CATALOGUNION].DATECHANGED,
[CATALOGUNION].TSLONG,
[CATALOGUNION].SPECUINAME,
[CATALOGUNION].UINAME
/*#EXTENSION*/
from
(
select
N'DATAFORMTEMPLATECATALOG' [CATALOGTABLENAME],
case [CATALOGTABLE].MODE
when 0 then 19
when 1 then 3
when 2 then 0
end [TYPENAMEVALUE],
case [CATALOGTABLE].MODE
when 0 then N'ViewDataFormTemplateSpec'
when 1 then N'EditDataFormTemplateSpec'
when 2 then N'AddDataFormTemplateSpec'
end [TYPENAME],
[CATALOGTABLE].ID,
[CATALOGTABLE].TEMPLATENAME [NAME],
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.DATAFORMTEMPLATECATALOG [CATALOGTABLE]
union all
select
N'CODETABLECATALOG',
1,
N'CodeTableSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].CODETABLENAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].CODETABLESPECXML.value('declare namespace codetable="bb_appfx_codetable"; /CodeTableSpec[1]/@Description', 'nvarchar(255)'),
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.CODETABLECATALOG [CATALOGTABLE]
union all
select
N'DATALISTCATALOG',
2,
N'DataListSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.DATALISTCATALOG [CATALOGTABLE]
union all
--EditDataFormTemplateSpec specs (Type 3) are loaded from dbo.DATAFORMTEMPLATECATALOG above
select
N'FUNCTIONALAREACATALOG',
4,
N'FunctionalAreaSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.FUNCTIONALAREACATALOG [CATALOGTABLE]
union all
select
N'PACKAGECATALOG',
5,
N'PackageSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].PACKAGENAME,
N'',
[CATALOGTABLE].PACKAGENAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.PACKAGECATALOG [CATALOGTABLE]
union all
select
N'PAGEDEFINITIONCATALOG',
6,
N'PageDefinitionSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.PAGEDEFINITIONCATALOG [CATALOGTABLE]
union all
select
N'QUERYVIEWCATALOG',
7,
N'QueryViewSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].DISPLAYNAME,
N'',
[CATALOGTABLE].DISPLAYNAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.QUERYVIEWCATALOG [CATALOGTABLE]
union all
--QueryViewSpecExtension specs (Type 8) are stored in dbo.QUERYVIEWCATALOG but don't have their own row
select
N'REPORTCATALOG',
9,
N'ReportSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.REPORTCATALOG [CATALOGTABLE]
union all
select
N'SEARCHLISTCATALOG',
10,
N'SearchListSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SEARCHLISTCATALOG [CATALOGTABLE]
union all
select
N'SIMPLEDATALISTCATALOG',
11,
N'SimpleDataListSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SIMPLEDATALISTCATALOG [CATALOGTABLE]
union all
select
N'SMARTQUERYCATALOG',
12,
N'SmartQuerySpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SMARTQUERYCATALOG [CATALOGTABLE]
union all
select
N'SQLFUNCTIONCATALOG',
13,
N'SQLFunctionSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].FUNCTIONNAME,
N'',
[CATALOGTABLE].FUNCTIONNAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SQLFUNCTIONCATALOG [CATALOGTABLE]
union all
select
N'SQLPROCEDURECATALOG',
14,
N'SQLStoredProcedureSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].PROCEDURENAME,
N'',
[CATALOGTABLE].PROCEDURENAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SQLPROCEDURECATALOG [CATALOGTABLE]
union all
select
N'TABLECATALOG',
15,
N'TableSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].TABLENAME,
N'',
[CATALOGTABLE].TABLENAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.TABLECATALOG [CATALOGTABLE]
union all
--TableSpecExtension specs (Type 16) are stored in dbo.TABLECATALOG but don't have their own row
select
N'TASKCATALOG',
17,
N'TaskSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.TASKCATALOG [CATALOGTABLE]
union all
select
N'TRANSLATIONFUNCTIONCATALOG',
18,
N'TranslationFunctionSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.TRANSLATIONFUNCTIONCATALOG [CATALOGTABLE]
union all
--ViewDataFormTemplateSpec specs (Type 19) are loaded from dbo.DATAFORMTEMPLATECATALOG above
select
N'BATCHTYPECATALOG',
20,
N'BatchTypeSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.BATCHTYPECATALOG [CATALOGTABLE]
union all
select
N'IDMAPPERCATALOG',
21,
N'IDMapperSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.IDMAPPERCATALOG [CATALOGTABLE]
union all
select
N'BUSINESSPROCESSCATALOG',
22,
N'BusinessProcessSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.BUSINESSPROCESSCATALOG [CATALOGTABLE]
union all
select
N'RECORDOPERATIONCATALOG',
23,
N'RecordOperationSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].DISPLAYNAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.RECORDOPERATIONCATALOG [CATALOGTABLE]
union all
select
N'DASHBOARDCATALOG',
24,
N'FlashDashSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.DASHBOARDCATALOG [CATALOGTABLE]
union all
select
N'KPICATALOG',
25,
N'KpiSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.KPICATALOG [CATALOGTABLE]
union all
select
N'MERGETASKCATALOG',
26,
N'MergeTaskSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.MERGETASKCATALOG [CATALOGTABLE]
union all
select
N'SMARTFIELDCATALOG',
27,
N'SmartFieldSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].DISPLAYNAME,
N'',
[CATALOGTABLE].DISPLAYNAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SMARTFIELDCATALOG [CATALOGTABLE]
union all
select
N'GLOBALCHANGECATALOG',
28,
N'GlobalChangeSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].DISPLAYNAME,
N'',
[CATALOGTABLE].DISPLAYNAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.GLOBALCHANGECATALOG [CATALOGTABLE]
union all
select
N'WEBDASHBOARDPAGECATALOG',
29,
N'WebDashboardPageSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.WEBDASHBOARDPAGECATALOG [CATALOGTABLE]
union all
select
N'SYSTEMPRIVILEGECATALOG',
30,
N'SystemPrivilegeSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SYSTEMPRIVILEGECATALOG [CATALOGTABLE]
union all
select
N'CONFIGURATIONDATACATALOG',
31,
N'ConfigurationDataSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].DISPLAYNAME,
N'',
[CATALOGTABLE].DISPLAYNAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.CONFIGURATIONDATACATALOG [CATALOGTABLE]
union all
select
N'BATCHTYPEEXTENSIONCATALOG',
32,
N'BatchTypeExtensionSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.BATCHTYPEEXTENSIONCATALOG [CATALOGTABLE]
union all
select
N'MAPENTITYCATALOG',
33,
N'MapEntitySpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.MAPENTITYCATALOG [CATALOGTABLE]
union all
select
N'DATAFORMADDINCATALOG',
34,
N'DataFormAddInSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.DATAFORMADDINCATALOG [CATALOGTABLE]
union all
select
N'BBWORKFLOWCATALOG',
35,
N'WorkflowSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.BBWORKFLOWCATALOG [CATALOGTABLE]
union all
--CustomUIModelMetadata (Type 36) does not get loaded to a catalog table
select
N'CALENDARCATALOG',
37,
N'CalendarSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.CALENDARCATALOG [CATALOGTABLE]
union all
select
N'RELATIONSHIPMAPCATALOG',
38,
N'RelationshipMapSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.RELATIONSHIPMAPCATALOG [CATALOGTABLE]
union all
select
N'UIWIDGETCATALOG',
39,
N'UIWidgetSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.UIWIDGETCATALOG [CATALOGTABLE]
union all
select
N'BBWORKFLOWINBOX',
40,
N'WorkflowInboxSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.BBWORKFLOWINBOX [CATALOGTABLE]
union all
select
N'SQLVIEWCATALOG',
41,
N'SQLViewSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].VIEWNAME,
N'',
[CATALOGTABLE].VIEWNAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.SQLVIEWCATALOG [CATALOGTABLE]
union all
select
N'TASKWIZARDCATALOG',
42,
N'TaskWizardSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.TASKWIZARDCATALOG [CATALOGTABLE]
union all
select
N'FEATUREGROUPCATALOG',
43,
N'FeatureGroupSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
[CATALOGTABLE].SPECUINAME,
[CATALOGTABLE].UINAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.FEATUREGROUPCATALOG [CATALOGTABLE]
union all
select
N'BATCHTYPEADDINCATALOG',
44,
N'BatchTypeAddInSpec',
[CATALOGTABLE].ID,
[CATALOGTABLE].NAME,
N'',
[CATALOGTABLE].NAME,
[CATALOGTABLE].DESCRIPTION,
[CATALOGTABLE].ADDEDBYID,
[CATALOGTABLE].CHANGEDBYID,
[CATALOGTABLE].DATEADDED,
[CATALOGTABLE].DATECHANGED,
[CATALOGTABLE].TSLONG
from
dbo.BATCHTYPEADDINCATALOG [CATALOGTABLE]
) as [CATALOGUNION]
left join dbo.CHANGEAGENT as ADDEDBY ON ADDEDBY.ID = [CATALOGUNION].ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY ON CHANGEDBY.ID = [CATALOGUNION].CHANGEDBYID