Versions Compared

Key

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


On this page you cand find This page contains information on searches for:

Table of Contents

...

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')

...