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; } } }

Query problems.

Newmindssystems

Hello,

I'm a student who needs to setup a jira servicedesk. I got most working but i'm getting stuck on creating a certain query. I want to create a excel sheet, with al the tickets that are created in one month. I need to see certain fields like: Organisation Time started, Time registration, Time endend Ticket subject, Type ticket, prio, Code issuetype. Is it possible to write a query who can take this data in to a excel sheet and how do i do this?

Hope to have a sollution,

Giovanni, A IT student

Accepted answers

Fazila Ashraf

Hi @Newmindssystems

Welcome to community!

You can get the results with the below query:

created > startofmonth()

But before exporting it to csv, make sure you have added the fields you needed in export as columns in the issue navigator.

If you need only excel instead of csv, try https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?hosting=cloud&tab=overview

All comments

Fazila Ashraf

Hi @Newmindssystems

Welcome to community!

You can get the results with the below query:

created > startofmonth()

But before exporting it to csv, make sure you have added the fields you needed in export as columns in the issue navigator.

If you need only excel instead of csv, try https://marketplace.atlassian.com/apps/1221301/jira-cloud-for-excel-official?hosting=cloud&tab=overview

Newmindssystems

I did use the query (it's working) Thanks for that,

The only problem left is the export. When I want to export all fields to a csv file (and open it in excel) Excel wont get the fields how it should (It gets a weird look). I want it to make it look like example 2 How do i do that?

example 1:

Schermafbeelding 2020-11-18 122051.png

example 2:

Schermafbeelding 2020-11-18 122312.png

Newmindssystems

I made it work by changing some settings at my pc, Thank you for the great support!

Change the separator in a CSV text file
Click the Windows Start menu.
Click Control Panel.
Open the Regional and Language Options dialog box.
Click the Regional Options Tab.
Click Customize / Additional settings (Win10).
Type a new separator in the List separator box.
Click OK twice.

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