question

Stephen M2 avatar image
0 Likes"
Stephen M2 asked Stephen M2 commented

A "Pull-from-Operator-list" step in the process flow doesn't work

This code approach works fine in another model but won't in this model. I have already deleted and replaced the offending process flow task (PullFromOperatorList) in an attempt to fix. I know the query works because it finds the list item in flexscript code in the "decide Part To be moved - CC" task but then doesn't in the pull from list task. The goal is to get the operator to pick up the flowitem at sequencelist10 and move it to StabC01. This particular model will probably bomb after that move which is OK Thanks

Steve Miller

Test .jpg

FlexSim 21.1.5
process flowbugusing listspull listsql code
test.jpg (51.0 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

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Stephen M2 commented

Since you're testing a string the sql clause should reflect that by using apostrophes around the comparison text - so WHERE TaskName='StabC'

This is the current syntax to pull from the list within your Decide activity:

List operators=List("OperatorList");
ListCurrent = operators.pull( "WHERE TaskName ='StabC'", 0,0,nullvar,nullvar,0);
· 1
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.

Stephen M2 avatar image Stephen M2 commented ·

Thanks so much Jason. Your answer really reminds me of how much I need to learn and understand.

0 Likes 0 ·