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

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

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

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

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