SleekView for Groups
Groups writes memberships and capability bundles into wp_groups_group, wp_groups_user_group, and wp_groups_capability. SleekView joins all three into one sortable, filterable workspace.
♾️ Lifetime License available
Groups stores rules in three tables, SleekView joins them into one view
The Groups plugin writes its data into dedicated tables: wp_groups_group for group definitions, wp_groups_user_group for memberships, and wp_groups_capability for capability bundles tied to each group. The plugin admin lists each table on its own screen, which keeps things tidy and hides the cross-table picture an audit usually needs.
SleekView reads all three tables and joins them on group_id and user_id. Each row is a user-group-capability triple, ready to sort by group, filter by capability, or search by user.
Groups keeps owning the memberships and restrictions. SleekView only adds the joined-view surface, so saved views like Users with the Premium group or Groups holding manage_options become one click instead of a SQL join.
Workflow
From the Groups tables to a joined audit table in four steps
Connect the Groups dataset
Pick the audit columns
Save the access view
Pivot to Kanban or Chart
Sample columns
A typical Groups membership audit view
wp_groups_group, wp_groups_user_group, and wp_groups_capability joined into one dataset
| User | Group | Capabilities | Joined | Status | Source |
|---|---|---|---|---|---|
| alex@acme.com | Premium | access_premium, download_files | 12d ago | Active | Manual |
| jamie@acme.com | Editors | edit_pages, publish_pages | 30d ago | Active | Manual |
| sam@acme.com | Premium, Beta | access_premium, beta_features | 45d ago | Active | WooCommerce |
| pat@acme.com | Registered | read | 120d ago | Idle | Auto |
| intern@acme.com | — | — | — | No group | — |
Comparison
Default Groups admin vs SleekView
Default Groups per-table screens
- Groups lists groups, users, and capabilities on separate screens
- Membership counts per group require manual tallying
- Capability bundles are visible per group, not cross-group
- Cross-table audits depend on a separate reporting plugin or SQL
- Exports are per-screen rather than per saved query
SleekView
- Memberships and capabilities joined into one table
- Filter by group, capability, user, or source
- Saved views per quarterly review reopen with one click
- Same dataset feeds Table, Kanban, Feedback, and Charts views
- CSV export honours active filters and column order
Features
What SleekView gives you for Groups
Memberships at a glance
Group by group_name to count users per group, the question every Groups admin asks at least once a week.
Capability bundle audit
Filter on a capability and see exactly which groups and users hold it, even when the bundles grew quietly over time.
One dataset, every view
Table, Kanban, Feedback, and Charts share one source. Switch views without rebuilding the query.
Audience
Who uses SleekView for Groups
Security leads on gated content
Capability and membership filters answer who can see which restricted content without opening a database client.
Course and association sites
Members-per-group views feed the monthly board update on cohort and tier sizes.
Agency maintainers
One saved view per client surfaces the Groups configuration during quarterly access reviews.
The bigger picture
Cross-table visibility without SQL
Groups is excellent at structuring memberships and capability bundles, but its admin shows one slice at a time. The natural audit question, how many people in which groups hold which capabilities, requires a database client or a spreadsheet pivot. SleekView reads the same Groups tables and joins them into one sortable, filterable workspace.
The plugin keeps owning the memberships, SleekView just answers the cross-table questions in WP Admin. Saved views travel with the site, filtered rows export as CSV when compliance asks for evidence, and assignment drift becomes visible before it turns into a privilege-creep incident.
Questions
Common questions about SleekView for Groups
No. It reads the Groups tables only. Edits still happen through the Groups admin.
Yes. Any capability stored in wp_groups_capability surfaces as a column, regardless of which plugin registered the capability.
Yes. Group is a filterable column, so the view can isolate one group or compare several at once.
No. It renders only in the admin and reads from existing Groups tables. The front-end restrictions run unchanged.
Yes. The Groups for WooCommerce add-on writes to the same core tables, so the same joined dataset applies.
No. Groups owns the memberships and restrictions. SleekView only adds the joined audit table.
Yes. Standard WordPress capability checks apply, only users who can read Groups data see the table.
Yes. CSV export honours active filters and column order, useful for access-review reports.
Pricing
More than 1000+
happy customers
Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.
Lifetime ♾️
Most popular
EUR
once
- Unlimited websites
- Lifetime updates
- Lifetime support
...or get the Bundle Deal
and save €250 🎁
The Bundle (unlimited sites)
Pay once, own it forever
Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.
What’s included
-
SleekAI
-
SleekByte
-
SleekMotion
-
SleekPixel
-
SleekRank
-
SleekView
€749
Continue to checkout