<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"Préformaté HTML Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";}
span.PrformatHTMLCar
{mso-style-name:"Préformaté HTML Car";
mso-style-priority:99;
mso-style-link:"Préformaté HTML";
font-family:"Courier New";
mso-fareast-language:FR;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=FR link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Hi,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US>I’ve same behaviour with different case :<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>I want to filter a layer (Oracle/Postgis) after performing join with tabular data (Excel, MSSQL tested).<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>First Filtering by Layer properties Ui is disabled (greyed button)<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Filtering possible by Menu “Layer”-“Filter”<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Joined fields appears, and Sample values do so.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>But when I want to test filter I got an error message box: (sorry in French)<o:p></o:p></span></p><pre>“Une erreur a été rencontrée lors de l'exécution de la requête.<o:p></o:p></pre><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>Le prestataire de donné a dit :<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>ORA-00904: "V_SIG_SITE_Site_Nature" : identificateur non valide<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>Impossible d'exécuter cette déclaration »<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>Message a bit different with Postgis layer :<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt'><span style='font-size:10.0pt;font-family:"Courier New"'>“</span>Une erreur a été rencontrée lors de l'exécution de la requête.<o:p></o:p></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0'>Le prestataire de donné a dit :<o:p></o:p></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0'><span lang=EN-US>ERROR: column "maires_ZPENS_ville" does not exist<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0'><span lang=EN-US>LINE 1: SELECT * FROM "riv"."bdca_commune" WHERE "maires_ZPENS_ville...<o:p></o:p></span></p><p style='margin:0cm;margin-bottom:.0001pt;-qt-block-indent:0'><span lang=EN-US>^<o:p></o:p></span></p><p class=MsoNormal style='-qt-paragraph-type:empty;-qt-block-indent:0'><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>“<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>Is It possible that a simple action like that is missing?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>Thanks<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;font-family:"Courier New";mso-fareast-language:FR'>Sylvain<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p></div></body></html>