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.

[Muhammad Moazzam Hassan]

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

[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]

[Muhammad Moazzam Hassan]

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

[Jimmy Trivedi]

Request you to is there any possibility to achieve both things together?

[Muhammad Moazzam Hassan]

yes, use due >= "0" AND due <= "1" it can run in basic as well

[Jimmy Trivedi]

Even though you suggested earlier option, not that filter is automatically reseted, How?

[Muhammad Moazzam Hassan]

I don't understand your question. 

[Jimmy Trivedi]

For example, from last 1 year I'm using this filter and it is working fine:

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

Then I added due duedate in my filter, so after sometime, it is getting reseted to what I was using so far. Basically it is removing duedate part from my filter.

I use Jira Android app as well, is there any possibility that it is happening with that, but previously also I was using that.

PS: Filter is getting reseted means when I open filter tab in my laptop chrome browser, it is not filtering according to due date and when I observe I got to know that somehow filter is getting reseted.

[Muhammad Moazzam Hassan]

Yes, maybe this can be a bug or a some sort of change in Atlassian.

[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?

[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]

You can share any one solution