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], '5e6d074d-d7e704f9e-b0ee-eff73bde89b8') AS [Server Identifier]

FROM [dbo].[ItemCore]

WHERE 

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