Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Index the custom field in JQL

Fix versions

Priority

Description

In the past, we've created a function for JQL: https://documentation.play-sql.com/display/RY/JQL+Syntax

Unfortunately, it doesn't work in a satisfying manner, and we didn't find the correct API at the time. Now we've found it.

New syntax

Searching directly on the field will be possible:

"RY Custom Field" = 'REQ-001' # This one will search for this requirement in any baseline "RY Custom Field" ~ 'REQ-%' "RY Custom Field" IN ('REQ-001', 'REQ-002', 'REQ-003') "RY Custom Field" IS NOT EMPTY "RY Custom Field" IN requirements('REQ-%') # Searches for links with or without baseline "RY Custom Field" IN requirements('REQ-%', 'CURRENT') "RY Custom Field" IN requirements('REQ-%', 23) # The baseline number # Note: There will be no ability to search with the space key or the name of the Confluence instance.

Drawbacks

  • Only works for Jira 8. Unfortunately, users of Jira 7.13 LTS (published 28 November 2018) have support until November 2020.

  • We'll have to pass the DC tests again,

  • We'll then leave this for a major RY release,

  • Existing customers will have to migrate from the JQL function to simply using the field, but they will be quite happy with that...

My apologies

Dear customers,

Please accept my apologies for not finding the right API straight away. I'm sorry that I required you to use the old syntax for so long.

Best regards,
Adrien Ragot

Activity

Show:
Resolved

Details

Assignee

Reporter

Requirement Yogi

Created August 21, 2020 at 9:29 AM
Updated August 26, 2020 at 4:38 PM
Resolved August 26, 2020 at 4:38 PM