When using the relational navigator in the dashboards you can find all the connected records. But I want to exclude records from another entity that don’t have any connections.
In SQL I would do it like this: select a.* from a left outer join b on a.id = b.a_id where b.a_id is null
in our “classic demo” (the one with Articles/Companies/Investments that you can download preloaded or that you can build yourself with the Siren Tutorial) to get the “companies that are not mentioned in any article” you simply:
go to articles
press the blue button to navigate to Companies… now you’re seeing “any company that has an article mention”
hover on the article and press the NEGATE button, now the filter becomes red, and you’re now only seeing companies that do not have an article mentioning them.