View data from Postgres table on different schema doesn’t work

[dbatesmdbctech]

OS info

• Operating System : Windows 10.0.22000
• Wappler Version : 4.6.4

Problem description

…Fetch view data from a managed database in digital ocean
This problem is returned when trying to fetch of view data within Wappler from a managed Digital Ocean postgres database. When trying to review the data can clicking fetch data the return is

"Error executing query: select * from “issue” - relation issue does not exist

Steps to reproduce

Outside Wappler

1. create a connection to a Managed database in cloud provider
2. create a table in that Managed database schema with test data
3. enter data into that that table that has been created
4. return to wappler and setup connection and refresh schema to show Database and tables
5. click on show edit data in in the schema table window
6. click on fetch data.

[George]

Is the table you query in your public Postgres database schema or different schema?

[dbatesmdbctech]

its on a different scheme let me try it on public

[dbatesmdbctech]

okay that works if its in public is there anyway to make this a feature request to also be able to read data in other schema’s

[Teodor]

This has been fixed in Wappler 4.7.1