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; } } }

Groovy Script to validate data in text fields

Venkata Nagamothu

Hi All,

I have text field in Jira called 'Project'.. Likewise , I had a table in Confluence with one of columns as name 'Project' .

So, when users enter data in the field 'Project' it should validate the data in column from Confluence page .. If data in field 'Project' is not available in Confluence table column 'Project' ticket should not be created..

Any scripts or references are much appreciated.. Please reach back to me in case of unclear requirement so I can eloborate in detail..

Thanks,

Venkat

Accepted answers

All comments

PD Sheehan

Here is a sample script that should get you started in the correct direction:

import groovy.json.JsonSlurper
import com.atlassian.jira.applinks.JiraApplicationLinkService
import com.atlassian.applinks.api.application.confluence.ConfluenceApplicationType
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.sal.api.net.Request
import org.jsoup.Jsoup

def confluenceLink = ComponentAccessor.getComponent(JiraApplicationLinkService).getPrimaryApplicationLink(ConfluenceApplicationType)
def conflUrl = confluenceLink?.displayUrl

def pageId = 325059187 //put your own
def request = confluenceLink.createAuthenticatedRequestFactory().createRequest(Request.MethodType.GET, "$conflUrl/rest/api/content/$pageId?expand=body.storage")

def pageJson = request.execute() as String
def pageBody = new JsonSlurper().parseText(pageJson)['body']['storage']['value'] as String

def doc = Jsoup.parse(pageBody)
def table = doc.select('table')[0]
def headers = table.select('th').collect{it.text()}
def rows = table.select('tr').drop(1).collect{row->
    def rowMap =[:]
    row.select('td').eachWithIndex{col, i->
        rowMap[headers[i]] = col.text()
}
    rowMap
}

def testProject = 'AAABC'
def projectColHeader = 'Project'
assert testProject in rows.collect{it[projectColHeader]}

This will

Get the application link for confluence
Fetch a page (given it's ID) using the application link
Parse the json string into an object
Extract the storage representation of the page body from the object
Parse the content using Jsoup
Find the first table (index 0)
Gather the headers from the table
Gather all the other rows from the table and gather them as maps with keys matching the corresponding header. This will probably fail if you have merged cells
Test a sample project key against the list

From there, you should be able to find other references for how to get your project field and use that to compare against the extracted table data.

Venkata Nagamothu

Hi Peter,

I was able to get Third Columns which is description in Confluence Table and not able to read the First Column 'Project'

Also, I was not able to insert these values into field in Jira

Your response is much appreciated

Thanks,

Venkata

PD Sheehan

Can you share a sample of what your page/table looks like in its storage format?

Venkata Nagamothu

Thanks Peter for the response!

As per above Screenshot of Confluence Table.. We are looking to have Project Key(Test123, TEST456 etc..) into a Jira Field called "Project Key".. Either Scripted Field which populates data from Confluence or Workflow or Field Validator so when user enter data it should be text same as "Project Key" Column in Confluence Table else request/ticket should not be created.

Let me know if need any further information from my end

Thanks,

PD Sheehan

Seeing your table screenshot, I replicated your table.

Viewing the storage format of that page would still be helpful in cases there is other xml that might interfere with the jsoup parsing.

Here is what happen on my instance after I re-created a page that looks like yours:

2022-07-21 09_37_30-table page - Peter-Dave Sheehan - Confluence Test.png

Here is a successful result

2022-07-21 09_36_59-Script Console.png

And here is a failure result

2022-07-21 09_36_34-Script Console.png

Venkata Nagamothu

Peter,

Is it possible to provide your email address? Also, let me which one are you using Workflow validator for the field or Scripted Field.? How to clear the error that "Assertion Failed"

Let me know if I am missing anything

Thanks

PD Sheehan

I'm only using the console as a means of doing a proof of concept.

You asked for sample scripts and references. I gave you a sample script that can read a table from a confluence page.

You will have to do some work on your side to understand what the script is doing and modify it according to your business case. and integrate it with your workflow.

If you are not able to make those modifications you should hire someone that can. Implementing a script supplied from a forum without understanding what it does and being able to manipulate it is a dangerous proposition.

I share my groovy knowledge voluntarily. It's not part of my job. So no, I will not be sharing my email address.

As for helping you further, I've requested a sample of the storage format of your confluence page twice. Knowing exactly what the text in the page looks like is critical to being able to parse the content correctly.

The fact that your assert statement is returning a bunch of null values tells me that either 1) the column header is not exactly "Project Key" (perhaps there are some extra space or other non-printing characters) or 2) the Project Key column is not actually aligned directly above the project key values (perhaps because of some merged cells).

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-software

adaptavist

jira-software-server

groovy