Custom Attributes

Information stored for items can be extended using custom sections and attributes. 

To access the display value of a custom attribute in a report, view the configuration of the custom attribute and note the identifier.

To access the display value of the custom attribute the GetCustomAttribute function can be used, for example

SELECT 

  [dbo].[ItemCore].[ItemID] AS [ItemID], 

  [dbo].[ItemCore].[Name] AS [Name],

  [dbo].[GetCustomAttribute] ([dbo].[ItemCore].[ItemID], '11895d89-e346-4e69-ba57-cce12feab370') AS [Server Identifier]

FROM [dbo].[ItemCore]

WHERE 

  [dbo].[ItemCore].[ItemDeletedDate] IS NULL