SQL Query

[sudheer_r]

[ FlexSim 20.1.2 ]

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.

[joerg_vogel_HsH · Accepted solution]

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

[patrick_zweekhorst]

Hi @Sudheer Reddy,

You could use the following query in your pull from list:

ORDER BY Priority ASC, distance DESC

This query should do the trick, if not just let me know.

[sudheer_r]

Thanks for feedback

[sudheer_r]

It helped me...thank you