Possible to order by certain words?

Viewed 44

I have a Project model with the attribute status.

status can be saved to one of the following values: Ongoing, Completed, Scheduled.

Is it possible to order records such that those with the status value of Scheduled comes first, Ongoing second and Completed last?

A second order clause will order the projects chronologically within each status segment.

3 Answers
Related