wp-admin/users.php does not show pages under "posts" column

[novasource]

For some reason, the SQL query in wp-includes/user.php that gets the count of a user's posts excludes pages, so /wp-admin/users.php will not show an accurate picture of a user's contributions. This makes no sense at all: 1. posts and pages are first-class content types in WordPress and 2. they are both stored in the same table.

Proposed solution: remove

AND post_type = 'post'

from function get_usernumposts in wp-includes/user.php.

This defect could result in incorrect interpretation of user activity, so marked as major severity.

[dd32]

Why should a Posts column include the page count too? - Afterall, Its a Posts column.

Should it include Attachments too? What about custom post types?

The other option, is to change it to list the contributions, Ie:
"Activity: 5 Posts, 1 Page, 50 Comments" inline with your other ticket: #10629

[novasource]

Why should a Posts column include the page count too? - Afterall, Its a Posts column.

Because a page and a post are both posts. They are both first-class content types in WordPress that are remarkably identical.

When I delete spam users, a heuristic is those with a strange email address, 0 posts, and 0 comments (they are spammed or deleted). But suppose a user has 3 pages but 0 posts? Right now his post count would be 0. Is that a spam user?

Should it include Attachments too?

Not sure that provides much value. Attachments are a piece of a page/post.

What about custom post types?

Not familiar enough with the custom post type ecosystem to comment.

The other option, is to change it to list the contributions, Ie: "Activity: 5 Posts, 1 Page, 50 Comments" inline with your other ticket: #10629

That consolidates all three counts in one field and makes it more difficult to scan large lists. In that other ticket, I also proposed a way to make a sparse matrix more usable--use a blank instead of a 0. This would defeat that significant usability improvement.

[westi]

Closing as invalid.

The posts column on the users list is just that the number of posts a user has written and this works as designed.

[fouldsy99]

how can you make posts column sortable?

[fouldsy99]

how can you make posts column sortable?

[chriscct7]

Replying to fouldsy99:

how can you make posts column sortable?

This is not a support forum, it's a development tracker. If you need help, please see ​https://wordpress.org/support/

[SergeyBiryukov]

Replying to fouldsy99:

how can you make posts column sortable?

See #15861.

[AnthonyHall]

Please reopen this ticket
Saying it is working as designed is not helpful. The question is what is needed? Why is it useful to show posts but not pages?
For example, when I'm about to delete a user it asks me who I want to allocate their content to. If this content includes pages,I need to know which ones. This seems very difficult to find out at the moment.
Saying "The posts column on the users list is just that the number of posts a user has written " is also unhelpful: as the novasource said, pages are posts. The fact that posts can mean posts or "posts except pages" is a fault in WordPress, not a fault in the ticket.

[AnthonyHall]

Please reconsider this ticket