Filtering Event Products by ID: Custom Property Example
I have an event property called products, which is an array that contains id, name, price, quantity. I want to extract id and then create a custom property to filter where id in (1,2,3)
I have an event property called products, which is an array that contains id, name, price, quantity. I want to extract id and then create a custom property to filter where id in (1,2,3)
Hi Elena M., Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> 👋
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Based on the knowledge sources, I can help you work with your list of objects property and create a custom property to filter by specific IDs.
Since your products property is a list of objects, you can use custom properties with the any function to check if any product ID matches your criteria.
Here's how to create a custom property that checks if the ID is in (1, 2, 3):
```
any(product, products.id, product == 1 or product == 2 or product == 3)
LBKSThis custom property will evaluate to `true` if any product in your `products` array has an ID of 1, 2, or 3, and `false` otherwise.
According to the [custom properties functions documentation](https://docs.mixpanel.com/docs/features/custom-properties#functions), the `any` function "evaluates to TRUE if the given expression is true for any value in the given list."
Once you create this custom property, you can:
1. Apply it locally to your report, or
2. Save it globally for reuse across reports (available for Growth and Enterprise plans)
Then you can use this boolean custom property as a filter in your reports to show only events where at least one product has an ID of 1, 2, or 3.
**Note:** When working with list of objects properties, you can access nested properties using dot notation (like `products.id` to access the `id` field within each object in the `products` array), as shown in the [list of objects documentation](https://docs.mixpanel.com/docs/data-structure/property-reference/data-type#list-of-objects-property-support).
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
Based on the knowledge sources, when creating a custom event property through the Mixpanel UI for a list of objects property like products, you can extract the id values using dot notation.
Here's the formula to extract the list of IDs from your products property:
```
products.id
LBKSAccording to the [list of objects documentation](https://docs.mixpanel.com/docs/data-structure/property-reference/data-type#list-of-objects-property-support), when you select a list of objects property in Mixpanel, "you will be prompted to select another property common to the objects in the list." This means you can directly access nested properties like `id` using the dot notation `products.id`.
This will give you a list of all the `id` values from the objects in your `products` array. You can then use this extracted list property in filters and breakdowns just like any other [list property](https://docs.mixpanel.com/docs/data-structure/property-reference/data-type#list-property-support).
To create this in the UI:
1. Navigate to where you're creating your custom property
2. In the formula bar, enter: `products.id`
3. Apply or Save the custom property
This custom property will return a list of IDs that you can then filter or break down by in your reports.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.