<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/7f6bf7d77d894bb0838dc8a953214672&quot; frameborder=&quot;0&quot; width=&quot;1280&quot; height=&quot;960&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>960</height><width>1280</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>960</thumbnail_height><thumbnail_width>1280</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/7f6bf7d77d894bb0838dc8a953214672-00001.gif</thumbnail_url><duration>188.82</duration><title>Combining Information to Filter Orders 📊</title><description>Hey Trevor, in this Loom, I&apos;m going to show you how I combined certain information about one specific ID to enable me to filter based on that. I&apos;m using an example where I have lots of different orders, but in each, there&apos;s certain information that&apos;s different. I want to know which orders only have non-custom items, and I don&apos;t want to see any customized items in my orders. I&apos;m going to get an array here in the summary section of the custom order and break this down by the order ID. Then, I&apos;m going to filter and say I only want ones that just have false. This is going to give me only the order IDs that have no customized items in them. Finally, I&apos;m going to join the query that I saved based on the origin ID and do a right join. This will show us the information we need. Let me know if you have any questions or if there&apos;s any action you need to take.</description></oembed>