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

Σ 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.

Accepted answers

mrcrandell.sw

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.

All comments

mrcrandell.sw

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.