> For the complete documentation index, see [llms.txt](https://help.holixa.com/holixa-erp-picker/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.holixa.com/holixa-erp-picker/es-erp-picker/attachments/vault-select/select-example-for-verification.md).

# SELECT example for verification:

SELECT ItemNumber, ItemTitle, ItemDetail, units, CategoryName, IsConsumable, IsObsolete, <mark style="background-color:orange;">CONVERT(NVARCHAR(10), (SELECT TOP (1) Value FROM dbo.Property AS P WHERE (EntityID = dbo.vw\_ItemRevision.ItemIterationID) AND (PropertyDefID=166)) AS TpvZm</mark>&#x20;

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 <mark style="background-color:orange;">PropertyDefID</mark> value for the required property can be found in the PropertyDef table