topic Re: How to query an array? in FlexSim Forum

How to query an array?

joerg_vogel_HsH — Fri, 15 Jun 2018 17:57:29 GMT

[ FlexSim 18.1.1 ]

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.

Re: How to query an array?

joerg_vogel_HsH — Fri, 15 Jun 2018 18:04:19 GMT

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"));

Re: How to query an array?

arimba_w — Sun, 03 Mar 2019 06:49:42 GMT

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

Re: How to query an array?

joerg_vogel_HsH — Sun, 03 Mar 2019 15:00:21 GMT

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