Support » Plugin: Manage User Columns » Which meta fields are available?

  • Resolved w-sky

    (@w-sky)


    Great plugin! Seems to be what I just need. However where would I find a list (maybe including descriptions) of all user meta fields that are available?

    I would like to add a column that shows how many comments (or how many WP posts of any type) an user has created.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Deepak Khokhar

    (@deepakkite)

    Hi @w-sky

    There is no direct way in WordPress where you can get the list of user meta fields with description. You can find them in the Database under the table usermeta.

    However, the plugin provides you an option to type and search for a metafield to select the correct metafield key.

    To find your expected metafield, please go to your site’s database using some tool like PhpMyAdmin and look into the usermeta table.

    Thread Starter w-sky

    (@w-sky)

    Thanks a lot. Yes I noticed that Manage User Columns has a very helpful search function, I just did not know what to search for because “user” and “post” or “posts” does not show meta fields that would be useful for me.

    However now when looking at the usermeta table, I see that there is no meta field which would show how many posts of any type an user has created.
    So probably, it would need a function to scan the database and count to deliver the number.

    The background is, I have many “dead” user accounts on my site, many who never posted a comment or forum post, some even have never logged in once, and I want to delete them all.

    Plugin Author Deepak Khokhar

    (@deepakkite)

    @w-sky Unfortunately this plugin can only get values from the usermeta table. However, you can do so with some custom work, take a look at this function – https://developer.wordpress.org/reference/functions/count_user_posts/ which if used in users loop can get you the count of posts created by each user.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Which meta fields are available?’ is closed to new replies.