How to write a JQL query to find tickets raised for an organisation in the last month?

Matt Torr

Hi there, I'm new to using JQL and so was hoping someone could assist me in writing a query. 

I need to find all tickets raised in the last 30 days against a specific organisation.

If possible, I'd also like to include an "Or" function to search for a key words in the description, but am not sure this is possible.

Trudy P Claspill

Hello @Matt Torr 

Welcome to the Atlassian community!

The criteria for selecting issues based on the Organization of the Report of the issue looks like this:

reporter in organizationMembers(Org1) 

...where Org1 is the name of the organization.

The criteria for selecting issues created in the past 30 days is:

created >= -30d

To get issues that match both those criteria, combine them with the AND operator.

reporter in organizationMembers(Org1) AND created >= -30d AND project=yourProject

I added a third criteria to indicate the project where I want to search for those issue.

If you want to also restrict what is found based on keywords in the Description field you would add another criteria like this for each keyword:

AND Description ~ "yourKeyword"

You can learn more about executing searches here:

https://support.atlassian.com/jira-software-cloud/docs/search-for-issues-in-jira/