nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Select List Conversion filtering

Mark Markov

Hello dear@Thanos Batagiannis _Adaptavist_ , @Daniel Yelamos [Adaptavist], @Roland Holban (Adaptavist)

I've encountered problem with select list conversion. Results in list highlighted but not filtered.

As i can see screenshots in this instruction (which i followed), result should be filtered, but it is not.

Here is the code of rest endpoint:

import com.atlassian.jira.web.bean.PagerFilter
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.search.SearchProvider
import com.atlassian.jira.jql.parser.JqlQueryParser
import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.json.JsonBuilder
import groovy.transform.BaseScript
import ru.raiffeisen.main.helpers.ConstantsHelper

import javax.ws.rs.core.MultivaluedMap
import javax.ws.rs.core.Response

@BaseScript CustomEndpointDelegate delegate

getTemplates(httpMethod: "GET") { MultivaluedMap queryParams ->
    def query = queryParams.getFirst("query") as String
def user = ComponentAccessor.jiraAuthenticationContext.getLoggedInUser()
def rt = [:]
def jqlQuery = "project = \"TEST\" and status = In Progress"
    def issueManager = ComponentAccessor.issueManager
    def jqlQueryParser = ComponentAccessor.getComponent(JqlQueryParser.class)
def searchProvider = ComponentAccessor.getComponent(SearchProvider.class)

def query1 = jqlQueryParser.parseQuery(jqlQuery)
def results = searchProvider.search(query1, user, PagerFilter.unlimitedFilter)
def customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectsByName("text custom field").first()
def templateList = results.issues.collect { issue-> issueManager.getIssueObject(issue.id).getCustomFieldValue(customField) }.findAll {it != null}
    rt = [
items : templateList.collect { String row ->
                [
value: row,
html: row.replaceAll(/(?i)$query/) { "<b>${it}</b>" },
label: row,
                ]
            },
total: templateList.size(),
footer: "Choose template... "
    ]
    return Response.ok(new JsonBuilder(rt).toString()).build();
}

And behaviour:

getFieldByName("Template").convertToSingleSelect([
ajaxOptions: [
url           : getBaseUrl() + "/rest/scriptrunner/latest/custom/getTemplates",
query         : true, // keep going back to the sever for each keystroke
                // this information is passed to the server with each keystroke
                formatResponse: "general"
        ],
])

May be I am missing something common?

I ve tested it on Jira v7.2.15 and Scriptrunner versions: 5.2.2, 5.4.28

and Jira v7.8.1, SR v5.4.28

Thanks in advance!

Accepted answers

Thanos Batagiannis _Adaptavist_

Hi Mark,

You will need to do the filtering in your rest end point.

So, for a case insensitive search, you will need something like

def templateList = results.issues.collect { issue-> issueManager.getIssueObject(issue.id).getCustomFieldValue(customField) }.findAll {it != null} as List<String>

rt = [
items : templateList?.findAll { it.toLowerCase().contains(query?.toLowerCase())}?.collect { row ->

    // rest of the script
}

That should do the trick, ping me if it doesn't

Kind regards,

Thanos

All comments

Thanos Batagiannis _Adaptavist_

Hi Mark,

You will need to do the filtering in your rest end point.

So, for a case insensitive search, you will need something like

def templateList = results.issues.collect { issue-> issueManager.getIssueObject(issue.id).getCustomFieldValue(customField) }.findAll {it != null} as List<String>

rt = [
items : templateList?.findAll { it.toLowerCase().contains(query?.toLowerCase())}?.collect { row ->

    // rest of the script
}

That should do the trick, ping me if it doesn't

Kind regards,

Thanos

Mark Markov

Many thanks, @Thanos Batagiannis _Adaptavist_!

It works perfect!

As i noticed, for all time that i work with scriptrunner plugin, many useful things just not described in documentation, like this for example or for setFormValue have examples only for selectlists and textfields and for dates, userpickers, grouppickers need some R&D actions from users.

In my opinion behaviours very poorly documented, I am using Idea and see so many methods in behaviour api, which are not described. It will be great to do JavaDoc for them.

So i have one question.

Do Adapatavist have plans on improving documentation?

Thanos Batagiannis _Adaptavist_

Hi Mark,

Glad that we made it work.

I hear you and you are right. The thing is that ScriptRunner abilities are endless and no kind of 'traditional' documentation can cover all the cases.

So right now we are working into 2 major areas

The first one is to improve our "traditional" documentation - in progress

The second one is a way to share scripts with the public in a better way than just examples in the documentation - in progress

Regarding the select list conversion issue itself, we are also working in a solution that will make it much more easier and more flexible.

Kind regards and thanks a lot for the feedback,

Thanos

IT User Support

I have problem on setting default value on user picker on customer portal. I think I need this one. can you help? @Mark Markov

SWAPNIL SRIVASTAV

Hello @Mark Markov and @Thanos Batagiannis _Adaptavist_

I need to implement something like this:

I want to create a select list field for a particular project with options which appear on screen as:

and the no. of options should be same as the no. of issues in that particular project.

Could you please help.

Thanks and Regards,

Swapnil Srivastav.

Maikes

@Thanos Batagiannis _Adaptavist_ , I have the same issue as @Mark Markov , but with diferent porpose as well as diferent code, isn't for a issue but for a request.

Could you help me also?

Regards

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira

adaptavist

addon-com.onresolve.jira.groovy.groovyrunner

jira-server