> ## Documentation Index
> Fetch the complete documentation index at: https://help.maestra.io/llms.txt
> Use this file to discover all available pages before exploring further.

# How the order status filter works

[An order](/customers-orders-and-products/orders/what-is-an-order) consists of items.

Each item can have one of the following statuses: **placed, delivered, paid, canceled, or returned**.
A single order can contain items with **different** statuses.
For example, three items may be delivered while one is canceled.

## Which status is used for filtering

<Warning>
  The item status is always checked based on its **latest state**.
</Warning>

**What this means:**

For example, an order was placed, then paid, and later delivered.

<img src="https://mintcdn.com/maestraio/wm8oEjg6bFaQwCHC/images/imported/How-to-find-orders-with-a-specific-value-(17).png?fit=max&auto=format&n=wm8oEjg6bFaQwCHC&q=85&s=d568da4be54d6e4ee485427fff5fa461" alt="" width="8733" height="6639" data-path="images/imported/How-to-find-orders-with-a-specific-value-(17).png" />

To find this order, you need to build a filter for orders with the status **Delivered**, since that’s the most recent status.

“Placed” and “Paid” are historical states, and orders can’t be filtered by those statuses

<img src="https://mintcdn.com/maestraio/05-EV9YqA_RINTJ8/images/imported/How-the-order-status-filter-works.png?fit=max&auto=format&n=05-EV9YqA_RINTJ8&q=85&s=2ef5186c8c3c7c9af7c9d75eb07a168a" alt="" width="9624" height="2324" data-path="images/imported/How-the-order-status-filter-works.png" />

## **Which statuses should you use in your filter?**

Start with the business goal.
In most cases, you’ll want to include “positive” order statuses — such as **Placed**, **Paid**, or **Delivered** (using the **[OR](/filters/how-to-create-filters)**[ condition](/filters/how-to-create-filters)):
​

<img src="https://mintcdn.com/maestraio/05-EV9YqA_RINTJ8/images/imported/Find-customers-with-orders-(1).png?fit=max&auto=format&n=05-EV9YqA_RINTJ8&q=85&s=c32c03e6b0cd0dc0fdfae7ab29400b62" alt="" width="5414" height="1710" data-path="images/imported/Find-customers-with-orders-(1).png" />

**Example 1:** how to find customers with paid orders (the most recent order status is Paid)
​

<img src="https://mintcdn.com/maestraio/05-EV9YqA_RINTJ8/images/imported/How-the-order-status-filter-works-(1).png?fit=max&auto=format&n=05-EV9YqA_RINTJ8&q=85&s=b4249958d42f408559341d9fdf0fa5b9" alt="" width="9624" height="2630" data-path="images/imported/How-the-order-status-filter-works-(1).png" />

**Example 2:** find customers whose orders have **all items paid** (the most recent order status is Paid)
​

<img src="https://mintcdn.com/maestraio/05-EV9YqA_RINTJ8/images/imported/How-the-order-status-filter-works-(2).png?fit=max&auto=format&n=05-EV9YqA_RINTJ8&q=85&s=a16b311ebb1e2b3a3afc5086f05bd8f8" alt="" width="9624" height="2630" data-path="images/imported/How-the-order-status-filter-works-(2).png" />

**Difference between the filters:**

* In the first case, orders with partially canceled or delivered items are included.
* In the second case, all the items are paid.
