Forums

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

Is there a way to change the content of a board filter with a script ?

Mamta Verma October 11, 2018

Script should accept a list of boards and automatically modifies all the associated filters. 

1 answer

0 votes
MoroSystems Support
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.
October 15, 2018

Hello Mamta,

please elaborate: what kind of script are you talking about? JQL, SQL, JS,...? Or maybe let's start from not-technical point of view: what is your desired state, what do you want to achieve on a board?

Regards,
Martin

Mamta Verma October 15, 2018

Hi Martin,

Thanks for responding :)

I was referring to jira scriptrunner groovy scripting.

As per the requirement, Script accepts a list of boards and "filed against" values(a custom field) and automatically modifies all the associated filters. The script should set the filters JQL to the desired values regardless of the current values within the Filter.Script should be capable of fixing it if anyone were to modify/corrupt the filters manually.

Each Jira project space will have it's own unique "Filed Against" (a custom field) value associated with it. 

For example, the test project in Jira named "CBBOP" has a 'Filed Against' (a custom field) value of "CBB_Operations_Portal:26109" associated with it. The Filter for it's scrum and/or kanban board would need to be modified from the default. The new version of the filter should include any defects which have a Filed Against value of "CBB_Operations_Portal:26109".  In this example, the original/default JQL for the board filter is:

project = CBBOP ORDER BY Rank ASC

The new JQL for the board filter would be:

project = CBBOP OR (Project = "DEFECT" AND "TDP Filed Against (Agile)" = CBB_Operations_Portal:26109)  ORDER BY Rank ASC

hope this makes it a little clear with what I'm trying to achieve.

Thanks in Advance

Suggest an answer

Log in or Sign up to answer