How can I determine which JIRA JQL filter uses a specific variable.

Kevin Mahoney

I have multiple users across my organization's enterprise that use the IssueFunction in linkedIssuesOf(Subquery, [link name]). We've updated our ScriptRunner version that now uses IssueFunction in linkedIssuesOfAll(Subquery, [link name]). 

Is there a way that I can tell what filters in my organization use the old IssueFunction version and or better yet replace those with the new version?

Tiffany Wortham

This script works for me, but try this on a test instance first to make sure it works as expected for you. Additionally, you'll want to back up your production instance before trying this on there as well just to be sure everything can be recovered if things go south.

That being said, just pop this in the script console, and it should change all of the filters with linkedIssuesOf to linkedIssuesOfAll:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchRequest
import com.atlassian.jira.issue.search.SearchRequestEntity
import com.atlassian.jira.issue.search.SearchRequestManager
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.atlassian.jira.util.Visitor

def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser)
def searchRequestManager = ComponentAccessor.getComponent(SearchRequestManager)
def userManager = ComponentAccessor.getUserManager()

searchRequestManager.visitAll(new Visitor<SearchRequestEntity>() {
@Override
    void visit(SearchRequestEntity searchRequestEntity) {
def requestString = searchRequestEntity.request
        if (requestString.contains("linkedIssuesOf(")){

def newRequestString = requestString.replaceAll(~/\blinkedIssuesOf\b\(/, "linkedIssuesOfAll(")

def owner = userManager.getUserByName(searchRequestEntity.author)
def query = jqlQueryParser.parseQuery(newRequestString)
def name = searchRequestEntity.name
            def description = searchRequestEntity.description

            def newRequest = new SearchRequest(query, owner, name, description, searchRequestEntity.id, searchRequestEntity.favCount)
            searchRequestManager.update(newRequest)
        }
    }
})

Sorry this took me a while, let me know if you have any questions!