Notes
Notes - notes.io |
FROM redmine.issues t1
INNER JOIN redmine.issue_relations t2 ON t1.id = t2.issue_from_id AND t1.tracker_id = 1
INNER JOIN
(SELECT t1.id, t1.subject As TaskName, t2.EpicCode, t2.id AS FeatureID, t2.FeatureName
FROM redmine.issues t1
INNER JOIN (
SELECT t21.id, t22.value As EpicCode, t21.subject As FeatureName
FROM redmine.issues t21
INNER JOIN redmine.custom_values t22 ON t21.id = t22.customized_id AND t22.custom_field_id = 53
WHERE t21.tracker_id IN (3, 4, 6) AND t22.value = '100888'
) t2 ON t1.root_id = t2.id
WHERE t1.subject LIKE 'QC%' AND t1.tracker_id = 5
) t3 ON t2.issue_to_id = t3.id
INNER JOIN redmine.users t4 ON t1.assigned_to_id = t4.id
LEFT JOIN redmine.issue_statuses t5 ON t1.status_id = t5.id
UNION
SELECT t3.FeatureId, t3.FeatureName, t3.id As IssueId, t3.TaskName As IssueName, t1.id, t1.subject, t1.start_date, t1.due_date, t4.login As Assignee, t5.name As Status
FROM redmine.issues t1
INNER JOIN redmine.issue_relations t2 ON t1.id = t2.issue_to_id AND t1.tracker_id = 1
INNER JOIN
(SELECT t1.id, t1.subject As TaskName, t2.EpicCode, t2.id As FeatureId, t2.FeatureName
FROM redmine.issues t1
INNER JOIN (
SELECT t21.id, t22.value As EpicCode, t21.subject As FeatureName
FROM redmine.issues t21
INNER JOIN redmine.custom_values t22 ON t21.id = t22.customized_id AND t22.custom_field_id = 53
WHERE t21.tracker_id IN (3, 4, 6) AND t22.value = '100888'
) t2 ON t1.root_id = t2.id
WHERE t1.subject LIKE 'QC%'
) t3 ON t2.issue_from_id = t3.id
INNER JOIN redmine.users t4 ON t1.assigned_to_id = t4.id
LEFT JOIN redmine.issue_statuses t5 ON t1.status_id = t5.id
|
|
Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 12 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
