Jira querys

[Ricardo Gonzalez]

I need to know how to set the following query:

find ticket by (project = SD

1- tickets that still active or open

2- opened  (on, not on, before, at or before, between ) (Today, Yesterday, Tomorrow, this week, last week, this month, last month, next month, last 3 month, last 6 month, last 9 month, last 12 month, the same but by quarter, by end)

3- Opened by: reporter

4- by label eg(Labels contain, does not contain, starts with, end with:eg

(Labels contain (InternalTicket) but Labels does not contain (BusinessTicket))
5- find ticket by summary: how is the sentence 

[Thomas Schlegel · Accepted solution]

Hi @Ricardo Gonzalez,

here are some examples. I do not list every single one of your queries, I think you can implement the missing ones on your own:

- status not in (closed or whatever your closed status is)

- created > startOfDay()

- not created > startOfDay()

- created > startOfDay(-1) 

- reporter = <username>

- labels = <label>

- not labels = <label>

- labels in (<label1>, <label2>

- labels = Internal and not labels = business

- summary ~ word

You can find more information about JQL here: 

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

Please have a look at this documentation. You'll find everything there.