Search code examples
jirajql

How to query Issues updated by membersOf("TEAMX") on Yesterday in JQL

I want to create a filter to check the issues that my team members has worked on yesterday. How can I do that. I treid this.

watcher in membersOf("TEAMX") AND updatedDate < -1d AND updatedDate > -2d ORDER BY updatedDate asc

But it gives an issue watched by member of TEAMX (in any date) but updated o yesterday but any one. (maybe not in TEAMX).

My actual concern is creating a filter for query the TEAMX members that haven't enter worklog yesterday. Above one is just a secondary option.

Solution

  • If you have the free Script Runner plugin installed, you have a lot of JQL functions added. One of it is the workLogged (The link in that sentence points here).

    Cons

    1. It accepts only a username, not groups, nor roles.
    2. JIRA needs to be reindexed after plugin installation to use this function.

    Usage

    • issueFunction in workLogged("by johndoe after 2015/01/01")
    • project = PRJX AND issueFunction in workLogged("on -1d")