topic Re: sql problem in FlexSim Forum

sql problem

a4225283 — Thu, 08 Dec 2022 11:55:31 GMT

[ 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

Re: sql problem

jason_lightfoot_adsk — Thu, 08 Dec 2022 16:38:44 GMT

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.

Re: sql problem

a4225283 — Mon, 12 Dec 2022 08:11:50 GMT

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

Re: sql problem

jason_lightfoot_adsk — Mon, 12 Dec 2022 11:06:55 GMT

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.

Re: sql problem

a9080109 — Mon, 12 Dec 2022 15:45:37 GMT

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

Re: sql problem

jason_lightfoot_adsk — Mon, 12 Dec 2022 16:13:48 GMT

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

Re: sql problem

a9080109 — Mon, 12 Dec 2022 16:15:26 GMT

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

Re: sql problem

jonah_kendellR47TC — Fri, 16 Dec 2022 17:01:10 GMT

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.

Re: sql problem

jason_lightfoot_adsk — Fri, 16 Dec 2022 17:05:01 GMT

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.