Changes between Initial Version and Version 1 of Ticket #5596, comment 1
- Timestamp:
- 02/02/2021 03:33:52 AM (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #5596, comment 1
initial v1 1 1 That report is designed to pull directly from the `attachmets` trac table, and there's no DB table with a list of the PRs. 2 2 3 I guess we could do something like `WHERE ticket_id IN ( tickets with attachments by $USER UNION tickets with comments by prbot containing data-wporg-user="$USER")` which wouldn't be the best performance wise.. but.. might be okay 3 I guess we could do something like `WHERE ticket_id IN ( tickets with attachments by $USER UNION tickets with comments by prbot containing data-wporg-user="$USER")` which wouldn't be the best performance wise.. but.. might be okay. 4 (edit: Note that the PR prbot comments don't seem to include the wporg username of the PR submitter right now :( I thought it was supposed to.. ) 4 5 5 6 The other lazier option, would be to simply link off to api endpoint which redirects back to something [https://core.trac.wordpress.org/query?id=47894&or&id=47895 like this] for the GitHub PR'd tickets.