Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to display a field in JQL

David Glick
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 29, 2023

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”

2 answers

1 vote
Trudy Claspill
Community Champion
June 29, 2023

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

0 votes
Alexander Pappert
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 30, 2023

try summary ~ "abc"

Suggest an answer

Log in or Sign up to answer