How to get a list of tasks with a request in jira?

Question

JIRA

You need to get a list of tasks in which the time spent exceeded the estimate.
Tried to build the following query:
project = 17122 AND (sprint = 10155 OR sprint = 10156 OR sprint = 10735) AND timeestimate > timelogged
Error: The value "timelogged" for the field "timeestimate" is incorrect. Specify a positive duration value; for example: "1h 30m", "2d".

Answer 1

Apparently you meant timeestimate < timelogged.
Try 'and workRatio > 100'.
https://community.atlassian.com/t5/Jira-questions/...