nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to write a JQL for stories created last 5 days

Bryan Weimerskirch

I am trying to prevent scope creep with my client. Majority of the time they will add new stories to the board and can be difficult to track. We are working on a rather large project and we decided to use components to organize the board.

Users will create a story and add the component so that the story will populate on our swim lane.

I know that 2 stories were created this week but when I write my JQL it is bringing back 20 plus stories. Im not sure why it is doing that. See JQL below.

project = AMPS AND issueType in (Story, Bug) AND component = "2019 Remaining" OR component = "SO - BUCKET" AND created = "-5d"

Thanks

Accepted answers

Manon Soubies-Camy

Hi @Bryan Weimerskirch and welcome to Community!

Can you try the following query instead:

project = AMPS AND issueType in (Story, Bug) AND (component = "2019 Remaining" OR component = "SO - BUCKET") AND created >= -5d

You could also use this one if you want to work within the current week:

project = AMPS AND issueType in (Story, Bug) AND (component = "2019 Remaining" OR component = "SO - BUCKET") AND created >= startOfWeek()

Hope this helps,

- Manon

All comments

Manon Soubies-Camy

Hi @Bryan Weimerskirch and welcome to Community!

Can you try the following query instead:

project = AMPS AND issueType in (Story, Bug) AND (component = "2019 Remaining" OR component = "SO - BUCKET") AND created >= -5d

You could also use this one if you want to work within the current week:

project = AMPS AND issueType in (Story, Bug) AND (component = "2019 Remaining" OR component = "SO - BUCKET") AND created >= startOfWeek()

Hope this helps,

- Manon

Sid_kvhzt3

Try this

project = AMPS AND issuetype in (Bug, Story) AND component in (2019 Remaining, SO - BUCKET) AND created >= "-5d"

Michael Kuhl {Appfire}

Hi @Bryan Weimerskirch

Consider changing your created = "-5d" clause to one of these:

created >= -5d
created >= startOfWeek()

Bryan Weimerskirch

Hey Manon! I tried both of those and my results come back with 61 stories now.

Bryan Weimerskirch

Thanks for getting back but JIRA does not accept this JQL.

Bryan Weimerskirch

Thanks Michael I have tried that as well but still 20 plus stories.

Manon Soubies-Camy

Re-reading your initial post, you may need to remove the Bugs from your query. So it would be:

project = AMPS AND issueType = Story AND component in ("2019 Remaining","SO - BUCKET") AND created >= startOfWeek()

Thanks @Sid for reminding us to use component in (xx,xx)!

Bryan Weimerskirch

Awesome! Thank you so much, this worked!

Sid_kvhzt3

Ya, you may need to add the "" for components.

project = AMPS AND issueType = Story AND component in ("2019 Remaining","SO - BUCKET") AND created >= -5d

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud