Skip to content

Instantly share code, notes, and snippets.

@kimcoleman
Created November 30, 2018 20:16
Show Gist options
  • Save kimcoleman/cd3a30cc1f7e5be5bcfa3c45642ab6a7 to your computer and use it in GitHub Desktop.
Save kimcoleman/cd3a30cc1f7e5be5bcfa3c45642ab6a7 to your computer and use it in GitHub Desktop.
Sort the Member Directory by "companyname".
<?php
/*
* Sort the Member Directory by "companyname".
* Update the shortcode to include [pmpro_member_directory order_by="umc.meta_value"]
*
*/
function my_pmpro_member_directory_sql( $sqlQuery ) {
global $wpdb;
$sqlQuery = str_replace("WHERE mu.status", "LEFT JOIN $wpdb->usermeta umc ON umc.user_id = u.ID AND umc.meta_key = 'companyname' WHERE mu.status", $sqlQuery);
return $sqlQuery;
}
add_filter('pmpro_member_directory_sql', 'my_pmpro_member_directory_sql');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment