SQL query on internal list?

Question

question

Jan Brinkjans asked Oct 5, '18 Jan Brinkjans commented Oct 21, '18

SQL query on internal list?

To copy a global list to a global table you can use the following command:
Table.query("SELECT * FROM List1").cloneTo("GlobalTable1");

Is it possible to do something similar with an internal list?
List InternalList = ?
Table.query("SELECT * FROM $1”, InternalList).cloneTo("GlobalTable1");

Thank you!

bumped

Software Version:

FlexSim 18.2.2

sql query internal lists

Answer 1 · 2018-10-10T20:48:42Z

Jordan Johnson answered Oct 10, '18 Jan Brinkjans commented Oct 21, '18

I don't think it's possible to use the Table.query command on an internal list in the List shared asset. If the list is global, create an identical list in the Toolbox, and reference that list instead. Then you will be able to query it.

· 1

Jan Brinkjans commented · Oct 21, 2018 at 05:08 PM

Thank you! It would be great if you could implement the feature in a future version of FlexSim.

0 ·

question