Σ Time Spent: Jira querying element name

[Sujith_Saji]

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.

[Stephen Crandell · Accepted solution]

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]

Thanks

[Sri R]

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.