Script runners Parent Issue Script Field JQL searches.

[Gaj Umapathy]

Hi,

When using the 'Parent Issue Script Field' from Script runner. Let's say we have a Parent issue field called 'Feature Link'. It is not possible to search in JQL to find all issues where this field is NOT empty.

"Feature Link" is not EMPTY

The operator 'is not' is not supported by the 'Feature Link' field.

Should this work? Also is it possible to make use of the JQL function portfolioParentsOf when using the 'Parent Issue Scripted Field' without having Jira Portfolio?

Cheers,

Gaj

[Konstantin Kozlov · Accepted solution]

Curiously to find all issues with non empty SR's parent link I found that you can use "not in" with any string that looks like a issue.
Even like: 

"Feature Link" not in (COVID-19)

[Ivan Tovbin]

That's because 'Feature' is an issue type and not the name of the field, at least judging by your description. A correct JQL would look something like this:

issuetype = Feature and <custom field name> is not empty

[Gaj Umapathy]

Okay, to avoid confusion with the issue type called 'Feature', let's say the scripted field is called 'Feature Link' . 

[Ivan Tovbin]

issuetype = Feature and "Feature Link" is not empty

[Gaj Umapathy]

Thanks Ivan. So this is mainly a question for someone from Adaptavist Script Runner.  I know how to do the JQLs but it's not working. 

So The 'Feature Link' is a scripted field that shows the parent issue of any issue type 'Feature' where the it has a 'Feature' like link. So I would see the 'Feature Link' field on a Story issue type or an Epic issue type.

I can say 'Feature Link' = ISSUE-KEY and it gives me the list of stories, epic requirements and anything else that is linked to this Feature. This works fine.

However, the 'is not empty' search doesn't work. The search template used is 'Searcher:  Issue Key Searcher'. 

[Ivan Tovbin]

Ah, I got a bit confused. So the question is how to search for issues with an empty custom field which has its searcher set to 'Issue Key Searcher'.

[Gaj Umapathy]

That's right. 

[Ivan Tovbin]

Have you tried changing the searcher to 'Free text searcher'? Or that somehow goes against your process logic?

[Gaj Umapathy]

Yes... but you need it to be the template with issue key searcher otherwise the field will display

$(value.key} 

[Alexey Matveev]

I just checked searchers and I could not see any difference with a field display. Could you give more details.