WordPress.org

Make WordPress Core

Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#40877 closed feature request (maybelater)

Count user tag

Reported by: seraj8 Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: Options, Meta APIs Keywords: reporter-feedback
Focuses: administration, performance Cc:

Description

Hello
In the database tables User ID to insert tags not registered.
Therefore, the number of tags can not be output for each user.

Thank you

Change History (4)

This ticket was mentioned in Slack in #accessibility by afercia. View the logs.


3 years ago

#2 @afercia
3 years ago

  • Focuses accessibility removed
  • Keywords reporter-feedback added

Not sure what's intended for "user tags", maybe something added by some plugin? Looks like something not related to accessibility though, removing the focus as per today's bug scrub.

#3 @johnbillion
3 years ago

  • Milestone Awaiting Review deleted
  • Resolution set to maybelater
  • Status changed from new to closed
  • Version trunk deleted

I think what's being asked here is for a field akin to the author field for terms so it's possible for users to own terms, thereby making them countable by user.

There's nothing on the roadmap for this and it's unlikely to be worked on at least in the short term. Closing as maybelater in case someone wants to pick it up.

#4 @seraj8
3 years ago

Hello
@afercia and @johnbillion Thank for your help...
I found solution for find number of tags by each user.
I use this query:

SELECT * FROM wp_term_taxonomy AS tt
JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id=tt.term_taxonomy_id
JOIN wp_posts AS p ON tr.object_id=p.ID
JOIN wp_terms AS t ON t.term_id=tt.term_id
WHERE
tt.taxonomy='post_tag' AND
p.post_author=AUTHOR_ID AND
p.post_status='publish' AND
p.post_type='post'
GROUP BY t.name

Thank you

Note: See TracTickets for help on using tickets.