question

Marian Cretu avatar image
0 Likes"
Marian Cretu asked Joerg Vogel answered

Query by array

Hello guys,

Is it possible to query a table looking for a specific array in the table ?

For example I have the following table :

Is it possible to show all the racks that contain array (A,0,1) ?


Thank you.

Regards,

FlexSim 19.2.1
flexsim 19.2.1
capture.jpg (14.8 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered 
Table.query("SELECT rack, pallet_details FROM GlobalTable1 \
            WHERE pallet_details = $1",["A",0,1])             					   .cloneTo(Table("dump"));

Global Table "dump" is another table to print the result.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.