I created a View in the database and now I need to use it in the system, however I can not use it because Doctrine recognizes it as a table, the following error appears:
Type: Doctrine\DBAL\Driver\Mysqli\MysqliException
Message: Table 'empresa.view_usuario' doesn't exist
File: /var/www/projeto/sistema/third_party/composer/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/Mysqli/MysqliStatement.php
Line: 94
I made the following passages:
- I created the view in the database
- I created the Entity as ReadOnly
- I created DAO and nothing worked always returns this error
Is there any way to use views in Doctrine ?