Filtering on Custom Formula field

[Ben Krichko]

Within Jira Product Discovery , we have created a custom formula field named: Project Management Capacity. The idea is to use weighted expressions to automatically calculate the "weight" of a project. See screenshot below. 

The Field looks like the following under the Overview view

Question at hand....How can I create a filter on the value shown to the right of the Project Management Capacity?

[Bill Sheboy]

Hi @Ben Krichko 

Are you asking how to write a JQL for the project, comparing the "Project Management Capacity" to 10?

Or, are you asking about creating a view in JPD which filters based on that same field and value?

Kind regards,
Bill

[Ben Krichko]

@Bill Sheboy I'm asking how to write a JQL that calculates the score in the Project Management Capacity field

[Bill Sheboy]

That does not appear to be possible.

JPD custom fields like that are dynamically calculated, apparently when they are drawn in a view.  And so they have no value available for JQL because the value is never saved.

There is a separate community group for JPD, and so you may also want to check there in case someone has found a work-around for this need: https://community.atlassian.com/t5/Jira-Product-Discovery/gh-p/jira-product-discovery

A different way to solve this would be to not use the JPD calculated field.  Instead add a numeric field and set the value using an automation rule.  That would be saved and then be searchable with JQL.