{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/bf64548fe5fb42f9978bee11fb7e48f6\" frameborder=\"0\" width=\"2560\" height=\"1920\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1920,"width":2560,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1920,"thumbnail_width":2560,"thumbnail_url":"https://cdn.loom.com/os/loom-media-content/loom/3dc93c68-7692-4a7a-b828-1ecb905af071/6d08bb99-3183-464b-bc5a-fbc0980fd65c/sessions-thumbnails-bf64548fe5fb42f9978bee11fb7e48f6-25437efc3dcc771e.gif/binary?authToken=eyJraWQiOiJtaWNyb3MtZ3JvdXAvdGRwLW9zLWFyY2hldHlwZS9hMTJlaHRidGhjcDk3bWRvIiwiYWxnIjoiUlMyNTYifQ.eyJicyI6Imxvb20tbWVkaWEtY29udGVudCIsImF1ZCI6InRkcC1vcy1hcmNoZXR5cGUiLCJuYmYiOjE3OTMxNzQ4NzUsInRpIjoiNmI4NzQ4OWQtMTY3Zi00MGRlLWFhNmItNjk5OTY1Mzk1NWVlIiwiYWRpIjoibG9vbS9sb29tIiwiaXNzIjoibWljcm9zLWdyb3VwL3RkcC1vcy1hcmNoZXR5cGUiLCJwaWQiOiIwNGQwZmI3ZC0xNGE3LTQxZjAtYjA0ZC0wZjhkMzg1Zjc2ZmIiLCJ3YSI6ImZhbHNlIiwib2lkIjoic2Vzc2lvbnMtdGh1bWJuYWlscy1iZjY0NTQ4ZmU1ZmI0MmY5OTc4YmVlMTFmYjdlNDhmNi0yNTQzN2VmYzNkY2M3NzFlLmdpZiIsImV4cCI6MTc5MzE3NTQ3NSwiaWF0IjoxNzkzMTc0ODc1LCJqdGkiOiJmYWMzNDNlZS1lZDQzLTQ1NmEtOGMyMC0xZGQxZDcyMzg4YzUifQ.bikzn7Dq_OUUBW57h_QUxn7E1dCb5IdGamjvwD15zMzdsZduMzTuty7nZoeyXAimsUlFo_lGZUs1oXKS1_ijoIiBZgUKLT3AgcILi1kDJbkjX02pD5Ancgke50KkT4zn6ffaqHvAJMCagkg0zlDWNkF1i5FH5tAnyUdvIlcL81F5edfFWGSrySFGVMHBRVSVYJAFm21GuIaj3GdrswElJ09nGFckLyL6_llr6bgGxwofZsEWGtoElj9c6jEhYe66FZN3tw5ZfZz0I3pv6vCSKkCRgDqpfNtE39Ld3bVbmGptaQjytd-PVWlBzjwA36x5MQlYhuIHAlKFN3WFr8kvlA&Expires=1793175475&Signature=Vqwq-HIw3HWebtOA25g9OYbLBsmsa1baQ8sxtb6YV%7ETG1wCejmcJlF54bxJZGXaaLcMQSsRuAUE7fEdOIEsbKx8iyai1Z3XgxBNtROuvAkgybE9a01bGyrEY5yfyFrIfXOAWdSkm11tpkN1-VtNdQkrBhS2aC6MBQkj1byKweHD9pDkiwukyH-f-JV0bUlPTqMFs4HxESCl9TEoEQMJlTYgf-1sbl4S4bWb75NwFpXfbEr8lAj9wQWO9W%7EU4-h2OXwLjcWTTE6jIwUeseYwDtIyxRBUgsQwmf5fGlCwmS45nDtE%7EkuhEq7%7EPDSPjIyc2j4phcr04qO0FyhPrD3zQxA__&Key-Pair-Id=KQOSYIR44AIC0","duration":634.436,"title":"Debugging Multi Tenant Revenue Chart Issues","description":"This Loom focuses on diagnosing and fixing a local database connection issue and then investigating why different tenants were seeing the same property and revenue data. The author initially suspected time zone problems or SQL query issues, and noted that revenue numbers appeared to belong to another company. After running docker compose up and asking Claude to help, they learned the local database was not connecting properly and Claude fixed the connection blocker for local testing. They then used Matt Pocock’s diagnosing bugs prompt to reproduce the issue and verify the fix. Finally, they found a component was hard-coded so both tenants used the same properties, and since there is no get properties for the tenant API, filtering is done manually with hard-coded tenant-specific property sets."}