Versions Compared

Key

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

You can use JQL to query which issues has a reminder, either active or completed. There are 4 JQL functions and all of them starts with “issuesWithReminder” prefix:

  • isuesWithReminder(“filterOutCompleted”“true/false”): This is the most basic of all JQL functions. It just returns all issues with reminders. It takes one optional parameter to determine whether to filter out return issues with only completed reminders (default false).expired reminders to be returned. Default is true, which means all issues with reminders, either active or inactive are returned. If it is false, only the issues with at least one active reminder are returned. 

Following queries returns all issues which has at least one reminder (active or completed).


Code Block
themeDJango
issue in issuesWithReminder()
 issue
 
issue in issuesWithReminder(
false
“true”)


Following query returns all issues which has at least one active reminder.


Code Block
themeDJango
issue in issuesWithReminder("
true
false")


  • issuesWithReminderOwnedBy(“username”, “filterOutCompleted”“true or false”): This query returns issues which are owned (set up by) given username. It takes an additional one optional parameter to determine whether to filter out return issues with only completed reminders (default false).expired reminders to be returned. Default is true, which means all issues with reminders, either active or inactive are returned. If it is false, only the issues with at least one active reminder are returned. 

Following query returns all issues which has at least one reminder set up by user with username “ataoguz”


Code Block
themeDJango
issue in issuesWithReminderOwnedBy("ataoguz",
 
 "
false
true")


  • issuesWithReminderForUser(“username”, “filterOutCompleted”“true or false”): This query returns issues which has reminders set up for the given username. It takes an additional one optional parameter to determine whether to filter out return issues with only completed reminders (default false).expired reminders to be returned. Default is true, which means all issues with reminders, either active or inactive are returned. If it is false, only the issues with at least one active reminder are returned. 

Following query returns all issues which has at least one reminder set up for user with username “adaoguz”


Code Block
themeDJango
issue in issuesWithReminderForUser("adaoguz",
 
 "
false
true")


  • issuesWithReminderForEmail(“email”, “filterOutCompleted”“true or false”): This query returns issues which has reminders set up for the given email address. It takes an additional one optional parameter to filter out determine whether to return issues with only completed reminders (default false).expired reminders to be returned. Default is true, which means all issues with reminders, either active or inactive are returned. If it is false, only the issues with at least one active reminder are returned. 

Following query returns all issues which has at least one reminder set up for email address “externaluser@client.com


Code Block
themeDJango
issue in issuesWithReminderForUser("
externaluser@client
externaluser@client.com",
 
 "
false
true")


  • issuesWithReminderForRole(“rolename”, “filterOutCompleted”“true or false”): This query returns issues which has reminders set up for the given project role. It takes an additional one optional parameter to determine whether to filter out return issues with only completed reminders (default false). If expired reminders to be returned. Default is true, which means all issues with reminders, either active or inactive are returned. If it is false, only the issues with at least one active reminder are returned. If you need to filter reminders for only a specific project add another JQL clause to filter projects as shown in the following example, without it query returns results from all projects.

Following query returns all issues which has at least one active reminder set up for project role “deployment-team” in ERP project.


Code Block
themeDJango
issue in issuesWithReminderForRole("deployment-team",
 
 "true") AND project =
 
 "ERP"


  • issuesWithReminderForGroup(“cm”, “filterOutCompleted”“true of alse”): This query returns issues which has reminders set up for user group. It takes an additional one optional parameter to filter out determine whether to return issues with only completed reminders (default false).expired reminders to be returned. Default is true, which means all issues with reminders, either active or inactive are returned. If it is false, only the issues with at least one active reminder are returned. 

Following query returns all issues which has at least one active reminder set up for cm(Configuration Management) group.


Code Block
themeDJango
issue in issuesWithReminderForGroup("cm",
 
 "true")