nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to update filter jql via api from Jira Automation?

Richard A. Michaels

I have a Jira filter which uses the fix version field as a criteria.

Currently I manually update the fix version in the filter on a weekly basis.

The format of the fix version is standardized as vYYYYMMDD, I'd like to use automation to update the JQL in the filter on a weekly basis with the correct fix version via the API.

Accepted answers

All comments

Trudy P Claspill

Hello @Richard A_ Michaels

Please share with us the rule you have constructed so far and let us know with which part specifically you need help.

Richard A. Michaels

HI Trudy,

Thanks for the reply. The automation is currently setup as a manual trigger with a single Send Web Request action. The URL and custom data are below. The call also has the authentication header. The fixVersion value is hard coded for now until I can successfully update the filter with the API call.

URL

https://my-company.atlassian.net/rest/api/3/filter/22638

Custom Data

{

"description": "VTrack Release Filter",

"jql": "fixVersion=v20230206 ORDER BY key ASC",

"name": "Automation Test - Vtrack Release Tickets"

}

Trudy P Claspill

So, is your question "how do I dynamically derive the fixVersion value based on the date the automation runs?"

If that is your question, my next question is what is the relation between the date (or day of week or month) that the automation will run and the fixVersion value that would be used in the filter?

There are a variety of date and time functions that can be used with smart values in automation rules to derive and format date strings based on the current date/time or custom date/time fields.

Richard A. Michaels

Hi Trudy,
I'm getting a "bad request" error when I submit the call.

That's why I hard coded the fix version to ensure the API call can be successful with static data. That is not happenings. I've did discover the jql was invalid but that wasn't what is causing it to be a bad request.

Here's updated custom data. I validated the jql by creating an actual filter with just the information below.

{
"description": "VTrack Release Filter",
"jql": "fixVersion = v20230227",
"name": "Automation Test - Vtrack Release Tickets"
}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud