I am trying to sort a list of attorneys (set up as Users) classified as founding members, members, and associates. Those classifications are stored in the attorney_title meta field.
I need them to sort by title (in this specific order, not alphabetically), then sort the attorneys alphabetically:
- Founding Members
- Anthony
- Bob
- Carla
- Members
- Andy
- Barbara
- Charles
- Associates
- Anna
- Brent
- Cody
Currently I'm doing a query for founders, then a query for members, then a query for associates. But I figure there might be a sensible way to do it in one query. If the attorney titles were alphabetical then I could probably get it, but since they must be sorted in a specific order, I'm not getting it.