Quick Reference
Quick reference for all Argon Powerful JQL Search functions and entity properties.
JQL Functions
Links and Hierarchy
| Function | Syntax | Description |
|---|---|---|
linkedByQuery | issue in linkedByQuery("subquery") | Find issues linked to by issues matching subquery |
linksQuery | issue in linksQuery("subquery") | Find issues linked from issues matching subquery |
childrenOf | issue in childrenOf("subquery") | Find children of issues matching subquery |
parentOf | issue in parentOf("subquery") | Find parents of issues matching subquery |
Operators: in, not in
Field Operations
| Function | Syntax | Description |
|---|---|---|
fieldValue | field operator fieldValue("subquery", "field") | Compare field values across issues |
fieldCount | issue operator fieldCount("subquery", "field", count) | Filter by count of field values/properties |
regex | issue in regex("subquery", "field", "pattern") | Match field values using regex |
fieldValue operators: =, !=, >, >=, <, <=, in, not in
fieldCount operators: =, !=, >, >=, <, <=
regex operators: in, not in
Math Functions
| Function | Syntax | Description |
|---|---|---|
minimum | "field" operator minimum("subquery") | Compare against minimum value |
maximum | "field" operator maximum("subquery") | Compare against maximum value |
average | "field" operator average("subquery") | Compare against average value |
Operators: =, !=, >, >=, <, <=
Legacy names: min, max, and avg are equivalent older names but collide with JQL reserved keywords, so they must be quoted: "min"("subquery"), "max"(…), "avg"(…). Prefer the unquoted forms above for new queries.
Time Functions
| Function | Syntax | Description |
|---|---|---|
timeInStatus | issue operator timeInStatus("subquery", "status", "time") | Filter by time spent in status |
timeExpression | "Field.time" operator timeExpression("time") | Compare Time in Status field values |
Operators: =, !=, >, >=, <, <=
Time format: 2w 3d 5h 30m 45s (weeks, days, hours, minutes, seconds)
History Functions
| Function | Syntax | Description |
|---|---|---|
changedBy | issue in changedBy("subquery", "field", "start", "end", "user") | Find issues with field changes |
transitionedBy | issue in transitionedBy("subquery", "status", "start", "end", "user") | Find issues transitioned to status |
Operators: in, not in
Date format: yyyy/MM/dd or yyyy/MM/dd HH:mm
Activity Functions
| Function | Syntax | Description |
|---|---|---|
commented | issue in commented("subquery", "author", "start", "end", "content") | Find issues with matching comments |
attachment | issue in attachment("subquery", "author", "start", "end", "filename", "ext") | Find issues with matching attachments |
worklog | issue in worklog("subquery", "author", "start", "end", "min", "max") | Find issues with matching worklogs |
Operators: in, not in
Date format: yyyy/MM/dd or yyyy/MM/dd HH:mm
Time spent format: 1d 2h 30m (for worklog min/max)
JQL Keywords
Link Properties
| Property | Type | Description | Example |
|---|---|---|---|
linksNumber | Number | Count of outgoing links | linksNumber > 3 |
linkedByNumber | Number | Count of incoming links | linkedByNumber >= 1 |
linkedByIssue | String | Keys of linking issues | linkedByIssue = "PROJ-123" |
linkedByStatus | String | Status of linking issues | linkedByStatus = "Done" |
linkedByCategoryName | String | Status category of linking issues | linkedByCategoryName = "In Progress" |
linkedByPriority | String | Priority of linking issues | linkedByPriority = "High" |
linkedByIssueType | String | Issue type of linking issues | linkedByIssueType = "Bug" |
Number operators: =, !=, >, >=, <, <=
String operators: =, !=, ~, !~
Hierarchy Properties
| Property | Type | Description | Example |
|---|---|---|---|
childrenNumber | Number | Count of child issues | childrenNumber > 0 |
childrenIssueIds | String | IDs of child issues | childrenIssueIds = "10001" |
Quick Examples
Links and Hierarchy
-- Issues linked to by high-priority bugs
issue in linkedByQuery("priority = High AND issuetype = Bug")
-- Parent stories with children
issue in parentOf("issuetype = Sub-task") AND childrenNumber > 0
Field Comparisons
-- Story points above average
"Story Points" > average("project = DEV")
-- Issues with exactly 3 labels
issue = fieldCount("project = DEV", "labels", 3)
Time Tracking
-- In Progress for more than 2 weeks
issue > timeInStatus("project = DEV", "In Progress", "2w")
-- Time in Status field comparison
"Time in Development.time" > timeExpression("3d")
History and Activity
-- Transitioned to Done in Q1
issue in transitionedBy("project = DEV", "Done", "2024/01/01", "2024/03/31")
-- Comments containing "approved"
issue in commented("project = DEV", "", "", "", "approved")
-- PDF attachments
issue in attachment("project = DEV", "", "", "", "", "pdf")
JQL Keywords
-- Issues linked by Done issues
linkedByStatus = "Done"
-- Issues with many incoming links
linkedByNumber > 5
-- Parent issues with 3+ children
childrenNumber >= 3
Date and Time Formats
| Format | Example | Used In |
|---|---|---|
| Date | 2024/01/15 | changedBy, transitionedBy, commented, attachment, worklog |
| DateTime | 2024/01/15 14:30 | changedBy, transitionedBy, commented, attachment, worklog |
| Time Expression | 2w 3d 5h 30m | timeInStatus, timeExpression, worklog (min/max) |
Time units: w (weeks), d (days), h (hours), m (minutes), s (seconds)