Can I create a Table query on a label acting as a table?

Question

question

Enrique Elizaga asked Mar 20, '19 christian.n rolled back Mar 20, '19

Hi, my label called THELIST is a table. I often access it like this:

Table THELIST = MYOBJECT.labels["THELIST"].as(Table);

I want to use this command on it:

Table.query("SELECT SUM(COLUMN) FROM [THELIST] WHERE [ID] == 1421 AND [DAY] == 1").cloneTo(Table("TEMP"));

Is this possible?

Software Version:

FlexSim 18.2.3

query query on label table query sum

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 · 2019-03-20T08:11:27Z

christian.n answered Mar 20, '19 christian.n rolled back Mar 20, '19

Hi Enrique.

I don't think queries can use locally declared variables.

Try using adding THELIST as a parameter for the query:

Table.query("SELECT SUM(COLUMN) FROM [$1] WHERE [ID] == 1421 AND [DAY] == 1",THELIST).cloneTo(Table("TEMP"));

I substituted THELIST in the query with a '$1' (referring to the 1st parameter of the query), and added THELIST as the parameter.

I added an example model with a source containing a label with table data, and a script with a query.

answersquerylabel.fsm (18.5 KiB)

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.