Querying list partition

Question

question

Guldberg asked Oct 19 2023 at 11:54 AM Jeanette F commented Oct 24 2023 at 3:39 PM

Im trying to count the number of rows in a partion where a label is a certain value, but my query doesnt work for some reason

List cranework = List("CraneWork");
Table result = Table.query("SELECT * FROM cranework.$1",01); 
result.cloneTo(Table("QueryDump"));

I tried hardcoded .01 and putting "01" but no luck the query only kicks up an error

exception: FlexScript exception: No resolved tables at MODEL:/Tools/ProcessFlow/CraneControlPF/Custom Code>variables/codeNode

Its a partitioned global list looking like this

Am I missing something?

Software Version:

FlexSim 23.2.1

sql global list

1697716299841.png (6.1 KiB)

· 1

Answer 1 · 2023-10-19T12:43:07Z

Jason Lightfoot answered Oct 19 2023 at 12:43 PM Jason Lightfoot edited Oct 19 2023 at 12:44 PM

List names are case sensitive - you can't use 'cranework' for 'CraneWork' like you have as a local variable.

Correct syntax:

Table result = Table.query("SELECT * FROM CraneWork.$1","01"); 
result.cloneTo(Table("QueryDump"));