The view works with one table as shown, but after adding an OR condition, it stops working. If I replace the table condition with active = true, I cannot view the records; I can only see the count of records.
What does the View Tables and where clauses look like after adding the OR condition? What other table are you trying to include? What is the end goal of what you want to achieve?
