SELECT example for verification:

SELECT ItemNumber, ItemTitle, ItemDetail, units, CategoryName, IsConsumable, IsObsolete, CONVERT(NVARCHAR(10), (SELECT TOP (1) Value FROM dbo.Property AS P WHERE (EntityID = dbo.vw_ItemRevision.ItemIterationID) AND (PropertyDefID=166)) AS TpvZm

FROM dbo.vw_ItemRevision

WHERE (ItemIterationID IN (SELECT MAX(ItemIterationID) AS E1 FROM dbo.vw_ItemIteration AS I1 GROUP BY itemMasterID))

• highlighted in yellow is the part of the SQL query that retrieves the user property

• sql function CONVERT converts a value (table Property, field Value) from the sql_variant type to a specific type to

ERP picker over user property enabled filtering

• the PropertyDefID value for the required property can be found in the PropertyDef table