question

chiang avatar image
0 Likes"
chiang asked Jason Lightfoot commented

sql problem

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

FlexSim 20.0.10
order byqueryitems
1115-柔.fsm (330.5 KiB)
· 1
5 |100000

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 Jason Lightfoot commented Best Answer

When pulling from a list and assuming you want to do the higher Types first, use:

  1. ORDER BY Type DESC, ProcessTime ASC

Or if you just want Type 3:

  1. 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.

· 6
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.