As shown in below image I am trying to Query entries based on Priority first and then among same priority by distance.
For Example below entries Product2 and Product3 are Priority 1 and Product is Priority 2. So fist order by Priority and then after that out of Product2 and Product3 I would like order by distance.
Final result should look like Product 3 then Product 2 and then Product 1.
Any feedback on what SQL Query should I use.
You find a link in reference manual section for SQL queries in SQL Language Support to a more common site w3schools.com. There you find often more examples and variants of clauses than in FlexSim manual. This site help me a lot to build my query clauses. Here you need a query clause
ORDER BY .. ASC, .. DESC or ORDER BY .., .. ASC
Hi @Sudheer Reddy,
You could use the following query in your pull from list:
ORDER BY Priority ASC, distance DESCThis query should do the trick, if not just let me know.
13 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
