sql problem

[a4225283]

[ FlexSim 20.0.10 ]

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

[jason_lightfoot_adsk · Accepted solution]

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.

[a4225283]

I've done something similar but it didn't work out as I expected1115-+柔.fsm

[jason_lightfoot_adsk]

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.

[a9080109]

I don't understand why she has sorted but not in order

[jason_lightfoot_adsk]

It looks sorted by spt to me. If you need more columns in the sort then add them to the ORDER BY clause.

[a9080109]

Yes, but it’s lined up. Shouldn’t the pulling be done in order? But she’s still pulling alternately

[jonah_kendellR47TC]

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.

[jason_lightfoot_adsk]

Mark, post the model and a good description instead of sending cryptic one-liners. And is this a group project or are you using numerous accounts? You seem to be answering many posts as if they were your own issue.