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

[Navya Sri]

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 · Accepted solution]

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

[Navya Sri]

Thank you so much Kai for your help, this works!