I would like to: * Add a formula which show tickets which have a specific issue link type of 'Cross Pod Dependency.' I wish to show both outward and inward (source & destination) dependencies. * Then I with to colour the background of this cell. So far I have this formula but I do not know how to colour the background of the cell? issuelinks .FILTER($.type = 'Cross Pod Dependency' AND $.source = this)Thanks

@David Niro is there a way to extend this so that it can highlight if a Due Date or Fix Version Date on the dependent item is after the primary items due date of fix version date?

Hello @Becky Brignall , Do any of the issues return more than one result? If they only return one result, modifying the formula in the following way should help: with issuelinks_filter = issuelinks .FILTER( $.type = 'Cross Pod Dependency' AND $.source = this ): IF issuelinks_filter: concat( "{panel:borderStyle=solid|borderColor=white|bgColor=#ADFF2F}", issuelinks_filter.source,issuelinks_filter.source.summary, "→", issuelinks_filter.destination,issuelinks_filter.destination.summary, "{panel}" ) If there can be more than one result, you will find that all of the Numbers will be listed together and then all of the Summaries will be listed together. Please let me know if this helps. Best Regards, David

Hello @David Niro At the moment its displaying Arrow is is possible to also show the ticket summary e.g. Arrow . We have hundreds of dependencies so only showing the ticket number / key is not great for us as we need to click on every single one to see what the ticket is. Thank you.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Structure Dependency Formulas & Background Formatting

Becky Brignall

I would like to:

Add a formula which show tickets which have a specific issue link type of 'Cross Pod Dependency.' I wish to show both outward and inward (source & destination) dependencies.
Then I with to colour the background of this cell.

So far I have this formula but I do not know how to colour the background of the cell?

issuelinks .FILTER($.type = 'Cross Pod Dependency' AND $.source = this)

Thanks

Jira Support Colour Formatting.png

Accepted answers

All comments

Becky Brignall

@David Niro is this something you may be able to help me with? Many Thanks, Becky - Expedia

David Niro

Hi @Becky Brignall !

I can help with this

We will want to use the background color (panel) functionality of Wiki Markup. In the formula below, I've taken your original formula and saved it as a local variable (issuelinks_filter) using WITH. The second part of the formula adds the background color to the results of the first.

WITH issuelinks_filter = issuelinks
.FILTER($.type = 'Cross Pod Dependency' AND $.source = this):

CONCAT("{panel:bgColor=#ADFF2F}",issuelinks_filter,"{panel}")

You can adjust the bgColor by changing the Hex# (#ADFF2F). I like to use this page , to pick the color I want and then just copy and paste the Hex value.

Let me know if this helps!

Best,
David

Becky Brignall

Thank you. I notice a grey line on the left and right of the panel, any idea why or how to remove? thanks again.

Becky Brignall

Grey left and right border.PNG

David Niro

Hi @Becky Brignall ,

You're very welcome! You can change the color of the border to white. It will still be there, but you won't see it, since it blends. in with the background. It will look like this:

with issuelinks_filter = issuelinks 
.FILTER($.type = 'Cross Pod Dependency' AND $.source = this): 
concat("{panel:borderStyle=solid|borderColor=white|bgColor=#ADFF2F}",issuelinks_filter,"{panel}")

Let me know if it helps!

Best,
David

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

structure

addon-com.almworks.jira.structure