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 put Filter which shows issue till Current date till night 11:59 PM?

Jimmy Trivedi

This is my JQL:

due <= "0" AND project = GJP AND issuetype in standardIssueTypes() AND status in ("In Review", Pending, Reopened, TODO, "Work in progress") AND labels in ("Default", Learning, Regular, Support, Transcation, Trending, Periodic, regular) ORDER BY due ASC, cf[10059] ASC, priority DESC

When I put this filter, save and refresh it, it is giving correct output, but after few hours it's getting reseted.

Expectation: I use this filter from long time and it is working fine. The only modification today I added is this: due <= "0"

Because I only need issue which due date is till today 11:59 PM.

Accepted answers

All comments

Jack Brickey

Hi @Jimmy Trivedi , can you clarify "due date is till today 11:59 PM"? Do you want issues that fall into one of the following?

Issue that are due today or past due or do you only want issues that are due today?

Muhammad Moazzam Hassan

For due date you can use the query duedate <=endofDay() which is equals to 11:59 PM.

Jimmy Trivedi

It's fine either way because, I use automation, where every night it changes to the current date, so in filter anyway issues will come from Today's date and onwards.

Jimmy Trivedi

I tried it, but I want the view to be in basic mode.

This query is too complex to display in Simple mode.

Jimmy Trivedi

Screenshot 2023-11-13 at 18.22.10.png

Muhammad Moazzam Hassan

Yes, the functions cannot be used in a basic mode.

Jimmy Trivedi

You can share any one solution

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management