pierrejeambrun commented on issue #46383:
URL: https://github.com/apache/airflow/issues/46383#issuecomment-2631346480

   Nice. For now the `dag_id` (name) is always used as the secondary filter to 
ensure stability in the result set returned. (I case the primary filter has 
identical values).
   
   When we use a descending sort, the secondary filter (which is the primary 
key of the table, here the `dag_id` is also `.desc()`)
   
   ```python
           if self.value[0] == "-":
               return select.order_by(nullscheck, column.desc(), 
primary_key_column.desc())
           else:
               return select.order_by(nullscheck, column.asc(), 
primary_key_column.asc())
   ```
   
   I think we need to support multisort to support this case. So users would be 
able to specify that they want to sort on the primary criteria in asc(), but on 
the secondary criteria in desc() order for intance. (Or any other arbitrary 
combination).


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to