Search and report with FieldCraft fields
FieldCraft stores every value in its Jira field, so you can search, sort and report on it like any other field.
You can use the values in JQL, the list view, boards, dashboards and exports. Nobody needs to open the work item first.
Search by value typeβ
How you search depends on the kind of value the field holds.
| Value | Field types | How to search |
|---|---|---|
| Number | Transition Count, Time in Status, Time Between, Countdown, Field Change Count, Calculated Metrics, Rollup, Jira Expressions - Number, Parent Field - Number | Compare with =, >, <, >= or <=. Sort with ORDER BY |
| Date or date and time | First/Last Field Change Time, Status Entered Time, Comment Date, Jira Expressions - Date, Jira Expressions - Date & time, Parent Field - Date | Compare with dates or relative dates, such as -24h or endOfWeek() |
| Person | Modified By, Status Entered By, Commenter, Jira Expressions - User, Parent Field - User | Search as a person, with currentUser() or IS EMPTY |
| Text | Parent Field, Previous Value, Last Comment From, Jira Expressions - Text | Match the exact text with = or !=. ~ finds nothing |
| Size | T-Shirt Size | Search the Size or Points property |
Put the field name in double quotes, for example:
"Reopen count" > 1 ORDER BY "Reopen count" DESC
Text matches exactlyβ
A text value matches only the whole text, so "Parent status" = "Done" works and "Parent status" ~ "Do" finds nothing.
Previous Value stores text too, even for a person field. Search it by display name, for example "Previous assignee" = "Alice Smith".
T-shirt sizesβ
Search a T-Shirt Size field by its points or by its size:
"T-shirt estimate.Points" >= 5
Size searches the size slot, such as "T-shirt estimate.Size" = "L". If you renamed the sizes, the slot name still counts.
Units of time fieldsβ
JQL compares the stored number, so you need to know the field's unit.
| Field type | Stored unit | Example |
|---|---|---|
| Time in Status | Working seconds. 8 working hours are 28800 | "Time in review" > 28800 |
| Time Between | The unit in Store the value in: working days, hours, minutes or seconds | "Cycle time" > 5 for more than 5 working days |
| Countdown | The unit in Store the value in: working days, hours or minutes. Negative once overdue | "Days until due" < 0 |
A working day is the average working day of the field's work calendar, or 24 hours without one.
If you change the unit, recalculate existing work items. Until then, older values stay in the old unit.
Use the field IDβ
When two fields share a name, search by the field ID instead.
The ID column on the Fields tab shows the ID, for example customfield_10142. In JQL, write it as cf[10142]:
cf[10142] > 5
Lists, boards, dashboards and exportsβ
All of them show the value stored in the field.
Lists show a readable form, such as a duration like 2d 6h 30m. CSV exports keep the number.
A traffic light or progress bar shows in lists, but search and exports keep the number. See Show a traffic light or progress bar.
How current the stored value isβ
| Value | When search and lists catch up |
|---|---|
| Values that change with the work item | Seconds after the change |
| Rollup values on a parent | About 20 seconds after the last change on a child, and at most 5 minutes |
| Values that count until now (Time in Status, Time Between, Countdown) | The hourly refresh: every hour for recent values, less often for older ones and done work items |
| Watcher and vote counts | When someone opens the work item, or when you reindex |
The work item itself always shows you the current value.
FieldCraft writes values without a history entry and without notifications. See How values stay current.
Examplesβ
These examples come from the field recipes. Replace the name with your field's name.
Stories that took more than 5 working days:
"Cycle time" > 5 ORDER BY "Cycle time" DESC
Open work that is overdue:
"Days until due" < 0 AND statusCategory != Done ORDER BY "Days until due" ASC
Work that hasn't moved for two weeks:
"Last status change" < -14d AND statusCategory != Done
Requests where the customer wrote last:
"Last comment from" = Customer AND statusCategory != Done
Epics that are less than half done:
"% done" < 50 AND statusCategory != Done
Relatedβ
-
Field recipes: every recipe with its JQL example.
-
Search, boards or exports show an old value: what to do when a list lags behind.
-
How values stay current: events, the hourly refresh and reindexing.
-
Show a traffic light or progress bar: color a value without changing what you search.