Hi everyone.
I have one table (“Planos de Clientes”) that make relationship with another table (“Nome do Plano”), and this second table (“Nome do Plano”) make relationship with an third table (“Grupo de Serviços”).
Since I update to 0.37.x, filters with my third table (“Grupo de Serviços”) doesn’t work without make the joins on notebook editor.
Segments that I have with this type of filter stopped work too.
I can’t reproduce with Sample Dataset because the dataset is simple and don’t have this type of relationship.
Hi @yuriandreoli
Which version were you using before? Have you tried to downgrade to that version again?
You are filtering on different columns.
If you enable debug logging on your database, then you can see the queries being executed. You can also check the browser developer Network-tab to see the request, when running the query, which contains all the details in the response data.
@yuriandreoli I don’t understand. You are showing a table with a filter, and getting no results. And then you are showing a question with joins and a different filter, and you are getting results.
Without detailed information about your data model and the query, then it’s impossible to know what the problem is.
But I would recommend that you revert to your backup.
@yuriandreoli
In “Without Join”, you are filtering with the table “Nome do Plano”, which is referenced by FK (implicit).
While in “With Join”, you are filtering with the table “Grupo de Servicos” from the manual join (explicit).
Different tables will return different results.
Check the query by clicking “View the SQL” in the top-right corner of the Notebook editor.
The “bug” is the single-level FK support, I just upvoted in the post.
My segment doesn’t work too because is in “Planos de Clientes” and make reference to “Grupo de Servicos” directly.