Page MenuHomePhabricator
Create Task
Maniphest T370947

Update SQL output for Phabricator WMF QLS report mails
Closed, ResolvedPublic
Actions

Description

Related to ticket: T362804

For the next quarterly report and moving forward, the SQL output should include the following fields:

  • PHID
  • Author
  • Status
  • Owner
  • Date Closed Date
  • Closer
  • Priority
  • Subtype
  • URL
  • Title
  • Created Date
  • Days between Created and Closed
  • Tags (see below for more information)
  • Subscribers (names of folks subscribed to the task)

Example of information captured in Tags:

  • MW-1.42-notes (1.42.0-wmf.25; 2024-04-02)
  • MediaWiki-Platform-Team
  • MediaWiki-libs-BagOStuff
  • Regression
  • Chinese-Sites
  • Patch-For-Review
  • VPS-project-Codesearch

Details

Other Assignee
Dzahn
Related Changes in Gerrit:
SubjectRepoBranchLines +/-
Include tags and subscibers in quarterly Phabricator data for WMF QLSoperations/puppetproduction+96 -8
Customize query in gerrit

Related Objects

Event Timeline

ARamirez_WMF created this task.Jul 24 2024, 6:46 PM
Dzahn renamed this task from Update SQL output to Update SQL output for Phabricator WMF QLS report mails.Jul 24 2024, 6:50 PM
Dzahn added projects: Phabricator, collaboration-services.
Dzahn updated the task description. (Show Details)
Aklapper added a comment.Jul 25 2024, 4:47 PM

All items listed above except for the last two entries are 1:1 relations, thus easy.

The last two items (Tags, Subscribers) are 1:many relations, thus SQL query output does not allow rendering, say, 10 subscriber names in the "same" query output field/row. I'd put them into a separate query each, as I do not have a better idea how to provide/render such info in a meaningful way.

Aklapper claimed this task.Jul 25 2024, 4:48 PM
Aklapper triaged this task as Medium priority.
gerritbot added a comment.Jul 25 2024, 5:26 PM

Change #1056992 had a related patch set uploaded (by Aklapper; author: Aklapper):

[operations/puppet@production] Include tags and subscibers in quarterly Phabricator data for WMF QLS

https://gerrit.wikimedia.org/r/1056992

gerritbot added a project: Patch-For-Review.Jul 25 2024, 5:26 PM
LSobanski moved this task from Incoming to Work in Progress on the collaboration-services board.Jul 29 2024, 3:32 PM
LSobanski updated Other Assignee, added: Dzahn.
gerritbot added a comment.Jul 30 2024, 8:03 PM

Change #1056992 merged by Dzahn:

[operations/puppet@production] Include tags and subscibers in quarterly Phabricator data for WMF QLS

https://gerrit.wikimedia.org/r/1056992

Maintenance_bot removed a project: Patch-For-Review.Jul 30 2024, 8:30 PM
Dzahn subscribed.Jul 30 2024, 8:56 PM

@Aklapper You should have a test mail now.

Aklapper closed this task as Resolved.Jul 30 2024, 10:07 PM
Aklapper edited projects, added Release-Engineering-Team (Priority Backlog 📥); removed Release-Engineering-Team.

Thanks a lot, email looks as expected!

I wish good luck to the folks who have to go through all that data and manually identify and remove false positives.

Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits