How to display a field in JQL

Question

In an SQL select statement, you specify field names to display followed by WHERE clauses to filter the selected data.

in JQL, it seems you just add filters like:

project = “proj1” and assignee = “usera”

How can I just display a field like summary in a JQL query?  Something like:

project = “proj1” and summary

This does not work since Jira expects an operator and value after “summary”

Alexander Pappert · Answer

try summary ~ "abc"

Trudy P Claspill · Answer

Hello @David Glick

Welcome to the Atlassian community.

JQL is not used to specify the fields you want to show. JQL is used only to retrieve the issues.

You can use the List view on the Search screen to display the output of the search a table where there is a row for each issue and the columns are the fields. You can then specify which columns you want to display.

Refer to this page for more information.

https://confluence.atlassian.com/jirasoftwareserver/working-with-search-results-939938808.html