sample-query-listorderby.fsmIn the attached model, I needed to first populate many flowitems into a list then have a 3D object to pull a flowitem with the lowest value for label START_LOC_SEQ from list. But I am not able to achieve it.
description of the model
a) 2 sources are used to populate 2 racks with 100 flowitems each. These flowitems are pushed into list through "send to port -> use list". RackA set its flowitems to have label START_LOC_SEQ to be 2, RackB to be 1. All flowitems has label CAS_STATUS to be "EMPTY".
b) A queue is configured to pull a flowitem from the list using query "
WHERE CAS_STATUS = "EMPTY" order by START_LOC_SEQ ASC"
c) It is observed that sequence of population of flowitems into list is first RackA followed by RackB.
Result: I expect that queue will get a flowitem from rackB base on the query, but it gets a flowitem from rackA instead. So, I reason that in the midst that the list is being populated, 100 flowitems from each rack, the queue pull "successfully" a flowitem which is from rackA.
d) Set the query in the queue to be "WHERE CAS_STATUS = "DUMMY" order by START_LOC_SEQ ASC" which will not be able to match any flowitem in the list while it gets populated.
e) At a later time (1 sec) the query is change to "WHERE CAS_STATUS = "EMPTY" order by START_LOC_SEQ ASC".
f) Added a 5 sec time interval "back order evaluation event" on the list. As I reason that the change in the query will not take effect since there is no more opportunities to evaluate back order on the list.
Result: I expected that that queue will get a flowitem from rackB, but it still gets a flowitem from rackA.
Any advise on how to solve this issue? I understand using processflow works (which is my current workaround) but is there any way to use 3D pull to make it work?