A while ago i created a filter to search for projects created today:
project = XXXX AND status != YYYY AND "start date[date]" >= -30m AND "start date[date]" <= 30m
ORDER BY created DESC
this worked fine until start of this week.
now it won't find any projects at all.
i even tried to search for the projects with that filter:
Start date[Date]" >= startOfDay() and "Start date[Date]" <= endOfDay()
it doesn't work either.
Thanks for your help
Hi, @Eric Schneiter
Welcome to Atlassian Community!
Creating new projects isn't a very frequent task, so based on your JQL, I assume you're actually looking for issues created today.
You can use a more flexible and accurate JQL query for this purpose. For example:
project = XXXXX AND status != YYYY AND created >= startOfDay()
This will return all issues created today, regardless of the exact time.
The "Start Date" field in your query is a custom field, and it looks like new issues no longer have values populated in this field — which is why your search isn't returning any results.
If you want to restore the functionality of your old query, you'll need to investigate why the "Start Date" field is empty in new issues. Was there previously an automation rule or default value setup that’s now disabled or misconfigured?
Hi Evgenii
thanks for your reply. I did wait today for tasks to be finished and the old filter did work again. IDK why.
I did replace my old code with your suggestion. Works now fine too.
thanks for taking your time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please removing one by one word from your query, this can help you identify which particular section is causing the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good day, @Eric Schneiter
Could you please explain what exactly a "Project" is to you?
Because Jira filters are mainly used to search for Issues within a Project. But you're saying you're searching for Projects that started within a 60m range of time for a specific date.
Could you please elaborate more?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.