How to get Issue that not updated since 6 months?

[Gold]

Hi,

I have more than 2500 issues since 5 years, and few of them aren't modified, or updated since more than months.

I need query that can allow me to show list of Issue something like that ? 

project = xxx AND updatedDate = more than 6 months

thank you for your help

[Kristin Lyons]

You should be able to use this, you just have to convert from months to weeks, 24 weeks is roughly 6 months if I'm doing my math correct :D

project = xxxx and updated <= -24w

[Gold]

I put also that query for more option of their status :

project= banana and updatedDate <= startofday(-180d) AND status in (Accepted, Analysed, Submitted, StartedWork, Postponed)

[Deepanshu Natani]

You can try this:

project= "xxx" and updatedDate <= startofday(-180d)

[Gold]

Thank you very much i'm very very happy.

Also, please help for this new adjust of query :

Need to see all projects assigned to differents users and always in status submitted like this : 

project= Banana AND assignee = (User1, User2, User3) AND status != Submitted

Jira  gave me that error : 
"Operator '=' does not support the list value '("User1", "User2", "User3")' for field 'assignee'.  

but why ? 

[Deepanshu Natani]

You have to use in operator in such cases. Like:

project = banana AND assignee in (user1, user2, user3) AND status in (status1, status2)