Scheduled Issues Watcher List Query

[Darrol Clark]

Is it possible to query a list of the scheduled issues and the watchers of each scheduled issue within a project? Or, is it possible to list issues that have been created from the scheduler with this same information?

[Lucas Modzelewski _Lumo_]

I believe with JQL, you won't get explicit result of watchers list as it's intention is to return tickets always

With that in mind you can build queries returning issues where some conditions are satisfied.

You can start building your query with:

1. all issues created by The Scheduler in given project list eg. SDD:

issue in schedulerGetAllGeneratedIssues(SSD)

Source: https://psc-software.atlassian.net/wiki/spaces/SCHED/pages/401997825/Dedicated+JQL+functions

2. if you want to get issues with current user as a watcher add "AND watcher = currentUser()"

issue in schedulerGetAllGeneratedIssues(SSD) AND watcher = currentUser()

 3. now, if you want to exclude issues where current user is assignee to geth 'other' issues at plate:

issue in schedulerGetAllGeneratedIssues(SSD) AND watcher = currentUser() AND (assignee is EMPTY OR assignee != currentUser())

Source: https://community.atlassian.com/t5/Jira-questions/Filters-watchers-where-current-user-is-not-an-assignee-returning/qaq-p/360416

You can also check watchers in specified list of watchers, and replace it with currentUser(): https://community.atlassian.com/t5/Jira-Software-questions/JQL-Option-for-querying-stories-by-the-Watcher-list/qaq-p/1372732

[Darrol Clark]

Hello,

This is helpful for me to track down issues generated by the Scheduler. I am more looking to query data related to the Scheduler tasks themselves. Is this possible to do with SQL?