Hello it turns out that I'm working on a project in symfony 3.3 and I have an Entity that has fields like
- title (string)
- auto (boolean)
- createdAt (datetime)
- ftope (datetime), this last is a deadline
and I would like to make a query in my repository that I returned the elements with an order similar to this
first those that have the auto field in true if the deadline is still valid and then the rest in descending order by the createdAt date
can all this be done in a single query or should that be done in the view with twig?