How do I see final RICE Priority score via jql?

Jack Arndt February 25, 2023

I'm using a RICE custom priority formula.  I want to give stakeholders a dashboard to see their ideas and relative priority score using JQL and jira dashboard gadgets. This gives them the information they need on their requests without them accidentally breaking anything in JPD.

 

image.png

 

I am able to get everything into the gadget via jql EXCEPT the final Rice Priority score.

Is there a trick to being able to do this? 

image.png

1 comment

Comment

Log in or Sign up to comment
YY哥
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 26, 2023

Hi Jack,

 

Do you mean you need to calculate the RICE priority score in JPD based on the existing elements you've had? You could just edit the expression of that field. Something like below:

image.png

Jan-Hendrik Spieth
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 26, 2023

This is a good one, @Jack Arndt :-)

I think some undocumented limitations apply to dynamic fields, such as custom formulas.

And so I've read here somewhere that JQL doesn't work for/with custom formula fields.

Quickly checked the REST API, and I believe I see no dynamic fields there, but pretty much every other JPD field.
https://your-domain.atlassian.net/rest/api/3/field

Maybe the team could confirm whether I'm on the right track here?

And if so, what are the plans to make dynamic fields work with JQL and API?

Like YY哥 likes this
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 27, 2023

@Jan-Hendrik Spieth @Jack Arndt these fields are not accessible via JQL and the API yet (so not "true fields" in the Jira sense) - the computation of formulas is actually done client-side for the moment. 

We are working on moving them to the Jira backend, but it's not there yet. 

This applies to: formula, votes, reactions, delivery progress/status

Like # people like this
YY哥
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 27, 2023

In my practice, I created a customized field of Number type and used an automation to calculate its value.

JQL and issue search can run as you expect, I think.

TAGS
AUG Leaders

Atlassian Community Events