{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/7f6bf7d77d894bb0838dc8a953214672\" frameborder=\"0\" width=\"1280\" height=\"960\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":960,"width":1280,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":960,"thumbnail_width":1280,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/7f6bf7d77d894bb0838dc8a953214672-00001.gif","duration":188.82,"title":"Combining Information to Filter Orders 📊","description":"Hey Trevor, in this Loom, I'm going to show you how I combined certain information about one specific ID to enable me to filter based on that. I'm using an example where I have lots of different orders, but in each, there's certain information that's different. I want to know which orders only have non-custom items, and I don't want to see any customized items in my orders. I'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'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'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's any action you need to take."}