I want a custom filter

Question

I need a custom filter for Customers where the ticket status is not 'Closed,' and the tickets are categorized as either 'Bugs' or 'Production Bugs,' with a last updated date in the year 2024.

I am using this Query; but its not working for me.

"Customer[Select List (multiple choices)]" = .. AND status != Closed and type = "Production Bug" and updated <= startofyear()

Duc Thang TRAN · Answer

Hello @Vandana

If you want all tickets with a last updated date in the year 2024, for me is :

updated >= startofyear()

Valerie Knapp_dpp5c6 · Answer

Hi @Vandana , welcome to the Atlassian Community and thanks for your question.

In your query, does the 'Customer' field have multiple customers? If so, I would use IN and not the =

"Customer[Select List (multiple choices)]" IN .. AND status != Closed and type IN ("Production Bug", Bug)and updated <= startofyear()

You can try this ^ and see if it works better. If it doesn't, please share your feedback and either I or someone else will try to help.

Cheers