Filter the JOIN clauses added to the Members List query for sorting. It runs only on the data query, not the count query. Use it with pmpro_memberslist_sortable_columns and pmpro_memberslist_allowed_orderbys to make a custom column sortable. Added in PMPro 3.9.
apply_filters( 'pmpro_memberslist_sql_join', string $join_sql, string $orderby );
Use the plain joined column as the ORDER BY expression, not an aggregate such as MIN(), because most views do not group rows.
Parameters
- $join_sql
- string; The SQL JOIN clauses to add to the query.
- $orderby
- string; The sanitized
ORDER BYexpression for the current request.
Source
View in Source CodeAbout Actions and Filters in PMPro
Hooks allow you to extend Paid Memberships Pro without editing any core plugin files. You can use a hook to program custom code that interacts with or modifies code in our plugin, Add Ons, your theme, and even WordPress itself.
There are two kinds of hooks: actions and filters.
- Action hooks allow you to run new custom code at pre-defined locations.
- Filter hooks allow you to change or extend existing code by modifying the data and returning it back to the software.
Click here to browse the full database of action and filter hooks available in Paid Memberships Pro. For help extending our Add Ons, refer to the individual Add On's documentation page for a list of available hooks.
For more developer-focused information about Paid Memberships Pro, check out the advanced developer topics documentation.

