Fixed an issue with movedIssuesFunction in Jira instances using MSSQL Server

Fixed issue with movedIssuesFunction on Jira instances with MSSQL Server

Datacenter Compatibility

JIRA 8 Compatibility

Fixed an issue with movedIssuesFunction in Jira instances using SQL Server

• New JQL functions
  • epicsWithIssues: Find Epics that has issues under it
  • sprintStartDateOf: Search using start date of a given sprint
  • sprintEndDateOf: Search using end date of a given sprint
  • versionStartDateOf: Search using start date of a given version
  • versionEndDateOf: Search using start date of a given version
  • componentLeads: Search using the component leads
  • workLoggedBy: Search issues on which work was logged by a specific user or users in a given group
• Fixed issue in hasSameValuesFunction
• Minor bug fixes

Added new Development Functions

• hasCommits
• hasReviews
• hasOpenReviews
• hasPRs
• hasOpenPRs
• hasFailingBuilds

More New functions

• commentedBeforeDate
• archivedVersions
• projectMatches

Improvements to existing functions:

• hasSubtasks
• usersInRole
• inactiveUsers

And bug fixes.

See http://www.j-tricks.com/jqlt-release-notes-70.html for details.

Performance Improvements on large instances

• Improved movedIssues() function with an option to restrict results based on project/issuetype and/or from and to values
• overDueVersions() - function to find issues in versions that are overdue - passed release date
• openVersions() - function to find issues in versions that does not have a release date
• projectMatches(regex) - function to find projects with matching name
• Minor bug fixes

Performance Enhancements

• Jira 7 Compatibility
• Marketplace Licensing - Hurray!

• Minor bug fixes
• Added option for JQL Query in hasLInks to limit the result set - issue in hasLinks([count],[link type],[query])

Minor bug fixes

• New functions (issuesWhereEpicIn and epicsWhereIssueIn) to query issues based on Epic links
• Multiple bug fixes

https://j-tricks.atlassian.net/browse/JQLT-130

https://j-tricks.atlassian.net/browse/JQLT-131

• Option to search comments based on edited user and/or date
• Improved hasSameValues function
• worklog functions accepts current user as a generic constant
• Minor bug fixes
  

Added new function to search issues with exact same fixVersions and affectedVersions. Also added a new function to compare dates beased on last login of a given user instead of current user.

See Release Notes for details.

- Global and Function configuration

- Functions can be restricted to selected groups overriding the global configurations

- JQLT Functions now has its own cache, overriding global cache delay

- New function to filter users based on timezone

- New function to filter inactive users

- Improved function to find versions released before or after a specific or relative date

- New function to find moved issues

- Bug fixes

Updated for 5.1. Please see the other changes in 3. version below:

• All Date functions now accepts dynamic as well as absolute dates. Dynamic dates uses y for year, w for weeks, d for days, h for hours, m for minutes.
• hasLinks function now takes an optional count parameter as well
• There is now a new link function that finds linked issues based on a JQL Query
• There is now a new link function that finds linked issues based on a saved filter
• There is a new function to find issues where a comment is added after a date.

• Added Search for Nth unReleased version
• Ability to search worklog relative to today
• Fixed issue during Anonymous search

Fixed the following bugs:

https://studio.plugins.atlassian.com/browse/JQLT-32

https://studio.plugins.atlassian.com/browse/JQLT-30

Added 2 new functions versionMatches and componentMatches

https://studio.plugins.atlassian.com/browse/JQLT-31

• Jira 5.0 Compatibility
• Ability to restrict plugin functionality to selected groups
• Ability to restrict individual JQL Functions to selected projects
• New functions
• Performance Improvements

See Release Notes for details!

Jira 4.4 Compatiablity and minor bug fixes

JQLT-15, JQLT-16 and JQLT-17

Two new functions:

1. https://studio.plugins.atlassian.com/browse/JQLT-7 - componentsFromProject function to return all components with the same name as that of components in a given project.
2. https://studio.plugins.atlassian.com/browse/JQLT-14 - projectWithUserInRole function to return all projects where the specified user is in a role. If no user entered, currentUser is used.

And bug fixes for MSSQL users : https://studio.plugins.atlassian.com/browse/JQLT-12

Following functions added:

• hasSubtasks([subtskType])
• inkedIssuesInVersionByName(versionName,[linkType])
• linkedIssuesInComponentByName(projectName, componentName, [linkType])

Bug fixes to handle hasLinks function in Jira instances where number of issues is more and uses Oracle or MSSQL databases.

Added new set of JQL Functions:

• commentedByUser([User])
• commentedOnDate(date)
• attachedByUser([User])
• hasNumberValue(Field, Operator, Value)
• parent(JqlQuery)
• subtask(JqlQuery)
• versionsAfter(versionId)
• versionsBefore(versionId)
• userMatches(regex)
• groupMatches(regex)

Also major performance enhancement more than 50% in few functions like hasLinks.

Initial Release for JQL Tricks plugin.