Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can I add param to a filter?

Idith Eden April 22, 2018

I have created a dashboard using several filters (about 9 filters for different views)
All includes in the filter Sprint = "XX". This is also the field that needs to be adjusted from time to time.
Since the filter is controlled and can be modified only by the user created it, and modifying 9 filters can be annoying, I was wondering if there is a way to use in search a param, which can hold for example sprint value, and once updated it actually impact all 9 filters?

For example:

Instead of using the current filter: Sprint = 164 AND issuetype in (Bug, "Customer Support Bug") AND (status changed to (testing)) 
Use:  Sprint = $Current_Sprint AND issuetype in (Bug, "Customer Support Bug") AND (status changed to (testing))
where Current_Sprint = 164

Is that achievable? 

 

1 answer

0 votes
Walter Buggenhout
Community Champion
April 22, 2018

Hi @Idith Eden,

There's no such thing as a parameter you can use, but JQL has a couple of functions you can use to accomplish your goal:

Sprint in openSprints()

returns what you describe: your current sprint(s).

For reference, there's also these functions:

Sprint in closedSprints()
Sprint in futureSprints()

The first one will search for issues that are assigned to sprints that have been completed. The latter will search for issues that are assigned to a sprint that hasn't been started yet.

Idith Eden April 22, 2018

Thank you for your answer, this is closed enough solution when related to Sprints.

Can you also help me with another case that where I have filters that uses fixVersion, can I have also solution for that? As Fix version can be more then one opened at the same time...

Walter Buggenhout
Community Champion
April 23, 2018

Hi @Idith Eden,

There's a couple of functions you can use for fixVersion too, indeed:

fixVersion in unreleasedVersions()
fixversion = earliestUnreleasedVersion(project)
fixversion in releasedVersions()
fixversion = latestReleasedVersion(project)

For more details, see Atlassian documentation.

Idith Eden April 25, 2018

Thanks a lot, that might provide me the solution I need although not as flexible as I wish it to be.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events