How to query an array?

Question

question

Joerg Vogel asked Jun 15, '18 Joerg Vogel commented Mar 3, '19

How to query an array?

Sometimes you need a simple list of values and you want to filter the list. In other cases you get an array of references to items, resources or tokens and you have to filter the array for an item or linked label to it. But how can you query an array.

Software Version:

FlexSim 18.1.1

query array

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-06-15T18:04:19Z

Joerg Vogel answered Jun 15, '18 Joerg Vogel commented Mar 3, '19

The complete array must be converted into a table by a query. Then I can filter the array in the same clause by the attributes I am looking for. Here is an example:

Array one = [12,13,14,15,19];
Table result = Table.query("SELECT $2 AS number FROM $1 WHERE number > 13",
/*$1*/ one.length,
/*$2*/ one[$iter(1)]);
result.cloneTo(Table("myR"));

query-an-array.jpg (98.6 KiB)

· 2

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.

Arimba W commented · Mar 03, 2019 at 06:49 AM

@Jörg Vogel, How do i convert the code into Flexsim 16 compatible, Sir? Thank you

0 ·

Joerg Vogel Arimba W commented · Mar 03, 2019 at 03:00 PM

intarray one = makearray(7);
fillarray(one, 15,9,10,11,12,13,14);
query("SELECT $2 AS number FROM $1 WHERE number > 11",
/*$1*/arraysize(one),
/*$2*/ one[$iter(1)]);
dumpquery(reftable("result"),1);

FlexSim 16.2.2

0 ·

question