How to list column from a table using issueFunction in linkedissuesof

[José Agnaldo B_ de Sousa]

Hi, would like to list a column "Customer Reference" from the sql bellow. This column is not part of my main table.

Thanks in advice.

category in (Support) AND status not in (Done, "Closed for Planning") AND issueFunction in linkedissuesof("\"Customer Reference\" is not EMPTY and Status NOT IN ('Question to Customer', 'Waiting customer acceptance','Closed') ") AND issuetype = "Incident Task" ORDER BY key ASC, summary ASC, Rank ASC

[Marc -Devoteam- · Accepted solution]

HI @José Agnaldo B_ de Sousa 

With ScriptRunner for Jira Cloud you cannot use issueFunction in the native locations where JQL can be used. Instead you need to go to the Enhanced Search screen that is available from the Apps menu.

Function of JQL options of scriptrunner return issue based on the used clause. These are not fields that can be shown in a column.

[José Agnaldo B_ de Sousa]

Hi, thank you for your response.

I am using advanced search:

My question is how to list a column that is in other "table". In the example below the column is on Key 1.

[Marc -Devoteam-]

Hi @José Agnaldo B_ de Sousa 

You can't searching in JIra get you issues with able to set fields a columns to show infromation.

The function from scriptrunner that you use searches issues based on the clause used.

[José Agnaldo B_ de Sousa]

Thank you