Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Need filter Query to view all issues whose 'TimeSpent' field is update on last day

Sunaina Gupta May 28, 2014

I am looking for a way to find out which all team members have updated time spent and logged work on daily basis.

5 answers

0 votes
Sunaina Gupta June 1, 2014

project = "IBNM" AND issueFunction in workLogged("on 2014/05/30") AND "Implemented By" in membersOf("IBNM")

This is not working. Please suggest.


0 votes
Sunaina Gupta May 29, 2014

Let me try these out and get back. Thanks for responding!

0 votes
Haizelyn Casimiro May 29, 2014

Hi...

You could try using the queries I have posted above first. Script runner is a FREE plugin and is predefined in JIRA.

Go to Issues > Search for Issues > "Enter the query".

To view if you already have a script runner follow the image below:

You could also type the script runner in the search field as can be seen above. or follow this link: https://marketplace.atlassian.com/plugins/com.onresolve.jira.groovy.groovyrunner

Regards.

0 votes
Haizelyn Casimiro May 28, 2014

Hello,

If you have Script Runner already installed in your Jira, you could use the following query (without installing any other plugins) if you want to see the items whose logged hours is updated for a particular day:

1. This can be used if you want to query it from a particular project and group:

project = "<project name>" AND issueFunction in workLogged("on 2014/05/17") AND "Implemented By" in membersOf("<group name>").

2. This can be used if you want to query it from a particular date regardless of project and group:

issueFunction in workLogged("on 2014/05/17")

Hope this helps.

Regrads.

Sunaina Gupta May 29, 2014

Please share URL for script runner installation.

0 votes
Fabio Racobaldo _Herzum_
Community Champion
May 28, 2014

Hello Sunaina,

There's a plugin ( http://www.j-tricks.com/jql-tricks-plugin.html) that provides extra JQL functions, including the following :

Worklog functions

  • workStartedOn(date,[User])
  • workLoggedOn(date,[User])
  • workUpdatedOn(date,[User])
  • workLoggedBetween(startDate,endDate,[User])
  • workLoggedAfterDate(date,[User])

More information available here http://www.j-tricks.com/jql-tricks-plugin.html

BTW, my suggestion is Tempo Plugin (https://marketplace.atlassian.com/plugins/is.origo.jira.tempo-plugin) that, in my opnion, is the best way to monitor/report timesheet.

Hope this helps,

Fabio

Sunaina Gupta May 29, 2014

I can't find "Add-ons" on my JIRA administration page. Please share steps to reach there.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, loom, loom for training, loom for teaching, video training, async learning, online education, screen recording, loom tutorials, loom use cases, atlassian learning, team training tools, instructional video, virtual training tools

🛗 Elevate Your Training and Enablement with Loom

Join us June 26, 11am PT for a webinar with Atlassian Champion Robert Hean & Loom’s Brittany Soinski. Hear tips, stories, and get your burning questions answered. Learn how Loom makes training and enablement easier. Don’t miss it!

Register today
AUG Leaders

Atlassian Community Events