Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Scriptrunner: How to access raw JQL query in custom JQL aggregate function

Edited

If we get as example com.onresolve.jira.groovy.jql.AggregateExpression, it has method com.onresolve.jira.groovy.jql.AggregateExpression#getAggregateData but that call happened only from com.onresolve.scriptrunner.runner.rest.jira.JqlFunctionsEndpoint#getAggregateResult which source is not available unfortunately. And according to jqlQueryDoc.js endpoint /rest/scriptrunner-jira/latest/jqlfunctions/aggregateResult is hardcoded.

In my own function in implementation of com.onresolve.jira.groovy.jql.JqlFunction#validate method I have access only to TerminalClause instance which have no access to full JQL query.

I have abbility implement com.onresolve.jira.groovy.jql.JqlQueryFunction#getQuery, but there I can't emmit some validation errors or warnings about query parsing.

My intention write my custom aggregate query with grouping (question related to https://community.atlassian.com/t5/Marketplace-Apps-questions/ScriptRunner-How-to-custom-extend-aggregate-JQL-function/qaq-p/757436) and I want:
1. Got full JQL query. Current possible approach make it just as string argument of function, but it is not so flexible for user to write it without suggestion and autocomplete.
2. Have possibility return additional aggregation results and/or parsing errors.
2.1. Agregation results required to return additional table data if query correct. I want make summaries grouped by assignee for example.
2.2. If query incorrect on terms of function I want also notify user about it.

On first look it seams I need at least method validate which holds full query like:

MessageSet validate(ApplicationUser user, FunctionOperand operand, TerminalClause terminalClause, String rawQuery)

Is it possible now?

1 answer

Hi Pavel,

com.onresolve.scriptrunner.runner.rest.jira.JqlFunctionsEndpoint#getAggregateResult is a REST endpoint: ScriptRunner includes some front-end Javascript in the Issue Navigator which captures the JQL entry that has been entered in the search box and sends it to that endpoint. Hope this clears things up and gives you some ideas of how to implement similar functionality yourself.

Joanna Choules, Adaptavist Product Support

How I can write aggregate function and capture full JQL? You do not answer question. Is it possible with ScriptRunner?

Hi Pavel,

As I mentioned in my original answer, the full JQL is captured with Javascript on the front end and passed to a custom endpoint, which - as you observed - is responsible for invoking the AggregateExpression function.

Custom Javascript can be added to the front end using a Web Resource, and ScriptRunner also allows you to set up custom endpoints. There are many Javascript tutorials available online that describe how to get the value from an HTML text box, and how to perform a call to a REST endpoint.

Joanna

Like Hubbitus likes this

Thanks, I'll try to send that value himself from JavaScript. But it will be much more convenient if ScriptRunner will provide possibility just write aggregate wunctions, without handle such mess.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across Jira Cloud instance.   📢 Get y...

163 views 7 8
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you