Sortable by two columns with differents direction

[SarahCordeau]

Q	A
Bundle version	6.6.1
Symfony version	7.2.3
PHP version	8.3.15

Support Question

Hi,

I need to sort one column with null values end.

I should see that we can sort by many fields but not with differents direction.

Here an example of what I need:

{{ knp_pagination_sortable(items, 'Date', ['updatedAtNullValues', 'updatedAt'], {}, {direction: 'desc+asc'} }}

Can you propose me one solution?

Thanks a lot

[garak]

In theory, it should be possible.
It would require a change in https://github.com/KnpLabs/knp-components/blob/master/src/Knp/Component/Pager/Event/Subscriber/Sortable/Doctrine/ORM/QuerySubscriber.php and in https://github.com/KnpLabs/knp-components/blob/master/src/Knp/Component/Pager/Event/Subscriber/Sortable/Doctrine/ORM/Query/OrderByWalker.php

It doesn't seem an easy task to me, but if you want to try it, feel free.