UFN_GETSPEC
Returns the xml for the given spec
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CatalogItemType | int | IN |
Definition
Copy
CREATE function [dbo].[UFN_GETSPEC](@ID uniqueidentifier, @CatalogItemType int) returns xml
as
begin
declare @xml xml
if @CatalogItemType = 0
select @xml = TEMPLATESPECXML from dbo.DATAFORMTEMPLATECATALOG where ID = @ID -- AddDataFormTemplateSpec
else if @CatalogItemType = 1
select @xml = CODETABLESPECXML from dbo.CODETABLECATALOG where ID = @ID -- CodeTableSpec
else if @CatalogItemType = 2
select @xml = DATALISTSPEC from dbo.DATALISTCATALOG where ID = @ID -- DataListSpec
else if @CatalogItemType = 3
select @xml = TEMPLATESPECXML from dbo.DATAFORMTEMPLATECATALOG where ID = @ID -- EditDataFormTemplateSpec
else if @CatalogItemType = 4
select @xml = FUNCTIONALAREASPECXML from dbo.FUNCTIONALAREACATALOG where ID = @ID -- FunctionalAreaSpec
else if @CatalogItemType = 5
select @xml = PACKAGESPECXML from dbo.PACKAGECATALOG where ID = @ID -- PackageSpec
else if @CatalogItemType = 6
select @xml = PAGEDEFINITIONSPEC from dbo.PAGEDEFINITIONCATALOG where ID = @ID -- PageDefinitionSpec
else if @CatalogItemType = 7
select @xml = QUERYVIEWSPEC from dbo.QUERYVIEWCATALOG where ID = @ID -- QueryViewSpec
else if @CatalogItemType = 8
select @xml = QUERYVIEWSPECEXTENSION from dbo.QUERYVIEWCATALOG where ID = @ID -- QueryViewSpecExtension
else if @CatalogItemType = 9
select @xml = REPORTSPECXML from dbo.REPORTCATALOG where ID = @ID -- ReportSpec
else if @CatalogItemType = 10
select @xml = SEARCHLISTSPEC from dbo.SEARCHLISTCATALOG where ID = @ID -- SearchListSpec
else if @CatalogItemType = 11
select @xml = SIMPLEDATALISTSPECXML from dbo.SIMPLEDATALISTCATALOG where ID = @ID -- SimpleDataListSpec
else if @CatalogItemType = 12
select @xml = SMARTQUERYSPEC from dbo.SMARTQUERYCATALOG where ID = @ID -- SmartQuerySpec
else if @CatalogItemType = 13
select @xml = SQLFUNCTIONSPECXML from dbo.SQLFUNCTIONCATALOG where ID = @ID -- SQLFunctionSpec
else if @CatalogItemType = 14
select @xml = SQLPROCEDURESPECXML from dbo.SQLPROCEDURECATALOG where ID = @ID -- SQLStoredProcedureSpec
else if @CatalogItemType = 15
select @xml = TABLESPECXML from dbo.TABLECATALOG where ID = @ID -- TableSpec
else if @CatalogItemType = 16
select @xml = TABLESPECEXTENSIONXML from dbo.TABLECATALOG where ID = @ID -- TableSpecExtension
else if @CatalogItemType = 17
select @xml = TASKSPECXML from dbo.TASKCATALOG where ID = @ID -- TaskSpec
else if @CatalogItemType = 18
select @xml = TRANSLATIONFUNCTIONSPEC from dbo.TRANSLATIONFUNCTIONCATALOG where ID = @ID-- TranslationFunctionSpec
else if @CatalogItemType = 19
select @xml = TEMPLATESPECXML from dbo.DATAFORMTEMPLATECATALOG where ID = @ID -- ViewDataFormTemplateSpec
else if @CatalogItemType = 20
select @xml = SPECXML from dbo.BATCHTYPECATALOG where ID = @ID -- BatchTypeSpec
else if @CatalogItemType = 21
select @xml = IDMAPPERSPECXML from dbo.IDMAPPERCATALOG where ID = @ID -- IDMapperSpec
else if @CatalogItemType = 22
select @xml = BUSINESSPROCESSSPECXML from dbo.BUSINESSPROCESSCATALOG where ID = @ID -- BusinessProcessSpec
else if @CatalogItemType = 23
select @xml = RECORDOPERATIONSPECXML from dbo.RECORDOPERATIONCATALOG where ID = @ID -- RecordOperationSpec
else if @CatalogItemType = 24
select @xml = SPECXML from dbo.DASHBOARDCATALOG where ID = @ID -- FlashDashSpec
else if @CatalogItemType = 25
select @xml = SPECXML from dbo.KPICATALOG where ID = @ID -- KpiSpec
else if @CatalogItemType = 26
select @xml = SPECXML from dbo.MERGETASKCATALOG where ID = @ID -- MergeTaskSpec
else if @CatalogItemType = 27
select @xml = SMARTFIELDSPECXML from dbo.SMARTFIELDCATALOG where ID = @ID -- SmartFieldSpec
else if @CatalogItemType = 28
select @xml = GLOBALCHANGESPECXML from dbo.GLOBALCHANGECATALOG where ID = @ID -- GlobalChangeSpec
else if @CatalogItemType = 29
set @xml = null -- WebDashboardPageSpec
else if @CatalogItemType = 30
set @xml = null -- SystemPrivilegeSpec
else if @CatalogItemType = 31
select @xml = CONFIGURATIONDATASPECXML from dbo.CONFIGURATIONDATACATALOG where ID = @ID -- ConfigurationDataSpec
else if @CatalogItemType = 32
select @xml = SPECXML from dbo.BATCHTYPEEXTENSIONCATALOG where ID = @ID -- BatchTypeExtensionSpec
else if @CatalogItemType = 33
select @xml = MAPENTITYXML from dbo.MAPENTITYCATALOG where ID = @ID -- MapEntitySpec
else if @CatalogItemType = 34
select @xml = DATAFORMADDINSPECXML from dbo.DATAFORMADDINCATALOG where ID = @ID -- DataFormAddInSpec
else if @CatalogItemType = 35
select @xml = SPECXML from dbo.BBWORKFLOWCATALOG where ID = @ID -- WorkflowSpec
else if @CatalogItemType = 36
set @xml = null -- CustomUIModelMetaData
else if @CatalogItemType = 37
select @xml = CALENDARSPECXML from dbo.CALENDARCATALOG where ID = @ID -- CalendarSpec
else if @CatalogItemType = 38
select @xml = RELATIONSHIPMAPSPECXML from dbo.RELATIONSHIPMAPCATALOG where ID = @ID -- RelationshipMapSpec
else if @CatalogItemType = 39
select @xml = UIWIDGETSPECXML from dbo.UIWIDGETCATALOG where ID = @ID -- UIWidgetSpec
else if @CatalogItemType = 40
select @xml = SPECXML from dbo.BBWORKFLOWINBOX where ID = @ID -- WorkflowInboxSpec
else if @CatalogItemType = 41
select @xml = SQLVIEWSPECXML from dbo.SQLVIEWCATALOG where ID = @ID -- SQL View Spec
else if @CatalogItemType = 42
select @xml = SPECXML from dbo.TASKWIZARDCATALOG where ID = @ID -- TaskWizardSpec
else if @CatalogItemType = 43
select @xml = SPECXML from dbo.FEATUREGROUPCATALOG where ID = @ID -- FeatureGroupSpec
else if @CatalogItemType = 44
select @xml = BATCHTYPEADDINSPECXML from dbo.BATCHTYPEADDINCATALOG where ID = @ID -- BatchTypeAddInSpec
else
set @xml = null
return @xml
end