How to synchronize the information in a dashboard to a global table?

Question

question

Liam Chiu asked Apr 1, '23 Felix Möhlmann answered Apr 3, '23

How to synchronize the information in a dashboard to a global table?

I used SQL syntax to organize the data for display on a dashboard, and I am wondering if there is a way to synchronize the information on the dashboard to a global table.

Thank you for your advance.

test_1.fsm

Software Version:

FlexSim 20.1.3

global table

1680340428714.png (22.4 KiB)

1680340481145.png (5.2 KiB)

test-1.fsm (141.8 KiB)

· 1

Joerg Vogel commented · Apr 01, 2023 at 10:48 AM

@Liam Chiu, SQL works in background with tables. You should be able to use SQL to output an result table, that you can clone to be shown in a global table.

0 ·

Answer 1 · 2023-04-03T06:04:09Z

Felix Möhlmann answered Apr 3, '23

Might I ask why you even want the data in a global table, when you already have it in a dashboard and calculated table?

As Jörg said in his comment, you can clone the calculated table to the global table:

"Table.query("SELECT * FROM CalculatedTable1").cloneTo(Table("GlobalTable1"));

For example in the On Row Finished trigger of the statistics collector, so the global table is always up to date. Though as I said, I don't really see the point of doing this.

question