How can I set up a filter to apply conditions based on the due date?

[Jimmy Trivedi]

I'm using Filters and Automation both.

Filter screenshot

Automation screenshot

I have multiple labels applied to Jira issues, for example “Regular” and “Default”.

Requirement:
This rule should only apply when the label is “Regular.”
If any other label is present, this requirement should not have any impact.

Issues should appear in the Main filter only when the “Regular” label’s condition matches the issue’s due date.

I’m not sure whether this requirement can be fulfilled through a filter query, automation rules, or a combination of both.

Examples

Example 1

• Jira Issue: Test1

• Label: Default

• Due Date: After 2 days

• Expected Result: Should appear in the Main filter

Example 2

• Jira Issue: Test2

• Label: Regular

• Due Date: After 2 days

• Expected Result: Should NOT appear in the Main filter until the due date is reached

Example 3

• Jira Issue: Test3

• Label: Default

• Due Date: Today

• Expected Result: Should appear in the Main filter

Example 4

• Jira Issue: Test4

• Label: Regular

• Due Date: Today

• Expected Result: Should appear in the Main filter

Main filter query

[project = GJP AND issuetype in (subTaskIssueTypes(), Story, Task, Subtask) AND status in ("In Review", Pending, Reopened, TODO, "Work in progress") ORDER BY due ASC, cf[10059] ASC, priority DESC,originalEstimate ASC]

[Bill Sheboy]

Hi @Jimmy Trivedi 

For automation questions, please post an image of your complete rule and the audit log details showing the rule execution.  Those will provide context for the community to offer better suggestions.

Until we see those...

Your examples do not match your description of:

Issues should appear in the Main filter only when the “Regular” label’s condition matches the issue’s due date.

Based on the description, do you mean:

project = yourProject
  AND ( 
        (
          duedate = now()
          AND labels IN (Regular)
        )
        OR (
          duedate != now()
          AND (
            labels NOT IN (Regular)
            OR labels IS EMPTY
          )
        )
      )

Based on the examples, do you mean:

When the Due Date is today, include everything; otherwise only include work items when the Labels do not contain "Regular".

If so, written as JQL:

project = yourProject
  AND ( 

          duedate = now()

        OR (
          duedate != now()
          AND (
            labels NOT IN (Regular)
            OR labels IS EMPTY
          )
        )
      )

Please note well: I left off your other JQL expressions to clarify the scenario, which you could add once it is clarified.

Kind regards,
Bill