Identify which table/join is causing the 'circular join' message
Idea Logged
When working with large views (which most of ours are), when we run into a circular join issue, it's near impossible to figure out which join it's referring to.
Can you please have a way to visually identify the bad join? E.g. Maybe show the join line as red etc.. even doing it at the log file level is good enough, just need something to help!
Thanks
Hi Dor,
Thanks for the suggestions. This has been logged for further review.
In most cases of view edits, you're not modifying that many tables/joins, so shouldn't be too bad to figure out which tables you just added/modified.
To help us understand how this impacts you, can you please attach a screenshot of this issue in practice, and why it's not easily identifiable.
Thanks,David
In my experience the most common issue is understanding the join-from/join-to logic baked into Yellowfin. Another experience I learned is that joining using multiple table conditions is simply not possible unless you construct a virtual table.
Here's an example that is completely logical yet not possible in view editor(without a virtual table):
This is simply not possible without a virtual table. All joins using the standard GUI interface are predicated on one table to another without the ability to include a column from another table as a join condition. That would be a nice feature.
Comments have been locked on this page!