Add a sortable date user registered column to the Users

If you manage a site that has a lot of registrations, sometimes it is helpful to show the date the user registered as a custom column in the WordPress admin page Users > All Users. I have shown in another post how you can add that data as well as other data to this table.

But what if you want to make it sortable so you can sort the table by the date the user registered to see what users have registered most recently? Here is a way that you can do that.

This article is only available to WP-Members Support Subscribers. If you have an existing subscription, please login below. If you do not have a current support subscription, you can purchase a support subscription here.

To gain full access to WP-Members premium content, a current support subscription is required. You can purchase an annual support subscription for as little as $59, which provides you with access to priority support, a customer support forum, access to code snippets, and more.

Why wait? Choose your subscription option here .

[Why join?]

Tagged: admin, demo, filters, hooks, wp-filters

This topic has 5 replies, 2 voices, and was last updated 4 years, 3 months ago by whitenoise.

Viewing 3 reply threads

Author

Posts
- December 4, 2013 at 3:00 pm #3552
  
  Chad Butler
  Keymaster
  
  If you manage a site that has a lot of registrations, sometimes it is helpful to show the date the user registered as a custom column in the WordPress
  [See the full post at: Add a sortable date user registered column to the Users > All Users page]
- November 10, 2016 at 10:07 am #11668
  
  whitenoise
  Participant
  
  I’ve applied this to the expires column instead, by replacing ‘user_registered’ with ‘expires’. Seems to work ok, I’m assuming this won’t cause any problems?
  - November 10, 2016 at 11:15 am #11676
    
    Chad Butler
    Keymaster
    
    While that will probably work for adding the expiration date column (I do the same in the admin for this site), that column won’t be sortable.
    
    In order to sort the table by a date, the date must be stored as a date. Unfortunately, this particular value isn’t stored as a date. This value is a custom field, and all WP custom user fields are plain text. So this value can only be sorted as text (which won’t result in a true sort).
    
    The WP users screen is OK for certain tasks, but it does have some limitations. The best solution, if you need to handle more complex user management processes, is to export your users and handle them in something like a CRM solution (such as Salesforce) or a spreadsheet.
- November 10, 2016 at 11:55 am #11681
  
  whitenoise
  Participant
  
  Ok thanks for the information Chad. A CRM would be way overkill for my uses, but thanks for your suggestion and continued assistance!
  - November 10, 2016 at 4:52 pm #11692
    
    Chad Butler
    Keymaster
    
    A CRM would be way overkill for my uses,
    
    Same here. I generally just use a spreadsheet for my purposes.
- November 11, 2016 at 5:00 am #11699
  
  whitenoise
  Participant
  
  I came to that conclusion as well. Some things you can do online and automate, others its just a lot easier to do with a good old spreadsheet 🙂
Author

Posts

Viewing 3 reply threads

You must be logged in to reply to this topic.