How can I swap the elements of a QuerySet?

Question

Django

I need to swap the elements of the QuerySet so that the elements in it alternate at the output: first, the element where the price is less than a certain one, then it is more than a certain one, after it it is less, more, etc.
Thank you in advance!

Answer 1

The most obvious thing is to turn the QuerySet into a list and rearrange it as you like, or collect a new list ...
Or write a raw SQL query using the mechanisms built into your SQL (two queries - goods at a price higher than the specified one, goods less than the specified
price ... add some tricky-key-item-number to each query, combine these queries and sort the result by key)... less than specified). And from these two QuerySets, collect a sheet, taking records from each QuerySet in turn

Answer 2

I understand that you need sorting.
https://docs.djangoproject.com/en/3.1/ref/models/q...
https://docs.djangoproject.com/en/3.1/ref/models/q...