Skip to:

Forum Replies Created

Viewing 1 replies (of 1 total)

  • leftblanx


    Anybody have any idea about these questions?

    With regard to the point in the final paragraph – when you sort the members list alphabetically, and then use the search facility, the SQL query looks like:

    SELECT COUNT(DISTINCT u.ID) FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID LEFT JOIN wp_bp_xprofile_data pd ON u.ID = pd.user_id WHERE u.user_status = 0 AND (pd.field_id = 1) AND pd.value LIKE ‘%%searchterm%%’ ORDER BY pd.value ASC;

    It assumes pd.field_id = 1, which is the Name field – why does it assume you only care about searching on the Name field when ordering alphabetically? And how would I best modify this to search on a) the text values of all my text profile fields, and b) the labels on multiple option profile fields?

Viewing 1 replies (of 1 total)
Skip to toolbar