Set unit on Property Table's Update Query

Question

question

Luis Gustavo Freitas asked Aug 18, '22 anthony.johnson answered Aug 19, '22

Set unit on Property Table's Update Query

I am trying to use diferent time units on property table (like work with m/min on MaxSpeed and m/seg/seg on acceleration) and pull these inputs from a global table through update query, but every time i execute the query, it pulls the value but change all columns to the same time unit. To turn it back i have to manually change the unit on property table.

Would like to know how could i set or "lock" the unit to not change with the value on update query.

Software Version:

FlexSim 22.1.3

property table update query

imagem-2022-08-18-181547572.png (209.0 KiB)

imagem-2022-08-18-181601143.png (209.8 KiB)

Answer 1 · 2022-08-19T13:55:56Z

anthony.johnson answered Aug 19, '22

You can preserve the units by specifically storing them in the source table, by making the value into an array with two elements. The first element is the value, and the second is the units.

Unfortunately this isn't very user-friendly since copying the property table to the global table will only copy in model units, and even if it did copy arrays over, manipulating arrays in a table isn't very easy anyway. In the next release there will be an additional optional parameter to Object.getProperty() that lets you say whether you want to preserve units (i.e. get the array value instead of just a number). However, that option doesn't apply directly to this use case. I'll add an item to our dev list to consider ways to make the preservation of model units easier in this use case.

1660916829347.png (36.6 KiB)

question