Convert issue search URL into the search request

[Andrey Kiyanovsky]

Hi Fidel,

I'm looking for the opportunity to convert JIRA search request URLs, like:

https://track.namecheap.net/issues/?jql=project%20in%20(ATL)

into

project in (ATL)

to use the string in JQL post-functions.

Is it possible?

Thank you in advance, AK.

[Fidel Castro Armario]

Hi Andrey,

You can do it using post-function "Copy a parsed text to a field" with the following configuration:

Text to be parsed is:

"project in (" + replaceFirst(%{11300}, "^.*\\(", "")

In the example the URL is originally in My URL custom field (field code %{11300}), and is transformed into an equivalent JQL query after post-function execution.

[Andrey Kiyanovsky]

It doesn't work. Example:

Field "Tasks" (multiline) has value: https://track.namecheap.net/issues/?jql=issuekey%20%3D%20API-21

After mentioned post-function it is: project in (https://track.namecheap.net/issues/?jql=issuekey%20%3D%20API-21

I'd like to have the following result: https://track.namecheap.net/issues/?jql=issuekey = API-21

where all EncodeURL symbols replaced with original symbols. My final goal is to have a string "issuekey = API-21" to use it in JQL post-functions.

[Andrey Kiyanovsky]

So my algorithm is the following: - convert %XX symbols to original symbols - cut leading "https://track.namecheap.net/issues/?jql=" - get the resulting "issuekey = API-21"

[Fidel Castro Armario]

Hi Andrey,

In your first URL (https://track.namecheap.net/issues/?jql=project%20in%20(ATL)) you wanted to get a project key, but in the other examples you want to get an issue key.

For getting an issue key you can use the following text to be parsed:

"project = " + first(findPattern(%{11300}, "[A-Z]+-\\d+$"))

[Andrey Kiyanovsky]

Fidel,

sorry for misleading. I'd like to have universal decode, disregard of search URL. So Search URL might be any.

[Fidel Castro Armario]

Hi Andrey,

Try using this text to be parsed:

replaceAll(replaceAll(replaceAll(replaceFirst(%{11300}, "^.*jql=", ""), "%20", " "), "%3D", "="), "%22", "\"")

That text supports encoding the following characters: %20 (space), %3D (=) and %22 (").

You can add other characters following the obvious pattern of the expression. I will add a new function to the parser in next version of the plugin, so that we can write an expression that supports any encoded character.

[Andrey Kiyanovsky]

Hi Fidel,

yes, this straightforward method will work, but I'm not aware of all converted characters, so it's error-prone. This time I got away with ScriptRunner custom scripted post-function, but I'd really appreciate if you implement decoding.

Thanks a lot, AK.

[Fidel Castro Armario]

Hi Andrey,

You can format any URL using "Copy a parsed text to a field" post-function in advanced parsing mode with the following text expression:

findModify(%{nnnnn}, "%[A-Fa-f0-9]{2}", getAscii(toInteger(substring(^%, 1, 3), 16)))

replacing nnnnn with the field code of the field where the URL is stored.

To use this solution you have to install version 2.2.12_beta_7.

[Andrey Kiyanovsky]

Fidel, it works!

Thank you very very much!

Best regards AK.

[Fidel Castro Armario]

Implemented in just released version 2.2.12.