Skip to Main Content
Need Support? Let’s guide you to the right answer or agent.
Status Needs review
Created by Guest
Created on Feb 15, 2024

Create an Advanced Query Function that can pull Class UOM

Create an ECSQL built-in function like ‘ec_clanname() and ‘ec_classid()’. It could have this form:

ec_getPropertyUnit( ecclass, ecproperty )


Its functionality is to pull the component's unit of measurement (UOM).

How frequently will feature be used? A few times a week
How much time will you save? It will save us time to hardcode (ie CAST(equip.DRY_WEIGHT AS TEXT) || 'kg' as [DryWeight]) the UOM into the query for a property that's readily available in OpenPlant
Your Industry Process Manufacturing