I have a table, the data comes from a select statement including a JOIN statement.
Additionally I have a form and I am using the initial state function referencing the selected row in the mentioned table.
Now the thing is, due to the JOIN statement I have a column name that is in both tables.
Now if I type in tablename.columnname into the form data key of a field, it doesn't work. If I type in the columnname, it seems to be referencing the first table.
Hi Scott, as I said, the column name is ambigious.
Let's say I am joining these tables:
table1
column_a
column_b
table2
column_a
column_b
If I use {{ table1.selectedRow.data.column_b }} which column does it pick, as there are two column_b? {{ table1.selectedRow.data.table1.column_b }} doesn't seem to work.
If I use {{ table1.selectedRow.data.column_b }} which column does it pick (this would pick the columnb from table 1), as there are two column_b? {{ table1.selectedRow.data.column_b }} (you had an extra reference to the table1 )
For table2 {{ table2.selectedRow.data.column_b }}