Report to show due date Issue links

Question

We have two projects, Problem Management and RCA, that we create "relates to" issue links that are staff action items resulting from a Problem or RCA ticket.  I want to create a report that shows for example RCA-1 and then a listing of all the "relates to tickets" in that RCA with their due dates.  The created relate to tickets reside only in 1 of the following projects: SE, DE, SYS or Plan,

My initial stab at the query returned 0 results

project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") and resolution is EMPTY and issueFunction in hasLinkType("RCA Remediation")

same for this one

project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") and resolution is EMPTY and (issueFunction in hasLinkType("RCA Remediation") or issueFunction in hasLinkType(RCA))

Any assistance would be appreciated.

David Abowitt · Answer

Is there a way to code what I show below as it seems going backwards and asking if in the other projects are tickets related to the RCA Project tickets?

If ticket is in "Root Cause Analysis" and has issue links and resolution is empty

Additional code if possible to create short-term and long term reports

If due date is less than 5 days from report pull
If due date is greater than 5 days from report pull

David Abowitt · Answer

project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") and resolution is EMPTY and (issueFunction in hasLinkType("RCA Remediation") or issueFunction in hasLinkType("relates"))

Unfortunately, that is returning to many of non relevant records including records such as SysAdmins tickets that are not related to RCA's.

If I use query: project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") and resolution is EMPTY and issueFunction in hasLinkType("RCA Remediation") I get 0 results.

If I use query: project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") and resolution is EMPTY and issueFunction in hasLinkType(Relates) it returns to many non-applicable records.  i.e. not 'Relates" to RCA tickets.

I do have a short-term fix until I get the code figured out. Since currently I'm the only one creating issuelinks from the RCA project this worked.  
project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") AND reporter = David.Abowitt AND resolution is EMPTY AND duedate > endOfDay() ORDER BY due ASC

I use due date to create short-term and long-term action item reports.

Brittany Wispell · Answer

Hey @David Abowitt

Have you tried doing issueFunction hasLinkType("Relates To")) or ("relates"))   ?

project in (SysAdmins, "Systems Engineering", "Delivery Engineering", Planning, "Technology Operations") and resolution is EMPTY and (issueFunction in hasLinkType("RCA Remediation") or issueFunction in hasLinkType("relates"))

I bolded where I changed it.

Hope this helps.