I want to make sure that my list has the following policies (say item1=1 and item 1=3) to do =3 first and I have labels to give them spt (say item1=n's spt is 300 item 3=m The spt is 30) In this case, 30 items will be made first1115-+柔.fsm
sql problem
FlexSim 20.0.10
Hi @chiang, was Jason Lightfoot's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.
If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.
When pulling from a list and assuming you want to do the higher Types first, use:
ORDER BY Type DESC, ProcessTime ASC
Or if you just want Type 3:
WHERE Type=3 ORDER BY ProcessTime ASC
Your model appears to have a lot of repetition - you should probably be using Object Process Flows to reduce the modelling effort and apparent complexity.
I've done something similar but it didn't work out as I expected1115-+柔.fsm
All your values in SPT are 3. This column is just the processing time of the item (apparantly a plane? - odd choice).
Check your list entries and tell us at what time you expect something is going wrong, with the evidence to show why it's wrong. Going through this process you may uncover the answer - if not we'll be happy to investigate.
I've checked the first list I found where you were pulling by SPT, but you should be specific about which activity and list we should be checking.
14 People are following this question.
