On this page:
...
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 | ||
|---|---|---|
| ||
key in silJQLExpression('size(getWorklogIds("2017-03-16", key)) != 0', 'project = TEST') |
Find issues with attachments
To return issues with attachments for a given project we can use this simple JQL:
| Code Block | ||
|---|---|---|
| ||
key in silJQLExpression('size(attachments) != 0', 'project = TEST') |
Find issues with links
In order to find the issues that are linked we can use the following JQL:
...
| Code Block | ||
|---|---|---|
| ||
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 | ||
|---|---|---|
| ||
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 | ||
|---|---|---|
| ||
key in silJQLExpression('size(linkedIssues(key)) != 0', 'project = TEST') and resolution = Done |
...
Find issues by comparing dates
To search for issues that were resolved after the due date:
| Code Block | ||
|---|---|---|
| ||
key in silJQLExpression('resolution > dueDate', 'project = TEST') |
To find issues that were updated within one week after being created:
| Code Block | ||
|---|---|---|
| ||
key in silJQLExpression('updated < created + "1w" ' , 'project = TEST') |
...