How do I see final RICE Priority score via jql?

[Jack Arndt]

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.

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? 

[YY Brother]

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:

[Jan-Hendrik Spieth]

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?

[Tanguy Crusson]

@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

[YY Brother]

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.