I have table with fields priority, completed_time,completed. Completed colume have values 0 and 1 and it is a primary sort. I want to make secondary sort to be priority if completed is 0 and completed_time if completed is 1. How can i get it?
I know only how to make unconditional sort by two parameters like:
String orderBy = "completed ASC, priority DESC"
Aucun commentaire:
Enregistrer un commentaire