User Query sort on custom field then name


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.

nickfindley 8 months 2020-11-23T11:10:33-05:00 0 Answers 8 views 0

Leave an answer