Custom sorting query in KnpPaginatorBundle

Question

I would like to sort items in KnpPaginatorBundle by a custom callback. Is it possible to hook to the Walker somehow?

I mean I want to sort by invoice number which should be something like:

3/5/2020
2/5/2020
1/5/2020 
3/4/2020
2/4/2020

instead of

3/5/2020
3/4/2020
2/5/2020
2/4/2020
1/5/2020 

Answer 1

Don't go this way. Try to make filter before paginate and done result use in pagination