Identify which table/join is causing the 'circular join' message

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):

Select *
From TableA
Left Join TableB on TableB.pk_id = TableA.fk_id
Left Join TableC on TableC.pk_id = TableB.fk_id and TableC.ex_date > TableA.ex_date

I'm adding an additional message in the view builder which should also show the tables involved - "Two Tables with the same name/Alias" something like that, not sure about the exact text but I've encountered that yesterday and luckily I kept a file with all of the tables I've added. :)

Thanks