[Qgis-developer] Filter layer after join, error/impossible

[PIERRE Sylvain]

Hi,

I've same behaviour with different case :
I want to filter a layer (Oracle/Postgis) after performing join with tabular data (Excel, MSSQL tested).
First Filtering by Layer properties Ui is disabled (greyed button)
Filtering possible by Menu "Layer"-"Filter"
Joined fields appears, and Sample values do so.
But when I want to test filter I got an error message box: (sorry in French)

"Une erreur a été rencontrée lors de l'exécution de la requête.
Le prestataire de donné a dit :
ORA-00904: "V_SIG_SITE_Site_Nature" : identificateur non valide
Impossible d'exécuter cette déclaration »

Message a bit different with Postgis layer :

"Une erreur a été rencontrée lors de l'exécution de la requête.

Le prestataire de donné a dit :

ERROR: column "maires_ZPENS_ville" does not exist

LINE 1: SELECT * FROM "riv"."bdca_commune" WHERE "maires_ZPENS_ville...

^
"
Is It possible that a simple action like that is missing?

Thanks

Sylvain




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20150220/265677e8/attachment.html>