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 |