I apologize the delay here
This is because the aliases are most probably not correct in your Site/Code.
The line:
return $wpdb->postmeta.'.meta_value ASC, mt1.meta_value ASC, mt2.meta_value ASC, post_title ASC';
Does set the order-by and sequence of it, but it uses Aliases for your Custom Fields (The WP_Query does that actually, it is not Toolset)
So to have the correct Aliases, you need to var_dump the value of those, so just above place an var_dump($wp_query):
var_dump($wp_query);
return $wp_query;
Then you will see the alias of the fields.
Please if you need help with this, provide me temporary access (WP-Admin and FTP) to your site
- preferably to a test site where the problem has been replicated if possible -
in order to be of better help and check if some configurations might need to be changed
Your next answer will be private which means only you and I have access to it.
❌ Please backup your database and website ❌
✙ I would, if possible, need access to a site where only a minimal set of Plugins and a default theme is active.
This to avoid eventual compatibility issues with other software.
✙ Please add the Links to:
- The Views Edit Screen
- The Page/Post where you insert the View
- The corresponding Front End Page/Screen
Please let me know if you have further questions regarding the issue mentioned in this Thread
Thank you for your patience.