how do i search the status WAITING FOR SUPPORT TICKETS alone

[Vinothkumar Sekar]

assignee = currentUser() AND resolution = Unresolved order by updated DESC AND Status ='WAITING FOR SUPPORT' this is not working tell me what is wrong here

[Mohamed Benziane · Accepted solution]

Hi,

Welcome to the community

Can you try this:

assignee = currentUser() AND resolution = Unresolved AND status ='WAITING FOR SUPPORT' order by updated DESC

the word status must be written without capitalization, and the order need to be at the end of the query

[Mahima_miniOrange_SSO]

Hi Mohamed,

I don't think JQL is case sensitive, Correct me if I am wrong.

I think the query was not running mainly because of ORDER BY, as it needs to be at the end of the statement.

[Mohamed Benziane]

Hi Mahima,

You're right, i'm so used to write without uppercase that i was feeling that is the correct method to write jql my bad !

[Mahima_miniOrange_SSO]

assignee = currentUser() AND resolution = Unresolved  AND Status ="WAITING FOR SUPPORT" order by updated DESC

Can you please try if this works @Vinothkumar Sekar 

Thanks,
Mahima