queries for data

[Chag]

what would be a good syntax or the correct to pull datesand tickets? for example, I want to be able to pull the open tickets in the last 7 days and need to be able to show long they been open

[Alexey_Rjeutski__Polontech_ · Accepted solution]

Please check query syntax for WAS operator. Status support that as I remember.

https://confluence.atlassian.com/display/JIRA/Advanced+Searching+-+Operators+Reference#AdvancedSearching-OperatorsReference-WAS

[Chag]

ok, i got more details on what they need. They need to look at all the tickets in a component and how long they have been open.

I was thinking maybe something like this

project = "" AND component = "" AND resolution = unresolved AND status was open on endofweek ())

something like that work ?

[Alexey_Rjeutski__Polontech_]

No. Inside jql you put query criteria - that mean that "I want to see issues that were opened from yesterdey till today". As for seeing time in status - there is a feature request that is still open, so by default you will not see time in status in issue navigator (see https://ecosystem.atlassian.net/browse/JCHART-424)

As a possible solution - it is possible to create something like calculated custom field with this info and search / view according to it. But it requires development.

BTW please see https://answers.atlassian.com/questions/95556/how-to-get-the-time-spent-report-of-issues-in-a-particular-status- seems it is relevant to your request - it already contains the script field)

[Chag]

more like in the last 7 days or the past week. like what syntax would I use to show days?

[Chag]

more like in the last 7 days or the past week. like what syntax would I use to show days?

[Alexey_Rjeutski__Polontech_]

Could you clarify the request? Do you want to search issues that are open and were open > 7 days?