Expose basic details for users with published posts #839

Activity

1. danielbachhuber

   added

   Bug

   Blocked on Core

   on Feb 5, 2015
2. danielbachhuber

   added this to the 2.0 milestone on Feb 5, 2015
3. TimothyBJacobs commented on Feb 5, 2015

   

   TimothyBJacobs

   on Feb 5, 2015

   Member

   More actions

   I think something like this could work, basic and untested.

   $types = get_post_types( array( 'public' => true ) );
   $types = implode( $types, ', ' );

   and the sql.

   SELECT `post_author` FROM `wp_posts` WHERE `post_type` IN ( $types );
4. danielbachhuber commented on Feb 5, 2015

   

   danielbachhuber

   on Feb 5, 2015

   MemberAuthor

   More actions

   Another consideration: performance. Our queries should be behind some basic object cache so we don't make the same query over and over
5. rmccue commented on Feb 11, 2015

   

   rmccue

   on Feb 11, 2015

   Member

   More actions

   Core doesn't have a sane way to query this, me thinks :(

   Can we use get_users( [ 'who' => 'authors' ] ) ? Not sure if that's robust enough.
6. rmccue commented on Feb 11, 2015

   

   rmccue

   on Feb 11, 2015

   Member

   More actions

   Not sure if that's robust enough.

   Ah, checking the source reveals that it's any user with a user level > 0, so could be too much.

   However you can order by post_count, which should also give back the post_count column, so that might work.
7. danielbachhuber

   modified the milestones: 2.0 Beta 1, 2.0 on Mar 31, 2015
8. rachelbaker commented on Apr 15, 2015

   

   rachelbaker

   on Apr 15, 2015

   Member

   More actions

   Punting to Beta 2.
9. rachelbaker

   modified the milestones: 2.0 Beta 2, 2.0 Beta 1 on Apr 15, 2015
10. joehoyle commented on Apr 30, 2015

    

    joehoyle

    on Apr 30, 2015

    Member

    More actions

    Currently we allow /users/<id> for any author that has a published post of post_type = post. I'd recommend we use get_posts_by_author_sql to get those users and roll with that.
11. rmccue commented on May 3, 2015

    

    rmccue

    on May 3, 2015

    Member

    More actions

    Our issue is that we don't really want to do SQL queries in the API, since it doesn't belong there. What we need is a way for WP_User_Query to use get_posts_by_author_sql for the query rather than just allowing sorting by it. This also means that it works nicely with wp_is_large_network, any caching layers that may be in place with user query filters, etc.
12. joehoyle

    self-assigned this

    on May 13, 2015
13. joehoyle commented on May 16, 2015

    

    joehoyle

    on May 16, 2015

    Member

    More actions

    Trac ticket: https://core.trac.wordpress.org/ticket/32250#comment:8 looks to be making some progress.
14. rachelbaker commented on May 25, 2015

    

    rachelbaker

    on May 25, 2015

    Member

    More actions

    Trac Ticket is making progress, but punting to Beta 3 to see how this pans out.
15. rachelbaker

    modified the milestones: 2.0 Beta 3, 2.0 Beta 2 on May 25, 2015
16. johnbillion commented on Jun 2, 2015

    

    johnbillion

    on Jun 2, 2015

    Contributor

    More actions

    https://core.trac.wordpress.org/ticket/32250 is in.
17. joehoyle commented on Jun 15, 2015

    

    joehoyle

    on Jun 15, 2015

    Member

    More actions

    Will handle a PR for this by tomorrow, so leaving in b3 for now.
18. rachelbaker

    modified the milestones: 2.0 Beta 3, 2.0 Beta 4 on Jul 5, 2015
19. joehoyle

    removed

    Blocked on Core

    on Jul 12, 2015
20. rmccue

    closed this as completedon Aug 7, 2015