Σ Time Spent: Jira querying element name

Sujith Saji October 28, 2019

Hi,

 

I was trying to filter  Σ Time Spent = 0 with jira query, and this filed doesn't seems populating in query. The only querying element I see is 'timespent' not ' Σ Time Spent'.

Is there any other names for this element in the Query?

Th export can be simply filtered by  excel but would like to know if this has any element reference at all.

2 answers

1 accepted

1 vote
Answer accepted
Stephen Crandell
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 28, 2019

I don't think you can query on the "Σ Time Spent" field out of the box as that field is an aggregate. If you have EazyBI, you can get it though. It is the "hours spent with subtasks".

You might be able to create a numeric field and copy the value of the "aggregatetimespent" and query off that but, I have not tried it.

Sujith Saji October 28, 2019

Thanks

0 votes
Sri R February 3, 2021

Why JIRA is having lots of limitation in providing effective JQL functionality.

Is it because of its monopoly in encouraging to use paid tools? I started hating JIRA for its hell lot of limitation and offering every time only paid tools. 

Suggest an answer

Log in or Sign up to answer