See 'Find Item' Query Result Set

Question

question

Stan Davis asked Oct 2, '23 Stan Davis commented Oct 2, '23

See 'Find Item' Query Result Set

I need to verify the results of a 'Find Item' query by seeing the complete result set. I'm specifically testing the Order By clause. This question regarding the 'Find Slot' activity was asked here..

https://answers.flexsim.com/questions/107224/am-i-able-to-see-a-result-set-of-a-query-from-find.html

However, the accepted answer did not provide a manner to see the complete result set but only the result. Any help would be appreciated. Thanks.

Software Version:

FlexSim 23.1.4

sql queries finditem

Answer 1 · 2023-10-02T19:54:30Z

Kavika F answered Oct 2, '23 Stan Davis commented Oct 2, '23

Hey @Stan Davis, have you tried the "queryItems" function? This returns an Array of Storage.Slot.Item values that match your specified query.

· 1

Stan Davis commented · Oct 02, 2023 at 09:02 PM

Kavika,

That works. In case this helps someone else, this is what I ended up doing..

Array myarray;
myarray =  Storage.system.queryItems("WHERE PartNo == $1.PartNo ORDER BY AssetQty DESC", 0, token);

Table result =  Table.query("SELECT $2 as item FROM $1", myarray.length, myarray[$iter(1)]);
result.cloneTo(Table("QueryDump"));

Thanks to @Joerg Vogel for the cloneTo solution found here...

https://answers.flexsim.com/questions/52264/how-to-query-an-array.html

Thanks again,

Stan

2 ·

question