How can I evaluate attributes of the content of a queue in a SQL query?

Question

question

Joerg Vogel asked Nov 3, '17 Jordan Johnson answered Nov 6, '17

How can I evaluate attributes of the content of a queue in a SQL query?

I am trying to get sum of the physical length of all items in a queue. I think a "SUM" clause will do that, but I can't get even a reference to a single item in the queue. I tried the adjusted approach in Flexsim 16 and it worked. In the current version Flexsim 17.2.2 I get a table which contains "no data" entries. I have tried to cast the queue into different datatypes, which doesn't change anything, I have tried to get a reference by a rank, that doesn't work neither. The Tutorial method does not work from the section "Advanced Query Techniques" under "SQL queries". Passing the Flexscript function in Dot-syntax or classic structure makes no difference. If I execute the code in a script window, doesn't change anything. What is the current syntax to query the items in a queue?

Software Version:

FlexSim 17.2.2

queue query sql tutorials no data

query-code-help-not-functions.jpg (147.2 KiB)

· 4

Joerg Vogel commented · Nov 03, 2017 at 01:06 PM

here is the file:query-queue-content-v1722.fsm

0 ·

query-queue-content-v1722.fsm (15.7 KiB)

Arun Kr Joerg Vogel commented · Nov 03, 2017 at 04:49 PM

Hi Jörg Vogel,

It's working for me. I used $iter only to get a reference of the flow items inside the Queue. Also, there is a chance that, it can be a bug. Blank tables with red linings were appearing sometimes after performing a sum operation and then performing the code below. Not sure the exact cause.

Table result = Table.query("SELECT  $2 AS Item,$3 AS Name,$4 AS Size FROM $1 Queue",model().find("Queue1"),$iter(1),$iter(1).as(Object).name,$iter(1).as(Object).size.x);
result.cloneTo(Table("GlobalTable1"));
<br>

support-joerg.fsm

Regards,

Arun KR

1 ·

support-joerg.fsm (14.4 KiB)

Joerg Vogel Arun Kr commented · Nov 03, 2017 at 05:53 PM

Thanks, @Arun KR, I get a result of the size, even if the reference to the item contains in the table cell a "no data" entry. I thought, where no data is, there can not be a result at all. That is a mistake. There is data, but not visible.

Table resultQueue1 = Table.query("SELECT SUM($2) AS itemsQueueLength FROM $1",
             /*$1*/model().find("Queue1"),
             /*$2*/$iter(1).as(Object).size.x);

0 ·

Show more comments

Answer 1 · 2017-11-06T16:47:06Z

Jordan Johnson answered Nov 6, '17

To get the length of all the items in a queue, I used this code:

Table.query("SELECT SUM($2) FROM $1", model().find("Queue1"), $iter(1).as(Object).size.x)[1][1]

I couldn't replicate the issue on my machine (17.2.2).

question