SQL query objects from calculated table

Question

question

lyn-lyn11 asked Apr 25, '24 Xavier Low answered Apr 26, '24

SQL query objects from calculated table

I making statistic collector which each row will query the "Elevator" status from calculated table. However, the elevator stored in calculated table is in Object, but the statistic collector is query using string. How to convert calculated table object to string?

return Table.query("SELECT Idle FROM [AMR Lift Utilization] WHERE Elevator = $1",data.token.Lift)[1][1];

Software Version:

FlexSim 24.1.0

sql queries

Answer 1 · 2024-04-26T06:01:48Z

Xavier Low answered Apr 26, '24

Hello @lyn_lyn11 ,

If you want to just get the Elevator object name instead of the object itself, based on the example you have provided, you can do: data.token.Lift.name

Hope this helps.

question