J tricks - Little JIRA Tricks
  • Home
  • Plugins ↓
    • JQL Tricks Plugin
      • JQL Tricks Plugin - Cloud
        • JQLT Cloud Installation
        • JQLT Cloud Configuration
        • JQLT Cloud Usage
        • JQLT Cloud License
        • JQLT Cloud FAQ
      • JQL Tricks Plugin - DC
        • JQLT DC Installation
        • JQLT DC Configuration
        • JQLT DC Usage
          • JQLT Issue Functions
          • JQLT Subtask Functions
          • JQLT Links Functions
          • JQLT Development Functions
          • JQLT Worklog Functions
          • JQLT Project Functions
          • JQLT Component Functions
          • JQLT Version Functions
          • JQLT Group Functions
          • JQLT User Functions
          • JQLT Date Functions
        • JQLT DC License
        • JQLT DC FAQ
        • JQLT DC Known Issues
        • JQLT DC Performance
      • JQL Tricks Cloud Migration
    • Simplified Planner
      • J-Planner Installation
      • J-Planner Configuration
      • J-Planner Usage
        • Creating a plan
        • Editing a plan
        • Deleting a plan
        • Viewing a plan
        • Modifying a plan
      • J-Planner FAQ
    • Atla-Search Plugin
      • Atla-Search Installation
      • Atla-Search Configuration
      • Atla-Search Usage
      • Atla-Search License
      • Atla-Search FAQ
    • Heroku for Compass App
      • Heroku for Compass Installation
      • Heroku for Compass Configuration
      • Heroku for Compass Usage
    • Copy to subtask Plugin
    • All Plugins
  • Tutorials
  • The Book
  • Contact Us
  • Home
  • Plugins ↓
    • JQL Tricks Plugin
      • JQL Tricks Plugin - Cloud
        • JQLT Cloud Installation
        • JQLT Cloud Configuration
        • JQLT Cloud Usage
        • JQLT Cloud License
        • JQLT Cloud FAQ
      • JQL Tricks Plugin - DC
        • JQLT DC Installation
        • JQLT DC Configuration
        • JQLT DC Usage
          • JQLT Issue Functions
          • JQLT Subtask Functions
          • JQLT Links Functions
          • JQLT Development Functions
          • JQLT Worklog Functions
          • JQLT Project Functions
          • JQLT Component Functions
          • JQLT Version Functions
          • JQLT Group Functions
          • JQLT User Functions
          • JQLT Date Functions
        • JQLT DC License
        • JQLT DC FAQ
        • JQLT DC Known Issues
        • JQLT DC Performance
      • JQL Tricks Cloud Migration
    • Simplified Planner
      • J-Planner Installation
      • J-Planner Configuration
      • J-Planner Usage
        • Creating a plan
        • Editing a plan
        • Deleting a plan
        • Viewing a plan
        • Modifying a plan
      • J-Planner FAQ
    • Atla-Search Plugin
      • Atla-Search Installation
      • Atla-Search Configuration
      • Atla-Search Usage
      • Atla-Search License
      • Atla-Search FAQ
    • Heroku for Compass App
      • Heroku for Compass Installation
      • Heroku for Compass Configuration
      • Heroku for Compass Usage
    • Copy to subtask Plugin
    • All Plugins
  • Tutorials
  • The Book
  • Contact Us

JQL Tricks DC - Date Functions

Return Type: DATE

lastLoginOf
sprintStartDateOf
sprintEndDateOf
versionStartDateOf
versionEndDateOf
lastLoginOf
lastLoginOf(user)

Function to compare dates with last login time of a specific user. Similar to standard lastLogin() JIRA function except that this function compares with last login of given user as opposed to the current user. See JQLT-70 for details.

Since : v4.1

Usage/Examples:
  • created > lastLoginOf("test") - Returns all issues that were created after user "test" last logged in!
  • status changed to Closed after lastLoginOf("test") - Returns all issues that are Closed after user "test" last logged in.
sprintStartDateOf
sprintStartDateOf(sprintName, [boardName])

Function to return the start date of a given sprint. An optional board name can be passed when there are more than one sprints with the same name.

Since : v7.1

Usage/Examples:
  • created > sprintStartDateOf("Sprint 1") - Returns all issues that were created after "Sprint 1" was started.
  • created > sprintStartDateOf("Sprint 1", "Board One") - Returns all issues that were created after "Sprint 1" on "Board One" was started. If your sprint appears in more than one board, due to its stories appearing in multiple boards, you need to use the name of the board on which the sprint was originally created. JIRA always tags the sprint to the board on which it was originally created although the sprint will appear in other boards when the issues are shared between boards.
sprintEndDateOf
sprintEndDateOf(sprintName, [boardName])

Function to return the end date of a given sprint. An optional board name can be passed when there are more than one sprints with the same name.

Since : v7.1

Usage/Examples:
  • created > sprintEndDateOf("Sprint 1") - Returns all issues that were created after "Sprint 1" was ended.
  • created > sprintEndDateOf("Sprint 1", "Board One") - Returns all issues that were created after "Sprint 1" on "Board One" was ended. If your sprint appears in more than one board, due to its stories appearing in multiple boards, you need to use the name of the board on which the sprint was originally created. JIRA always tags the sprint to the board on which it was originally created although the sprint will appear in other boards when the issues are shared between boards.
versionStartDateOf
versionStartDateOf(versionName, [projectName])

Function to return the start date of a given version. An optional project name can be passed when there are more than one versions with the same name.

Since : v7.1

Usage/Examples:
  • created > versionStartDateOf("Version 1") - Returns all issues that were created after "Version 1" was started.
  • created > versionStartDateOf("Version 1", "Project One") - Returns all issues that were created after "Version 1" on "Project One" was started.
versionEndDateOf
versionEndDateOf(versionName, [projectName])

Function to return the end date of a given version. An optional project name can be passed when there are more than one versions with the same name.

Since : v7.1

Usage/Examples:
  • created > versionEndDateOf("Version 1") - Returns all issues that were created after "Version 1" was ended.
  • created > versionEndDateOf("Version 1", "Project One") - Returns all issues that were created after "Version 1" on "Project One" was ended.

SUPPORT
APPS
TUTORIALS
THE BOOK
© J-Tricks