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

SELECT result from JQL

Ram Muthiah

Is there a way I can select specific sub-set of result from JQL? Let us say that I do JQL like

project = "My project" and timeSpent is not null

Instead, I want to do

SELECT timespent WHERE project = "My project" and timeSpent is not null

Is it possible in JQL? Basically, I want this to work like regular SQL query. Is there another way to accomplish this?

Accepted answers

Nic Brough -Adaptavist-

JQL is not SQL. JQL returns a list of issues, and that's it. It has nothing to say about the output.

Remember that there are loads of ways of displaying search results from Jira. Your "select" would be not only useless but actively counterproductive in a lot of places - for example if you used that filter in the "filter statistics gadget", because that needs fields other than time spent.

So, no, you need to separate out "searching for issues with JQL" from "displaying information about the issues".

All comments

Nic Brough -Adaptavist-

JQL is not SQL. JQL returns a list of issues, and that's it. It has nothing to say about the output.

So, no, you need to separate out "searching for issues with JQL" from "displaying information about the issues".

Ram Muthiah

Thanks Nic. In my example above, I can export the results to Excel from JQL

project = "My project" and timeSpent is not null

and calculate the timespent. Is there any other way of "displaying information about the issues"?

Nic Brough -Adaptavist-

Loads - the issue navigator is quite customisable, there are reports and gadgets built-in and you can always add plugins if the built-in stuff doesn't work. All of the reports are more clever than excel, although they all have a specific output which may not be what you want.

Contact Kintosoft

This is easy to do with SQL for JIRA:

SELECT timespent WHERE JQL='project = "My project" and timeSpent is not null'

Contact Kintosoft

Nick, Thanks for recommending SQL for JIRA in private. smile . However, a lot of users read old questions AT THE PRESENT and SQL for JIRA is a right, valid and up to date ANSWER. It's frequent that vendors that create a new plugin or support a new feature post and answer even years ago. From time to time I got emails of answers which a vendor has posted in an answer and the original question is from 2012 or 2013, 2014.. but you do not down vote them nor say "this is spam". So your action is personal and selective for SQL for JIRA. I'm just writing a complaint about you after seeing you have voted SQL for JIRA -1 a lot of times today.

FYI: Today at he morning, SQL for JIRA has become free due the difficulties in selling it. THANKS FOR YOUR VALUABLE HELP:

Nic Brough -Adaptavist-

It's free? That's excellent news! That's removed my "it's an advert" objection.

It is not a personal thing, other users who have necro-posted adverts get voted down too.

I'm happy to undo the negative votes now that it's free, but I'd still ask you to stop the necro-postings, as they're pretty annoying (but an annoying I will ignore now)

Contact Kintosoft

Ah! Nick, it is free then... is not spam yet? Incredible ridiculous answer.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration