✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView for Ultimate Member Private Messaging: message threads as tables

The Private Messaging extension stores conversations in dedicated tables alongside Ultimate Member's usermeta-driven profile schema. SleekView surfaces threads, messages, and per-user thread counts as proper columns for moderation and audit.

♾️ Lifetime License available

SleekView table view for Ultimate Member Private Messaging

Private messages as a moderation queue, not a stream

Ultimate Member's Private Messaging extension adds messaging on top of the core usermeta-driven profile system. Conversations land in dedicated tables (commonly um_pm_conversations and um_pm_messages in installs where the extension creates its own tables, or in the configured custom tables documented by the extension), with conversation_id, sender_id, recipient_id, message, and date_sent. The profile owners come from wp_users and wp_usermeta.

The default extension admin shows conversations as a list and one-message-at-a-time review. Cross-thread audits (every message from a flagged account in the past week, or every unread message older than 30 days for cleanup) require custom SQL. Filters that combine sender profile fields (role, account_status) with message recency aren't a built-in screen.

SleekView reads the messaging tables directly, joins wp_users + wp_usermeta for sender and recipient profile data, and exposes date_sent, read_status, and per-thread message counts as proper columns. Inline edits flag messages for review or mark them deleted with conflict detection so concurrent moderator actions don't overwrite each other.

Workflow

Read messages as a moderation table

1

Map the messaging tables

Point SleekView at the UM PM message and conversation tables (verify names on your install). Add joins to wp_users for sender and recipient email.
2

Pivot sender profile fields

Add Ultimate Member usermeta keys (account_status, registration fields) as filterable columns. Now sender state and message content live in the same row.
3

Save moderation queues

Build per-role saved views: a flagged-message queue, an unread-cleanup view, a per-user audit. Capability-gate each so moderators, support, and abuse teams see only what they need.
4

Act inline and audit

Bulk-flag, delete, or mark-read across many rows in one pass. Writes route through the extension API where available; direct DB writes handle bulk cleanup.

Sample columns

A typical private-message audit view

Flat list of messages with sender, recipient, thread, and flag state visible.
Source: wp_um_pm_conversations + wp_um_pm_messages + wp_usermeta
Thread Sender Recipient Preview Sent Status
#1284 alex@studio.co ria@design.io Quick question about the brief... Apr 24 Read
#1283 anonymous tom@hello.dev Free crypto giveaway, click here Apr 24 Flagged
#1280 mia@brew.coop ria@design.io Following up on yesterday's call Apr 23 Unread
#1277 tom@hello.dev alex@studio.co Got it, sending the file now Apr 22 Read

Comparison

Default UM Private Messaging admin vs SleekView

Default UM PM admin

  • Conversations are reviewed one thread at a time in the default UM extension UI
  • Cross-thread moderation queries against um_pm_messages need direct SQL
  • Per-user message counts and recipient distribution aren't surfaced as columns
  • Combining sender account_status with message recency isn't a built-in filter
  • Bulk-deleting or flagging messages across many threads is per-row work

SleekView

  • Flat message and thread tables across all conversations
  • Filter sender by Ultimate Member account_status + last-active
  • Bulk-flag suspicious messages without per-row clicks
  • Per-user message volume rollups (group by sender_id)
  • Save views per role (moderator, support, abuse team)

Features

What SleekView gives you for Ultimate Member Private Messaging

Cross-thread message table

Read um_pm_messages as a flat list with thread ID, sender, recipient, and date as columns. Sort by date_sent for fresh-first moderation or by sender_id for per-user audits.

Sender profile filters

Join wp_usermeta on sender_id to expose Ultimate Member fields like account_status and registration field values. Filter abusive messages by sender role or account state in one step.

Bulk moderation

Filter to flagged messages or unread items older than a chosen threshold and bulk-update status. Writes go through the extension's API where supported, with conflict detection on direct fallback.

Audience

Who uses SleekView for Ultimate Member Private Messaging

Moderators

Cross-thread message queues with sender role, account status, and date filters. Spot brigading from a newly registered cohort by combining account_status = approved within the past day with high message volume.

Support

Per-user message history visible inline during support, without opening each thread separately. Speeds up abuse complaints and lost-message investigations.

Community managers

Per-user message volume rollups to spot top communicators and dormant accounts. Combine with profile fields to design re-engagement campaigns scoped by role.

The bigger picture

Why private messaging needs a flat moderation table

Private messages are the part of a community where bad behaviour hides. Activity feeds and forum posts get moderated quickly because they're public; one-to-one and small-thread messaging are visible to almost no one until an abuse report arrives. By then the question is always the same, what else has this account sent in the past week, and the default UM Private Messaging admin can't answer it without opening each thread.

The data is there, because every message has a sender, a recipient, a thread, and a timestamp. The gap is composition. SleekView's pivot turns those columns into a flat table where the abuse-team question (every message from this account in the past 7 days) and the moderator question (every flagged message right now across the community) become one filter each.

Joining the sender's Ultimate Member profile fields onto the message row means newly registered cohorts, suspicious account-status combinations, and freshly approved accounts in the middle of a message spike are visible without leaving the table. For any community with private messaging turned on, that's the difference between catching abuse early and finding out about it weeks later.

Questions

Common questions about SleekView for Ultimate Member Private Messaging

Yes. The extension provisions tables for conversations and messages (commonly named um_pm_conversations and um_pm_messages) when it activates. SleekView reads them directly and joins to wp_users and wp_usermeta for profile data. Verify the exact table names on your install before pointing a view, since extension versions can rename or add tables.

 

Yes. SleekView writes back to the messaging tables with conflict detection, so concurrent moderator actions don't silently overwrite each other. Where the extension exposes a PHP API or hook for message changes, SleekView routes through it so any registered after-update handlers fire.

 

Yes. Sender profile fields live in wp_usermeta and SleekView pivots the keys you choose into columns on the message view. Filter by account_status, registration date, role, or any custom registration-form field. That's how moderators isolate messages from newly approved accounts within the past 24 hours.

 

Yes. The conversation table carries participant lists and unread counts (or those are derived from the message table). SleekView surfaces both as columns and offers a per-thread view that joins the most recent message inline for triage.

 

When SleekView routes through Ultimate Member or the extension's messaging API, hooks fire as expected. Direct DB writes skip hooks, which is the right choice for silent back-fills (purging spam from a known bad account) but the wrong choice when downstream notification logic should run.

 

Yes. Filter to the relevant sender or thread, save the view, and export as CSV or JSON. The export reflects whatever columns and filters are in the view, so abuse-team reports stay consistent across investigations.

 

um_pm_messages is typically indexed on conversation_id and sender_id, so filtered views stay fast. SleekView paginates server-side and loads visible columns only. Heavy aggregates (message-volume rollups) run on demand rather than precomputing on every load.

 

Yes. Each subsite has its own messaging tables (with the prefix per the network blog ID) and SleekView reads the current subsite only. Cross-site moderation views aren't supported in one screen, but per-site moderator workspaces work normally.

 

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.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

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