JQL Search Page

JQL Search Page

Build and run SnapJQL queries with fresh results

Write, test, and explore SnapJQL queries in a visual search interface, with a function explorer, live results, and no Atlassian function-cache delay.

Who is this for? All SnapJQL users. This is the default page when you open the SnapJQL app.

image-20260615-095240.png

Why use the JQL Search Page instead of Jira Issue Navigator?

Always fresh results

The JQL Search page does not rely on Jira’s cached function results (Atlassian precomputations, cached up to 7 days). It resolves SnapJQL functions and queries Jira directly each time, giving you accurate, up-to-date results for functions involving dates, hierarchy, comments, agile sprints, and more.

 

Jira Issue Navigator

SnapJQL - JQL Search Page

 

Jira Issue Navigator

SnapJQL - JQL Search Page

Function cache

Results can be stale for up to 7 days

Fresh results on every search

1,000 issue hard error

Yes — see below

No — automatic pagination

Function explorer

Not built in

Full explorer + parameter modal

SnapJQL columns (sj_*)

Not available

Add via Add fields

Hierarchy tree view

Flat list only

Show in hierarchy for link/parent queries

For filters you reuse in Jira dashboards, set up automatic sync on the Filters page to keep Jira’s function cache fresh. See Function cache.


No 1,000 issue limit

Jira Cloud’s Issue Navigator enforces a hard limit: if a JQL function returns more than 1,000 issues, the Issue Navigator shows an error.

The SnapJQL JQL Search page has no such restriction. It automatically paginates through all results — tens of thousands of issues — without failing.

Note: Very large queries (approximately 100,000+ issues) may be blocked with a message asking you to narrow your JQL. This is a performance guard, not the 1,000-issue Jira cap.


Full support for SnapJQL functions

  • Shows a full function explorer for all SnapJQL functions and properties

  • Click any function to open a form-based modal and insert it into your query

  • Native Jira JQL editor with autocomplete

  • Pin frequently used functions for quick access


Before your first search

If initial indexing has not been completed, a warning banner appears with a link to Indexing.

SnapJQL columns and function results only reflect indexed issues. Run indexing for historical data before expecting complete results.


How to use the JQL Search Page

  1. Go to SnapJQL → JQL Search.

  2. Type your JQL query, including any SnapJQL functions — or build one using the Function explorer.

  3. Click Search.

  4. Scroll through all results — pagination is automatic (15 issues per page).

  5. Customize columns using the Add fields selector.

  6. Optionally export results to Excel or PDF.

  7. Save your query as a filter if needed.


Function explorer (helper panel)

On the right of the JQL Search page, the Function explorer lets you browse every SnapJQL JQL function and property.

image-20260615-100302.png

 

Categories included:

  • Issue Hierarchy

  • Issue Links

  • Field Comparison

  • Agile

  • Comments

  • Attachments

  • History

  • Groups

  • Organizations

  • Pinned (your pins + admin-pinned functions)

Badge legend:

Badge

Meaning

Badge

Meaning

F

JQL Function

P

JQL Property

AO

Available only in the SnapJQL Search interface

SJ2

Requires the free companion app SnapJQL – More JQLs

Panel controls:

  • Search box — filter functions by name

  • Collapse/expand the panel with the chevron button

  • Resize by dragging the handle on the left edge

  • Pin (★) functions for quick access in the Pinned category

Each function in the list shows its description and inline examples. Click any function name to open the full modal.


Function / property modal

Clicking any function opens the Insert JQL functions and properties modal. It simplifies inserting SnapJQL functions into your query by showing details, examples, and lookup dropdowns — no syntax knowledge required.

image-20260615-100922.png

 

Workflow:

  1. Select any function from the right-hand function explorer (or from within the modal’s left list).

  2. The modal opens with parameter fields.

  3. Choose operators, pick values, or use auto-suggest fields.

  4. The modal shows a preview of the query that will be inserted.

  5. Click Insert to Query to place it into your JQL editor.

  6. Click Search to run.

The modal includes:

  • Examples for every function

  • Parameter validation (required fields, balanced parentheses/quotes)

  • Auto-complete for statuses, boards, sprints, users, fields, link types

  • User lookup — search Jira users and insert account IDs automatically

  • Real-time JQL generation — preview updates as you fill parameters

  • Works with all SnapJQL functions, including Agile and History functions

  • See All functions and properties page for more samples


Search results

After a successful search:

  • Issue count is shown at the top.

  • Results appear in a table with your chosen columns.

  • Pagination — Previous / Next, page jump, and “Page X of Y (Z total issues)”.


Add fields — Jira vs SnapJQL fields

After running a JQL query, add or remove columns with Add fields. The picker is split into two collapsible groups:

Group

Contents

Group

Contents

Jira fields

Standard Jira fields from your instance (same pool as in Jira field configuration)

SnapJQL fields

Indexed properties from the SnapJQL entity property (sj_*)

image-20260615-103210.png

How SnapJQL fields display

SnapJQL fields

Type

Display

SnapJQL fields

Type

Display

sj_childCount, sj_commentCount, sj_issuelinksCount, sj_attachmentCount, etc.

Number

Plain number

sj_childSummary, sj_issuelinksLinkType, sj_attachmentFilename, etc.

Text

Text (comma-separated if multiple values)

sj_commentCreated, sj_indexedAt, sj_attachmentCreated, etc.

Date

dd/MM/yyyy HH:mm

sj_commentAuthor, sj_attachmentAuthor

User

Avatar + display name

sj_childKey, sj_parentKey, sj_issuelinksOutwardKeys, sj_issuelinksInwardKeys

Issue keys

Clickable issue keys

sj_childIssuetype, sj_issuelinksLinkedIssueType

Issue type

Icon + name

sj_childPriority, sj_issuelinksLinkedPriority

Priority

Icon + name

sj_childStatus, sj_parentStatus, sj_issuelinksLinkedStatus

Status

Colored status lozenges

sj_childStatusCategory, sj_parentStatusCategory, sj_issuelinksLinkedStatusCategory

Status category

Colored category lozenges (To Do / In Progress / Done)

  • Multi-value indexed fields (e.g. several children or links) show multiple values stacked or comma-separated, depending on type.


SnapJQL field reference

Children (sub-tasks / child issues)

Column ID

Description

Column ID

Description

sj_childCount

Number of children

sj_childKey

Child issue keys

sj_childSummary

Child summaries

sj_childIssuetype

Child issue types

sj_childPriority

Child priorities

sj_childStatus

Child statuses

sj_childStatusCategory

Child status categories

Parent

Column ID

Description

Column ID

Description

sj_parentKey

Parent issue key

sj_parentSummary

Parent summary

sj_parentIssuetype

Parent issue type

sj_parentPriority

Parent priority

sj_parentStatus

Parent status

sj_parentStatusCategory

Parent status category

Issue links

Column ID

Description

Column ID

Description

sj_issuelinksCount

Total link count

sj_issuelinksOutwardCount

Outward link count

sj_issuelinksInwardCount

Inward link count

sj_issuelinksOutwardKeys

Outward linked keys

sj_issuelinksInwardKeys

Inward linked keys

sj_issuelinksLinkType

Link types

sj_issuelinksLinkedPriority

Linked issue priorities

sj_issuelinksLinkedIssueType

Linked issue types

sj_issuelinksLinkedStatus

Linked issue statuses

sj_issuelinksLinkedStatusCategory

Linked issue status categories

Comments

Column ID

Description

Column ID

Description

sj_commentCount

Comment count

sj_commentAuthor

Comment authors

sj_commentCreated

Comment created dates

sj_commentLastCreated

Most recent comment date

Attachments

Column ID

Description

Column ID

Description

sj_attachmentSize

Attachment size (in MB)

sj_attachmentFilename

Attachment file names

sj_attachmentExtension

File extensions

sj_attachmentCount

Number of attachments

sj_attachmentAuthor

Attachment authors

sj_attachmentCreated

Attachment created dates

Indexing metadata

Column ID

Description

Column ID

Description

sj_indexedAt

When SnapJQL last indexed this issue


Show in hierarchy

When your JQL uses SnapJQL hierarchy or link functions, a Show in hierarchy checkbox appears above the results.

[SCREENSHOT: Hierarchy view — indented Key column with collapse toggles and link icons]

Functions (examples)

Effect

Functions (examples)

Effect

sj_linksOf, sj_allLinksOf, sj_linkedByOf, sj_linkedByOrParentsOf, sj_linksOrChildrenOf

Results shown as a tree with indentation on Key

sj_childrenOf, sj_parentsOf, etc.

Related issues grouped under parents/links

Any hierarchy/link function with hierarchy on

Collapse/expand rows where multiple nested issues exist

How it works:

  • The table refetches issues with parent/link data needed for the tree.

  • Hover issue keys for relation path tooltips.

  • If hierarchy is off, results are a flat list with normal pagination.


Save and load filters

Load a saved filter

Click Load saved filter above the JQL editor → pick a filter → JQL loads into the editor → click Search.

Save a filter

After a successful search with results:

  1. Click Save Filter.

  2. Enter a name.

  3. Optionally enable Automatic sync (1×, 2×, or 4× per day) to keep Jira’s function cache updated.

  4. Click Save.

The filter is saved to Jira and registered in SnapJQL. Manage sync on the Filters page.

image-20260615-103509.png

Export results

Use the Export button above the results table:

  • Export to Excel — full result set as a spreadsheet

  • Export to PDF — formatted report

Export fetches all matching issues in the background (not just the current page) and shows progress while loading.

image-20260615-103558.png

Troubleshooting

Symptom

Likely cause

What to do

Symptom

Likely cause

What to do

SnapJQL columns empty

Issues not indexed

Run Indexing; check Indexing page tenancy stats