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; } } }

Change status automatically

Ives Ziegler

Hi,

I would like to have the status changed automatically via the date, is that possible? or does anyone have an idea?

I have the following table extract - it is about the fact that with a table filter only the "Current week" and "Next week" are filtered out, i.e. the table is very long, but you only see the two rows. Now I want to automatically change the status on Monday because a new week has started. "Current week" then becomes "Past week" and "Coming week" then becomes "Current week".

Status	Date from	Date to
Past Weekend	06 Jun 2022	12 Jun 2022
Past Weekend	13 Jun 2022	19 Jun 2022
Current Week	20 Jun 2022	26 Jun 2022
Next Week	27 Jun 2022	03 Jul 2022
Coming Week	04 Jul 2022	10 Jul 2022

Best Regards,
Ives

Accepted answers

Katerina Kovriga {Stiltsoft}

Hi @Ives Ziegler ,

As you use the Table Filter macro, I can suggest filtering not by statuses, but by dates.

You may use such flexible date range filters as "today", "1w", "-1w", etc. to show rows with dates compared to the current date.

All comments

Ajay _view26_

Hi @Ives Ziegler

Welcome to the community!

Rather than using Jira Issue status, a better way would be use labels and use Automation for Jira to change the labels based on schedules . You can run the Automation at the start of week to change the affected labels

Cheers

Ajay

Katerina Kovriga {Stiltsoft}

Hi @Ives Ziegler ,

As you use the Table Filter macro, I can suggest filtering not by statuses, but by dates.

You may use such flexible date range filters as "today", "1w", "-1w", etc. to show rows with dates compared to the current date.

Ives Ziegler

thank you - with such a solution, I would have to have tickets created!? and then automate them again so that the status is updated.

Ives Ziegler

Can I take a date from today - 1week? would that work? then it would happen automatically and I wouldn't have to update the filter every week

Katerina Kovriga {Stiltsoft}

Yes, it should work: today <-> 1w selects the future week from today, -1w <-> today selects the previous week.

But don't forget to go to the Table Filter macro settings (the Filtration tab) and set the corresponding date format: for 06 Jun 2022 it will be d M yy.

Ives Ziegler

I have set "dd M yy" under the heading "Filtration".
Then under filters' default values I wanted to enter the "today" - how does this have to be entered? there is the same effect with users with @currentuser.........?

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

server

jira

jira-server