Notifications
Clear all
Support
2
Posts
2
Users
0
Reactions
720
Views
Apr 15, 2023 12:45 am
Hi
We used to get "AND" in our "JOIN" clause in "FROM" when we had multiple relations for the same field. This is not happening as expected anymore. Please advise.
Thanks
1 Reply
Apr 15, 2023 12:47 am
Hi there!
Ok so we did some research on our side for the Join not forming correctly on your end, and we haven't had any update in that section of the code since May of 2022.
So the change was that the "AND" condition gets added only if you mark the relational field as "Primary" in the setup. This was one way to distinguish and let a user pick if the join used "AND" or not, as several clients were getting "AND" join in cases they didn't need it.
So can you please try and update this in your setup, and mark the columns to want to "AND" join on as Primary Key.
Thanks
Dotnet Report Team