Cascade not working in JQL

Question

I just migrated from server to cloud and having an issue with one of my Cascade fields in JQL. I want to show all results where the Parent Option equals a specific value (i.e. Parent = CityView and Child value can be any). Here's the query:

project = "Business Value Delivery" AND status in ("Being Planned", Reopened, "To Do", "On Hold", "Future Idea") AND "Application Module[Select List (cascading)]" = CityView

It's returning no results despite work types matching the criteria (I've redacted some info for privacy purposes - rest assured my sub-task is in the correct project and status).

Any ideas what I'm doing wrong?

Hector Florin · Accepted Answer

Hi @jessica_huebner

I hope you're doing well.

Reviewing yours screenshot I see that the example work item is in status "In Progress"

However, your JQL filter doesn't include "In Progress" status and that's why you cannot find the work item.

project = "Business Value Delivery" AND status in ("Being Planned", Reopened, "To Do", "On Hold", "Future Idea") AND "Application Module[Select List (cascading)]" = CityView

You need to either add "In progress" to your JQL status section or transition that work item to any of the JQL statuses so that the filter finds it.

I hope it helps.

Thank you, and have a great day.

Regards,
Hector