Numeric Custom Attributes

To access the System.Int64 value of a numeric custom attribute view the configuration and note the identifier.

To access the value of the custom attribute the GetCustomAttributeInteger function can be used, this will return a T-SQL BIGINT value, or NULL if the custom attribute is not defined.

SELECT 

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

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

  [dbo].[GetCustomAttributeInteger] ([dbo].[ItemCore].[ItemID], 'df8a177e-8ed1-4936-8870-39e9e925bdd1') AS [PIN number]

FROM [dbo].[ItemCore]

WHERE 

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