Moreso a psuedo-code question than actual code. I have some custom post meta attached to attachments, and created a list table column for this meta. The meta is either 1, or null (not set), but I am trying to enable sorting for said column.
Is there a way to utilize
meta_query for WP_Query to essentially LEFT JOIN, where I get all values (1 or null), and then I can utilize
orderby=meta_value_num for ordering?
The obvious way it would work is hooking into posts_clauses, adding a JOIN, and doing the orderby as well - just curious if this would be possible while using direct WP_Query functionality!