Script Runner Workflow Validator Inline Script which Table in Database ?

[Hans Pesata]

Hi!

Jira Server 8.5.2, Adaptavist Script Runner 6.53.0

We are using Inline Groovy Scripts within Workflow Validator/Post Functions.

From what I read, these scripts are stored in the Database and We need to know where, to find all of them without opening every Validator in every Workflow ...

https://confluence.atlassian.com/jirakb/list-of-jira-server-ao-table-names-and-vendors-973498988.html

This is the link I found, but it doesnt provide what We need.

Thanks in advance for any hint!

Regards,
Hans

[Andy Heinzer]

I think what you want here is the Scriptrunner JQL function called linkedIssueOf.  With this query I believe it can limit the results of what you want here.  I think the syntax would look something like this:

issueFunction in linkedIssuesOf("project=ABC", "blocks")

With this query, you are only returning the issues that have a 'blocks' link to issues in the ABC project.

[James Brown]

While the query returns issues containing issues that contain blocks issue links, all links regardless of link type will be displayed in the linked issues field/column.

I need the ability to filter out any links that are not blocks from the linked issues column.

If there is one issue and it contains two link issues. One issue blocks and one issue relates, I want the links field to display only the link to the issue that block and not the issue that relates.