Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleAvailability

This feature is available for the Jira server deployment option only. We plan to add it to the Cloud version in the near future.

...

If we want to find the issues where work had been logged by a specified user. We can do this by using silJQLExpression:

...

Also, we can use this JQL to find the issues where work had been logged on a given date:

Code Block
titleJQL
key in silJQLExpression('size(getWorklogIds("2017-03-16", key)) != 0', 'project = TEST')

...

Code Block
titleJQL
key in silJQLExpression('size(linkedIssues(key, "Relates")) != 0', 'project = TEST')

To find all the issues that are blocked by issues with status "To Do" we could use:


Code Block
titleJQL
key in silJQLExpression('size(linkedIssues(key, "Blocks", 1)) != 0', 'project = TEST')  and status = 'To Do'

If we want to search for the linked issues whatever the link type with resolution "Done" :

Code Block
titleJQL
key in silJQLExpression('size(linkedIssues(key)) != 0', 'project = TEST') and resolution = Done

...

Issues by comparing dates

To search for issues that were resolved after the due date:

Code Block
titleJQL
key in silJQLExpression('resolution > dueDate', 'project = TEST') 

To find issues that were updated within one week after being created:

Code Block
titleJQL
key in silJQLExpression('updated < created + "1w" ' , 'project = TEST')

...

Code Block
titleJQL
key in silJQLList("notUpdatedByUsersInGroup.sil", TEST, jira-developers)

See also