Personal tools
You are here: Home Leocornus Leocornus Buildout Config Repository. Solr for BuddyPress

Solr for BuddyPress

— filed under: ,

buddypress database schema.

Database Schemas

following tables:

  • wp_bp_xprofile_xxx (fields, data, groups, updates)
  • wp_bp_activity (meta, sitewide, user_activity)

Query Scratch Pad

We need 2 steps to find a user's profile:

-- Find all users from table wp_users
display_name as name,
user_login as login,
CONCAT('User Profile') as keyword
FROM wp_users WHERE deleted = 0

-- group concat the xprofile data as the content
GROUP_CONCAT(value SEPARATOR ' ') as profile
FROM wp_bp_xprofile_data
WHERE user_id = ${}

-- decide the last modified date.
FROM wp_bp_xprofile_data
WHERE user_id = ${}
ORDER BY last_updated DESC

User Profile

User profile on top of WordPress user

Document Actions