Return Type: DATE

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(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(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(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(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.