Cannot use foreign keys in query

OS info

  • Operating System : Windows 10.0.19044
  • Wappler Version : 5.6.1

I use PHP and PostgreSQL

Problem description

When try to create a query using foreig keys to create a subquery I get the error ‘cannot read property of undefined (parent)’.
I get the same error when opening existing queries. However, queries return results.

Query_issue.zip (6.7 KB)

Hey @fjacques_dutscher,

From what I understand form this message is that there is a relation issue (foreign key)…
Please share a screenshot of your table structure and the query/subquery that you call

Hi @famousmag,

Thanks for your help.
I cannot open the existing query because it shows the error.
The serverconnect works well when call by the browser, so the query seems right.
The database disappeared from the database manager. I dded a new data base connection with the option 'also creat a connection in Database Manager. The connection was succesful but not created in database manager.

I’ve had some weird behaviour as well with my tables since the latest update… just thought I should mention that

I was able to get the database back in databse manager by restarting Wappler a few times.
I am still not able to open queries where subtables are used.