changed status

[Maria Leonor Mourão]

Hi,
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

[Charlie Misonne]

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?

[Maria Leonor Mourão]

Hi Charlie thank you for the fast answer!

For some reason the Created vs resolved bugs report isn't counting the created bugs, and i'm sure why...

[Charlie Misonne]

Well that's difficult to troubleshoot without seeing the environment.

Can you share a screenshot of your workflow and the report?

[Maria Leonor Mourão]

[Maria Leonor Mourão]

Criados= created

[Charlie Misonne]

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".