How to Enable Detailed JQL Logging in JIRA

Purpose

This KB article instructs how to enable detailed JQL logging inside of JIRA. This can be used for any of the following:

  • Understanding what JQL is submitted for different actions (such as gadgets, JIRA Software boards and so on)
  • Reverse-engineering GUI actions to determine what JQL is submitted for certain user actions or searches

Solution

  1. Log into JIRA as an Administrator.
  2. Go to Administration > System > Troubleshooting and Support > Logging and Profiling.

  3. Search for com.atlassian.jira.issue.search.providers and set it to DEBUG:

     

    (info) The resulting logs will be in <JIRA HOME>/log/atlassian-jira-sql.log.

 

These settings will be lost on restart, as they're stored in memory. To have JIRA persist the settings they can be changed in the log4j.properties file. For example:

log4j.logger.com.atlassian.jira.issue.search.providers = WARN, console, debug
Last modified on Aug 3, 2016

Was this helpful?

Yes
No
Provide feedback about this article

Not finding the help you need?

Ask the community

Powered by Confluence and Scroll Viewport.