Query group members

Question

question

Mischa Spelt asked Feb 19, '18 anthony.johnson edited Feb 21, '18

Query group members

Hi,

Should any of the following work? Maybe I'm just misunderstanding how $iter works, but I expected a table with the objects in my object group, or - in the last example - a table containing rows with values 1, 2, 3, ....

Table.query("SELECT $2 FROM $1", Group("MyObjectGroup"), $iter(1))
Table.query("SELECT $2 FROM $1", Group("MyObjectGroup").toFlatArray(), $iter(1))
Table.query("SELECT $2 FROM $1", Group("MyObjectGroup").length, Group("MyObjectGroup")[$iter(1)])
Table.query("SELECT $2 FROM $1", Group("MyObjectGroup").length, $iter(1))

Software Version:

FlexSim 18.0.2

query object group

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-02-21T19:10:00Z

anthony.johnson answered Feb 21, '18 anthony.johnson edited Feb 21, '18

The first, third and fourth examples should work fine, although the first one will work differently than you expected. The parameters you pass into the function can either be a number or a node. In the first example, Group("MyObjectGroup") simply returns the node MODEL:/Tools/Groups/MyObjectGroup, which is a list of coupling nodes. Thus, $iter(1) would subsequently return a subnode of that node, not the member of the group.

The second example will not work because the parameter is an Array type, not a number or node (perhaps we should add that ability).

queryexample.fsm (18.0 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.

question