Step 3: Define which results to return

Choose a data find type based on whether you need multiple items or exactly one item from the result set.

OrderItems are sorted by creation date, not by their position on the board. “First” and “last” always refer to creation order.

Multiple results

Duplicates, excluding the first

Returns every duplicate except the first-created instance. With A, B, B, B, C, the result is the final two B items.

Duplicates, excluding the last

Returns every duplicate except the last-created instance. With A, B, B, B, C, the result is the first two B items.

All duplicates

Returns every instance in each duplicate set. With A, B, B, B, C, the result is B, B, B. This is normally used when merging duplicates.

Unique values

Returns items whose selected values do not appear anywhere else in the selected groups. With A, B, B, C, the result is A, C.

Deduplicated values

Returns one item for every distinct value, even when duplicates exist. With A, B, B, C, the result is A, B, C.

Deduplicated + first duplicate

Returns each distinct value together with the first extra duplicate. With A, B, B, B, C, the result is A, B, B, C.

Any

Returns any items found in the selected groups. This is useful for copying or moving a broad set of items to another group or board.

Single result

This section always returns exactly one item.

Only first duplicate

Searches all duplicates and returns the earliest duplicate item. With A, B, B, B, C, the result is B.

Only last duplicate

Searches all duplicates and returns the last duplicate item. With A, B, B, C, C, D, the result is C.

Only first unique instance

Returns the first-created unique item. With A, B, B, B, C, the result is A.

Only last unique instance

Returns the last-created unique item. With A, B, B, B, C, the result is C.

Any last

Returns the last item in the selected groups, whether or not it is a duplicate. With A, B, B, B, C, the result is C.

Filter results

Get all values

Does not apply another filter. For example, when “Duplicates, excluding the first” is selected, every result from that search is returned.

Get values with an item name of

Further filters the result set by an item name you specify. If duplicate results are selected, only duplicate items with that name are returned.