i need a jira query to fetch all the tickets from last six months for based on the access type.

[nagasekhar]

need to fetch all the tickets from last 6 months for only with the subject.

like "S3 access" related. 

[Ashu Tyagi]

@nagasekhar  You can use below query 

text ~ "\"S3 access\"" AND Created >= -180d

This will give you tickets which have Phrase "S3 Access" and created 180 days or 6 months  ago, you can change text with either Summary of Description if you know where you want to look for this exact phrase. 

[Liam Green]

Hi @nagasekhar 

Welcome to the Community!

Will all the tickets you need have the correct summary?  If not, have you considered a custom field to capture this information and make reporting easier?

Thanks,

Liam

[Vikrant Yadav]

Hi @nagasekhar  Try below query JQL to get issue having Summary "S3 access"

project = XYZ AND created > startOfMonth(-6) AND summary ~ S3 access

 Thanks

Vikrant Yadav