if you have access to the jira DataBase that query gives you the issues that are not present in the worklog table.
You take the issues whose id is not in the list of issues saved in worklog table.
worklog table looks like this:
You could also use simply something like this
SELECT * FROM jiraissue
WHERE (TIMESPENT is null OR TIMESPENT = 0)
AND project = (select pr.id from project pr where pr.pkey = 'PT')
But you could lose issues that had work logged and then it was removed (not a big problem usually but...)
Learn how to use two new reports for next-gen projects in Jira Cloud: Cumulative flow diagram and Sprint burndown chart. Ivan Teong, Product Manager, Jira Software, demos the Cumulative ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events