fusio icon indicating copy to clipboard operation
fusio copied to clipboard

Unable to select from a database view

Open delcooper11 opened this issue 3 years ago • 2 comments

I get a 500 response and am given this error: Table ***** does not exist on connection in <path_to_app>/vendor/fusio/adapter-sql/src/Action/SqlActionAbstract.php on line 67

delcooper11 avatar Feb 06 '22 02:02 delcooper11

Hi, currently Fusio does only work with tables and not with views. But in general it would be a great idea to support also views. The problem currently is that we cant inspect a view in the way we can inspect a table but there are probably solutions to this problem.

chriskapp avatar Feb 06 '22 11:02 chriskapp

Nice to have! Thanks

mcmidget avatar Feb 18 '22 16:02 mcmidget