topic Re: SQL Query in FlexSim Forum

SQL Query

sudheer_r — Fri, 05 Jun 2020 06:05:32 GMT

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

Re: SQL Query

joerg_vogel_HsH — Fri, 05 Jun 2020 06:30:00 GMT

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

Re: SQL Query

patrick_zweekhorst — Fri, 05 Jun 2020 06:32:11 GMT

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.

Re: SQL Query

sudheer_r — Fri, 05 Jun 2020 07:21:23 GMT

Thanks for feedback

Re: SQL Query

sudheer_r — Fri, 05 Jun 2020 07:21:41 GMT

It helped me...thank you