Need a query that filters assigned within 2 hours from created time

Question

Hello Team,

Please help us on finding the filter. We need to filter out the tickets, which are assigned to users with in 2 hours after their created time.

Thanks,

Kai Krause_xx7uj7 · Accepted Answer

Hi and Welcome,

In native Jira Cloud you cannot compare two issue-level timestamps (e.g., created vs. first assignment) directly in JQL.

JQL lets you ask “When was a field changed?” but it cannot do arithmetic like “CHANGED within 2 hours of created”.

When you have scriptrunner you can use

issueFunction in dateCompare("", "assignee", "created +2h")

without any plugin you can use automation

Mark the issue via Automation, then filter

If you want a simple “Yes/No” flag instead of a full SLA:

a. Project settings ➜ Automation ➜ Create rule
• Trigger: Field value changed ➜ Assignee
• Condition: Issue created less than 2 hours ago
• Action: Add label e.g., assignd-in-time

b. Then your JQL is trivial:

labels = assignd-in-time

BR
Kai