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

Question

question

Stephen M2 asked Sep 6, '22 Stephen M2 commented Sep 7, '22

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

Software Version:

FlexSim 21.1.5

process flow bug using lists pull list sql code

test.jpg (51.0 KiB)

Answer 1 · 2022-09-06T22:24:13Z

Jason Lightfoot answered Sep 6, '22 Stephen M2 commented Sep 7, '22

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

Stephen M2 commented · Sep 07, 2022 at 12:03 PM

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

0 ·

question