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

[Fazila Ashraf · Accepted solution]

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:

example 2:

[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

1. Click the Windows Start menu.
2. Click Control Panel.
3. Open the Regional and Language Options dialog box.
4. Click the Regional Options Tab.
5. Click Customize / Additional settings (Win10).
6. Type a new separator in the List separator box.
7. Click OK twice.