Skip to main content

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.

ValueField typesHow to search
NumberTransition Count, Time in Status, Time Between, Countdown, Field Change Count, Calculated Metrics, Rollup, Jira Expressions - Number, Parent Field - NumberCompare with =, >, <, >= or <=. Sort with ORDER BY
Date or date and timeFirst/Last Field Change Time, Status Entered Time, Comment Date, Jira Expressions - Date, Jira Expressions - Date & time, Parent Field - DateCompare with dates or relative dates, such as -24h or endOfWeek()
PersonModified By, Status Entered By, Commenter, Jira Expressions - User, Parent Field - UserSearch as a person, with currentUser() or IS EMPTY
TextParent Field, Previous Value, Last Comment From, Jira Expressions - TextMatch the exact text with = or !=. ~ finds nothing
SizeT-Shirt SizeSearch 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 typeStored unitExample
Time in StatusWorking seconds. 8 working hours are 28800"Time in review" > 28800
Time BetweenThe unit in Store the value in: working days, hours, minutes or seconds"Cycle time" > 5 for more than 5 working days
CountdownThe 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​

ValueWhen search and lists catch up
Values that change with the work itemSeconds after the change
Rollup values on a parentAbout 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 countsWhen 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