I'm trying to create a code in SQL that filters all the bugs that have the status "New" and that changed from new, but it is not working. can someone please help me?
the formula that i was trying to use was:
issuetype = "Bug Report" AND status = New OR status changed from New
Welcome to the Atlassian Community!
You are trying to get all issues that are currently in status New + the issues that were in status new and are not anymore?
The syntax seems correct. Can you explain what result you are getting and what you are expecting exactly?
It should not be necessary to filter for: status = New OR status changed from New. New is your first status meaning all issues have been in that status some point in time.
Filtering for issuetype = "Bug Report" should be sufficient assuming "Bug Report" is the actual name of the issue type.
Can you check the configuration of the report? Any chance "Display Versions?" has been set to "only major versions"? Try setting it to "none".
This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events