Search the JIRA Tickets in which i have worked but i have not logged work log time

[Sujan Shrestha]

I am using Jira (Jira v7.13.0) and i want to find all the jira tickets i have worked in but have forgot to logged the time i.e. time spent to complete the ticket.

I am using following JIRA query.
project = "Implementation changes and enhancements" and issueFunction in commented('by i20324') and worklogAuthor != currentUser()

But i am getting following error.

[Olga Videc · Accepted solution]

Hello @Sujan Shrestha 

I checked your JQL it works, just a quick question this is Scriptrunner functions you do own script runner?

Also, check if the script runner need's update.

BR, Olga

[Sujan Shrestha]

@Olga Videc :

I am sorry i don't know about scriptrunner functions. how can i find if script runner is present in my JIRA or not.
Plus, following query works:

project = "Implementation changes and enhancements" and issueFunction in commented('by i20324') and worklogAuthor = currentUser()

only ,worklogAuthor != currentUser()  doesnot work.

Thank You

[Olga Videc]

Hello @Sujan Shrestha 

There is a record of this issue from before.

Try using lower case clause.

https://jira.atlassian.com/browse/JRASERVER-64385?page=com.atlassian.jira.plugin.system.issuetabpanels%3Aall-tabpanel

https://jira.atlassian.com/browse/JRASERVER-64315

[Sujan Shrestha]

Thank You for the help. The link you provided had the answer i needed.

project = "Implementation changes and enhancements" and issueFunction in commented('by currentUser()') and issueFunction not in workLogged('by currentUser()') order by createdDate desc

This worked:  issueFunction not in workLogged('by currentUser()') 
instead of
worklogAuthor != currentUser()