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 Release Notes 7.0

New Development Functions

JQLT 7.0 introduces the following development functions. These functions are a wrapper on the existing JIRA functionality and intends to make it easier for users to search based on commits, reviews, pull requests etc.
  1. hasCommits: Finds out issues that have commits associated with it. Following are some examples:

    issue in hasCommits() - Finds out issues that have commits associated with it
    issue in hasCommits(2) - Finds out issues that have 2 commits associated with it
    issue in hasCommits(2, ">") - Finds out issues that have more than 2 commits associated with it
  2. hasReviews: Finds out issues that have reviews associated with it. Following are some examples:

    issue in hasReviews() - Finds out issues that have reviews associated with it
    issue in hasReviews(2) - Finds out issues that have 2 reviews associated with it
    issue in hasReviews(2, "<") - Finds out issues that have less than 2 reviews associated with it
  3. hasOpenReviews: Finds out issues that have open reviews associated with it. Following are some examples:

    issue in hasOpenReviews() - Finds out issues that have open reviews associated with it
    issue in hasOpenReviews(2) - Finds out issues that have 2 open reviews associated with it
    issue in hasOpenReviews(1, ">") - Finds out issues that have more than 1 open review associated with it
  4. hasPRs: Finds out issues that have pull requests associated with it. Following are some examples:

    issue in hasPRs() - Finds out issues that have pull requests associated with it
    issue in hasPRs(2) - Finds out issues that have 2 pull requests associated with it
    issue in hasPRs(2, ">") - Finds out issues that have more than 2 pull requests associated with it
  5. hasOpenPRs: Finds out issues that have open pull requests associated with it. Following are some examples:

    issue in hasOpenPRs() - Finds out issues that have open pull requests associated with it
    issue in hasOpenPRs(2) - Finds out issues that have 2 open pull requests associated with it
    issue in hasOpenPRs(2, ">") - Finds out issues that have more than 2 open pull requests associated with it
  6. hasFailingBuilds: Finds out issues that have failing builds associated with it. Following are some examples:

    issue in hasFailingBuilds() - Finds out issues that have failing builds associated with it
    issue in hasFailingBuilds(2) - Finds out issues that have 2 failing builds associated with it
    issue in hasFailingBuilds(1, ">=") - Finds out issues that have at least one failing build associated with it


More Functions!

JQLT 7.0 introduces more useful functions.These are some of the most frequently requested functions.
  1. commentedBeforeDate: This function is similar to the commentedAfterDate. It finds issues on which a comment was added before the given date. The function also supports relative dates. Following are some examples:

    issue in commentedBeforeDate("2010/10/25") - Returns all the issues on which comment was added before Oct 25th 2010.
    issue in commentedBeforeDate("-1d") - Returns all the issues on which comment was added before yesterday.
    issue in commentedBeforeDate("-1d"."someguy") - Returns all the issues on which comment was added by user "someguy" before yesterday.

    You can use the same function to find issues in which comment was updated before a date. You just need to pass "UPDATE" as the last argument.

    issue in commentedBeforeDate("-1d", "UPDATE") - Returns all the issues on which comment was updated before yesterday.

    issue in commentedBeforeDate("-1d"."someguy", "UPDATE") - Returns all the issues on which comment was updated by user "someguy" before yesterday.
  2. archivedVersions: Returns issues that are in archived versions. Following are some examples:

    fixversion in archivedVersions() - Returns all issues with fixVersions that are archived.
    fixversion in archivedVersions("TEST") - Returns all issues from TEST project with fixVersions that are archived.
  3. projectMatches: Returns issues in projects with a name matching the given regex. Following are some examples:

    project in projectMatches("TE.*") - Returns all issues from projects that has name starting with "TE". For example: TEST, TESTER etc.

Improved Functions

In addition to the new functions, JQLT 7.0 also has made significant improvements to existing functions
. Following are the highlights:
  1. hasSubtasks: The hasSubtasks function now takes a Query parameter to limit the number of results returned. It improves the performance when compared with the earlier option of combining different JQL clauses with the old hasSubtasks function.

    The order of parameters is count, subtasktype, query. Following are some examples:

    issue in hasSubtasks("Sub-task")
    issue in hasSubtasks(2, "Sub-task")
    issue in hasSubtasks("Sub-task", "project = DEMO")
    issue in hasSubtasks(2, "Sub-task", "project = DEMO")
    issue in hasSubtasks(2, "project = DEMO")

    NOTE: In the earlier versions, hasSubtasks method took the count as second parameter but it is now changed to the first parameter to ensure consistency across all functions. This might break some existing filters but will be better in the long run.
  2. inactiveUsers: The inactiveUsers function now takes the directory order into account. It will consider a user as active as long as the user is active in the top most directory, just like JIRA does. This fixes a bug in the earlier versions!
  3. usersInRole: The usersInRole function's project parameter is now optional. If the project is missing, it returns users from that role in any project. For example:
    reporter in usersInRole("TEST","3rd Line") - Returns issues reported by users in "3rd Line" role in the TEST project
    reporter in usersInRole("3rd Line") - Returns issues reported by users in "3rd Line" role in any project


Epic Name and Epic Link names are no configurable

If you are using a different language in your JIRA instance, it is possible that the name the Epic issue type is not "Epic" It could be "Epos". Or something else. Similarly the "Epic Link" could be named something else too.

JQLT now allows an administrator to configure the names under Administration > Add ons > JQL Tricks Config, as shown below:


Picture

Modified Admin User Interface

Administration screens in JQLT 7.0 uses the latest AUI designs. Helps to keep the admin experience same across JIRA administration screens.

Bug Fixes

On top of all these wonderful features, JQLT 7.0 also fixes a number of bugs reported by the customers.

SUPPORT
APPS
TUTORIALS
THE BOOK
© J-Tricks