Jira Query

[Ricardo Gonzalez]

I have a query as shown above. Trying to get ticket listed without Label: InternalTicket or Business Ticket. How Can I include that in the query: eg AFTER: project = SD AND created >= -1w ORDER BY created ASC, summary ASC INCLUDE 
DOES NOT CONTAIN " INTERNALTICKET" OR "BUSINESS TICKET"

[Ollie Guan · Accepted solution]

Hi @Ricardo Gonzalez,

you can try the JQL:

(project = xxx and labels is EMPTY) or (project = xxx and labels not in (aa,bb))

[Ricardo Gonzalez]

I need to know how to set the following query:

(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:

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

(Labels contain (InternalTicket) but Labels does not contain (BusinessTicket))

[Ricardo Gonzalez]

Hi @Ollie Guan,can you nelp me here?

Thanks in advance

Regards