How to create a new filter where can get the list of issue which is raised only in that sprint only

Question

I am trying to create a new filter where I can get the list of issue which is raised only in that sprint and also, not the defects which are carry forwarded to next sprint.

I tried using this filter 
project = ABC AND issuetype = Bug AND component = sales AND Sprint in ("Sprint 1", "Sprint 2", "Sprint 3") ORDER BY component ASC

But , i am getting the sprint wise issue where in carry forwarded issues also getting displayed on the dashboard. due to this count is getting mismatched. could you please help me out in creating this filter ?

Fabio Racobaldo _Catworkx_ · Answer

Hi @Shilpa_R ,

welcome to the Atlassian community!

You can try to use openSprints(), closedSprints() and futureSprints() functions.

sprint in openSprints() : it filters issue associated to all on going sprints.

More information available at the following article https://community.atlassian.com/t5/Jira-articles/Common-JQL-queries-for-sprints-in-Jira-Cloud/ba-p/1736456

Hope this helps,

Fabio