Need JQL query for Below conditions

[Maktumhusain Taseeladar]

1. Epics that don’t currently have dates, need to get Solution verification Target start  & Solution verification Target END date  according to the BP they are linked to.  If an epic is connected to multiple BP, it should receive the earliest date

       (BP parents- Link type extend by )

 2. Interfaces and BPT that don’t currently have dates, need to get Solution verification Target start  & Solution verification Target END date according to the epic they are linked to (important to complete step 4 first).  If an interface/bpt is connected to multiple epics, it should receive the earliest date. ( Extends/ Extended by )

[Iryna Komarnitska_SaaSJet_]

Hi @Maktumhusain Taseeladar , 

If you are having difficulties learning JQL syntax, I can recommend a gadget that my team has released - Text to JQL.

The add-on converts plain language into a relevant JQL query.

Here you can view several examples of using the app - link to examples.

The gadget is free!

[Maktumhusain Taseeladar]

Thank you , i will try this.

[Maktumhusain Taseeladar]

A

[Nic Brough -Adaptavist-]

JQL can't do that, all it can do is search for issues, based on the data on the issues.

So you can do "Issuetype = Epic and start-date is empty", but you can't extract the data from other issues that are linked to it with JQL.

You will need to find or write a report that can follow the links and read data from issues not the one found.

[Maktumhusain Taseeladar]

Basically i need to do filter and save, the output should be displayed on Dashboard by selecting saved filters

[Nic Brough -Adaptavist-]

I assumed it would be for a report of some sort. 

As I said, you'll need to find or write something that can follow the links and report on the issues found at the other end.