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 do I map the filter at the top to my query?

Shaweta Nasa

Hi,

I have created a report "Created vs Resolved" for tracking the issues created and resolved over time.

For created, I have used the created in range -1w to 1w which shows me the data for one week. But I need to map this to Show filter. So, if I select show as 10 days, it should update my query to 10 days instead of 1 week.

The JQL I have used is as below -

issuetype in standardIssueTypes() AND created >= -1w AND created <= 1w

Please suggest.

Thanks!

Accepted answers

David Friedrich

Hi @Shaweta Nasa , Welcome to the Atlassian Community.

Can't you just use

created >= -10d ?

Or am I misreading something in your question?

All comments

David Friedrich

Hi @Shaweta Nasa , Welcome to the Atlassian Community.

Can't you just use

created >= -10d ?

Or am I misreading something in your question?

Shaweta Nasa

Hi @David Friedrich ,

Thanks for the reply!

I can use -10d but I want it to calculate the days on whatever I select from "Show" dropdown. Kind of runtime vs putting a constant value.

Hope this explains.

Thanks!

David Friedrich

Sorry, I'm afraid I do not understand what you are trying to achieve here...

The "Show" setting does set the range already, why would you need a range defined in your JQL additionally?

Besides I do not think that that would be possible as JQL doesn't work with variables in this sense.

Shaweta Nasa

I am so sorry for the confusion! I just started exploring and not aware of the functionality of JQL.

Here is the query for resolved tickets -

issuetype in standardIssueTypes() AND status in (Canceled, Done, Resolved)

This one shows me the data based on the "show" filter as you said.

But then what should be the query for created tickets on a particular day? If I use Created in JQL , it asks me for the range of days. Lets say I selected -1w to 1w for a week's data. But if the user selects 10 days from the "show" filter, the data would not be correct because my JQL is pulling the data only for 7 days.

So, what should be the query for created tickets?

Thanks!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management