Sort posts by custom fields and post title

• MarvinLeRouge

• June 29, 2015 at 11:55 pm

Hi,

I’m looking for a proper way to get posts sorted by custom field “region” ASC, then by custom field city ASC, then by post_title ASC, then by post id. Yes, that would mean two meta fields and two non meta fields.

Any help strongly appreciated.

• James

• June 30, 2015 at 6:03 am

Hi @marvinlerouge

Have you tried using the post_orderby filter. Hook a function to this filter to modify the SQL used to query the posts.

Have a look at this simple solution provided here: https://wordpress.org/support/topic/how-to-sorting-order-by-multiple-custom-fields which uses this filter

Also, here is the link to the documentation of this filter: https://codex.wordpress.org/Plugin_API/Filter_Reference/posts_orderby for more information.