UFN_CATALOGITEM_GETNAME
Returns the name for the given catalog item
Return
| Return Type |
|---|
| nvarchar(500) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @catalogItemType | int | IN |
Definition
Copy
CREATE function dbo.UFN_CATALOGITEM_GETNAME(@ID uniqueidentifier, @catalogItemType int) returns nvarchar(500)
as
begin
declare @name nvarchar(500);
if @catalogItemType = 0
select @name = TEMPLATENAME from dbo.DATAFORMTEMPLATECATALOG where ID = @ID -- AddDataFormTemplateSpec
else if @catalogItemType = 1
select @name = CODETABLENAME from dbo.CODETABLECATALOG where ID = @ID -- CodeTableSpec
else if @catalogItemType = 2
select @name = NAME from dbo.DATALISTCATALOG where ID = @ID -- DataListSpec
else if @catalogItemType = 3
select @name = TEMPLATENAME from dbo.DATAFORMTEMPLATECATALOG where ID = @ID -- EditDataFormTemplateSpec
else if @catalogItemType = 4
select @name = NAME from dbo.FUNCTIONALAREACATALOG where ID = @ID -- FunctionalAreaSpec
else if @catalogItemType = 5
select @name = PACKAGENAME from dbo.PACKAGECATALOG where ID = @ID -- PackageSpec
else if @catalogItemType = 6
select @name = NAME from dbo.PAGEDEFINITIONCATALOG where ID = @ID -- PageDefinitionSpec
else if @catalogItemType = 7
select @name = DISPLAYNAME from dbo.QUERYVIEWCATALOG where ID = @ID -- QueryViewSpec
else if @catalogItemType = 8
select @name = DISPLAYNAME from dbo.QUERYVIEWCATALOG where ID = @ID -- QueryViewSpecExtension
else if @catalogItemType = 9
select @name = NAME from dbo.REPORTCATALOG where ID = @ID -- ReportSpec
else if @catalogItemType = 10
select @name = NAME from dbo.SEARCHLISTCATALOG where ID = @ID -- SearchListSpec
else if @catalogItemType = 11
select @name = NAME from dbo.SIMPLEDATALISTCATALOG where ID = @ID -- SimpleDataListSpec
else if @catalogItemType = 12
select @name = NAME from dbo.SMARTQUERYCATALOG where ID = @ID -- SmartQuerySpec
else if @catalogItemType = 13
select @name = FUNCTIONNAME from dbo.SQLFUNCTIONCATALOG where ID = @ID -- SQLFunctionSpec
else if @catalogItemType = 14
select @name = PROCEDURENAME from dbo.SQLPROCEDURECATALOG where ID = @ID -- SQLStoredProcedureSpec
else if @catalogItemType = 15
select @name = TABLENAME from dbo.TABLECATALOG where ID = @ID -- TableSpec
else if @catalogItemType = 16
select @name = TABLENAME from dbo.TABLECATALOG where ID = @ID -- TableSpecExtension
else if @catalogItemType = 17
select @name = NAME from dbo.TASKCATALOG where ID = @ID -- TaskSpec
else if @catalogItemType = 18
select @name = NAME from dbo.TRANSLATIONFUNCTIONCATALOG where ID = @ID -- TranslationFunctionSpec
else if @catalogItemType = 19
select @name = TEMPLATENAME from dbo.DATAFORMTEMPLATECATALOG where ID = @ID -- ViewDataFormTemplateSpec
else if @catalogItemType = 20
select @name = NAME from dbo.BATCHTYPECATALOG where ID = @ID -- BatchTypeSpec
else if @catalogItemType = 21
select @name = NAME from dbo.IDMAPPERCATALOG where ID = @ID -- IDMapperSpec
else if @catalogItemType = 22
select @name = NAME from dbo.BUSINESSPROCESSCATALOG where ID = @ID -- BusinessProcessSpec
else if @catalogItemType = 23
select @name = DISPLAYNAME from dbo.RECORDOPERATIONCATALOG where ID = @ID -- RecordOperationSpec
else if @catalogItemType = 24
select @name = NAME from dbo.DASHBOARDCATALOG where ID = @ID -- FlashDashSpec
else if @catalogItemType = 25
select @name = NAME from dbo.KPICATALOG where ID = @ID -- KpiSpec
else if @catalogItemType = 26
select @name = NAME from dbo.MERGETASKCATALOG where ID = @ID -- MergeTaskSpec
else if @catalogItemType = 27
select @name = PROCEDURENAME from dbo.SMARTFIELDCATALOG where ID = @ID -- SmartFieldSpec
else if @catalogItemType = 28
select @name = DISPLAYNAME from dbo.GLOBALCHANGECATALOG where ID = @ID -- GlobalChangeSpec
else if @catalogItemType = 29
select @name = NAME from dbo.WEBDASHBOARDPAGE where ID = @ID -- WebDashboardPageSpec
else if @catalogItemType = 30
select @name = NAME from dbo.SYSTEMPRIVILEGECATALOG where ID = @ID -- SystemPrivilegeSpec
else if @catalogItemType = 31
select @name = DISPLAYNAME from dbo.CONFIGURATIONDATACATALOG where ID = @ID -- ConfigurationDataSpec
else if @catalogItemType = 32
select @name = NAME from dbo.BATCHTYPEEXTENSIONCATALOG where ID = @ID -- BatchTypeExtensionSpec
else if @catalogItemType = 33
select @name = NAME from dbo.MAPENTITYCATALOG where ID = @ID -- MapEntitySpec
else if @catalogItemType = 34
select @name = NAME from dbo.DATAFORMADDINCATALOG where ID = @ID -- DataFormAddInSpec
else if @catalogItemType = 35
select @name = NAME from dbo.BBWORKFLOWCATALOG where ID = @ID -- WorkflowSpec
else if @catalogItemType = 36
set @name = null -- CustomUIModelMetaData
else if @catalogItemType = 37
select @name = NAME from dbo.CALENDARCATALOG where ID = @ID -- CalendarSpec
else if @catalogItemType = 38
select @name = NAME from dbo.RELATIONSHIPMAPCATALOG where ID = @ID -- RelationshipMapSpec
else if @catalogItemType = 39
select @name = NAME from dbo.UIWIDGETCATALOG where ID = @ID -- UIWidgetSpec
else if @catalogItemType = 40
select @name = NAME from dbo.BBWORKFLOWINBOX where ID = @ID -- WorkflowInboxSpec
else if @catalogItemType = 41
select @name = VIEWNAME from dbo.SQLVIEWCATALOG where ID = @ID -- SQL View Spec
else if @catalogItemType = 42
select @name = NAME from dbo.TASKWIZARDCATALOG where ID = @ID -- TaskWizardSpec
else if @catalogItemType = 43
select @name = NAME from dbo.FEATUREGROUPCATALOG where ID = @ID -- FeatureGroupSpec
else if @catalogItemType = 44
select @name = NAME from dbo.BATCHTYPEADDINCATALOG where ID = @ID -- BatchTypeAddInSpec
else
set @name = null
return @name
end