Display imitative and epics on board

[Sofya]

Hello

i would like to display epics on board in case of initiative ( that epics are linked to ) is in specific state. Otherwise only epic will be displayed.

thanks in advance 

Sofya

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Sofya and welcome to the community!

First of all, you have to create your JQL that will get the results you want. If such JQL exists, then you only have to create a board using this specific JQL and you are done. So, your first step would be to have a jql where

issuetype = Epic

About the second step (epics are linked to), I would like a bit more info to help you. Are you referring to issue linking, such as blocked by, splits from etc? If yes, what exactly you need?

[Sofya]

Thanks for response Alex!
we are use issue “Initiative”.  epics are  connected to initiative by  link “initiative-epic” . On the board we displayed the both issue types… but in case the initiative is in state “preparation” we would like to not display its linked epics - only the initiative itself .

is it more clear? If not I’ll try better…

[Alex Koxaras _Relational_]

Hi @Sofya,

Thank you for clarifying this. I get what you want to do, but you can't do that with out of the box Jira functionalities. JQL yields results based on certain statements and doesn't support an IF statement. With that said, my suggestion would be to try and find some app on the marketplace which could possibly get your JQL result. Indicative apps would be (server based):

• https://marketplace.atlassian.com/apps/1213501/sql-jql-driver-transform-jql-into-sql?hosting=server&tab=overview
• https://marketplace.atlassian.com/apps/31399/jql-tricks-plugin?hosting=server&tab=overview
• https://marketplace.atlassian.com/apps/1218367/jql-booster-pack?hosting=server&tab=overview
• https://marketplace.atlassian.com/apps/1216891/power-jql-extended-search-functions?hosting=server&tab=overview
• https://marketplace.atlassian.com/apps/1214791/jql-search-extensions-for-jira-the-jql-extensions?hosting=server&tab=overview

You can try them out before deciding to buy them.

[Sofya]

Thank you Alex!

I think it’s possible to do it via jql

it should be some like this:

(issuetype in (Initiative)  AND  status = Preparation  AND issueFunction in hasLinkType(Initiative-Epic) )

or  

(issuetype in (Epic, Initiative)  AND  status Not in (Preparation   )  )

I just don’t how to filter an epics that its linked Initiative is in preparation status…

what do you think?

[Alex Koxaras _Relational_]

issueFunction is part of the Scriptrunner app. As mentioned, out of the box you can't do that :)

Perhaps adaptavist's site can help you https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html.

I'll just mention @Nic Brough -Adaptavist- who might be able to help you better :)

[Sofya]

thank you very much @Alex Koxaras _Relational_ !

I finally succeeded to write the filter - that remove all Epics that its Initiative in state "Preparation":

issuetype in (Initiative, Story) or ( (issuetype in (Epic) AND issueFunction in linkedIssuesOf("status != Preparation" ) ) 

But another problem - it takes too much time...

Any suggestions @Alex Koxaras _Relational_  @Nic Brough _Adaptavist_?  

thanks a lot again!

Sofa

[Sofya]

hello  again

finally the filter is improved - 

issueFunction not in linkedIssuesOf("Project=kuki AND Type=Initiative AND status != Preparation")

and it works fast - because we added more filtering for the linkedIssuesOf()

thanks!

Sofa