Using AQL in Jira

[Niklas Zarnecke]

Hi everyone,

I'm currently setting up a asset management in Jira for my company. All in all it's moving pretty smoothly but I'm failing to achieve some key points:

1. Is there any way to show all the assets in one big list? Is there some way to use the AQL outside of a custom field? At best this would be sorted by the key, starting with the newest object.
2. Can I build some filters anywhere? We have to check once a year which hardware was listed out, a list starting from the latest entry would be nice. (Achieved with AQL as well?)
3. Is there any way to move a object to another category?
4. The final question is more of a inspiring nature for me: how are you using automation linked to your assets?

Thanks in advance and best Regard
Niklas

[Javi · Accepted solution]

Hi Adam,

From the Jira UI, there is currently not a way to export worklog data from a specific month without getting previous worklog months included.

However, you can pull the worklog data from the Jira database. All worklog data is stored in the "worklog" table and you can run a query similar to the following:

select * from worklog where startdate >= '2018-04-01' AND startdate <= '2018-04-30'

See: Worklog Table

You will have to associate the id to the jirasissue.id in order to determine the relation to the issue. 

If you do not wish to run queries on your database, you might be interested in checking out the Timesheet Reports and Gadgets as the plugin allows you to extract work log information. The following documentation provides steps on how to achieve this with the plugin: Timesheet Reports and Gadgets Documentation

Regards,
Javier A.

[Catherine Chang]

Hi there! I'm the PM on Jira Cloud for Google Sheets, and we're working to make this easy. Check out this post to see how you can import all of your worklog data into a spreadsheet with just a few clicks!