<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Thanks I'll check that out. <div><br></div><div>I'm mainly using the VRT in QGIS against Ingres database. QGIS isn't doing filtering properly for me, (even with passthrough=true) so I'm trying to discern whether it's a deficiency of our Ingres driver or if the functionality just doesn't exist yet elsewhere :)</div><div><br><div><div>On 2012-05-18, at 3:10 AM, Even Rouault wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>Le vendredi 18 mai 2012 07:12:03, Tyler Mitchell a écrit :<br><blockquote type="cite">I've done my best to comb through the code but can't see how to use an<br></blockquote><blockquote type="cite">attribute filter in a (OGR) VRT definition.<br></blockquote><br>Tyler,<br><br>You have 2 possibilities :<br><br>1) Probalby not what you want for your use case, but you can set a OGR VRT and <br>set externally an attribute filter on the returned layer. The attribute filter <br>should be applied directly on the underlying source layer if you set <br><attrFilterPassThrough>TRUE</attrFilterPassThrough> in the <OGRVRTLayer> (or <br>if no explicit <Field> is present, or -in trunk- automatically in compatible <br>cases)<br><br>2) Or you use a <SrcSQL> definition with a WHERE clause in it. In case the <br>underlying datasource as a specific implementation of ExecuteSQL() , that <br>should be efficient (and even if it doesn't the generic OGR SQL engine should <br>extract the WHERE clause and pass it to the SetAttributeFilter() <br>implementation of the underlying layer)<br><br>Even<br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">Tyler_______________________________________________<br></blockquote><blockquote type="cite">gdal-dev mailing list<br></blockquote><blockquote type="cite"><a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br></blockquote><blockquote type="cite"><a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div></blockquote></div><br><div>
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><br class="Apple-interchange-newline"><br></div><div><div style="text-align: left; "><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width: 1036px; position: static; z-index: auto; "><tbody><tr><td valign="top" style="padding-top: 0in; padding-right: 0in; padding-bottom: 0in; padding-left: 0in; "><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black; ">Tyler Mitchell</span></b><b><span style="font-size: 10pt; font-family: Arial, sans-serif; color: black; "><o:p></o:p></span></b></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; line-height: 12pt; "><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); ">Engineering Director <br>Actian Corporation</span><br></div></td></tr><tr style="height: 9pt; "><td valign="top" style="padding-top: 0in; padding-right: 0in; padding-bottom: 0in; padding-left: 0in; height: 9pt; "><font class="Apple-style-span" color="#0000ff" face="Arial, sans-serif"><span class="Apple-style-span" style="font-size: 13px; line-height: 16px; "><u><a href="mailto:tyler.mitchell@actian.com">tyler.mitchell@actian.com</a><br></u></span></font><br></td></tr><tr><td valign="top" style="padding-top: 0in; padding-right: 0in; padding-bottom: 0in; padding-left: 0in; "><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; line-height: 12pt; "><span class="Apple-style-span" style="font-family: Calibri, sans-serif; font-size: 15px; "><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(0, 150, 186); ">MOBILE </span></span><span class="Apple-style-span" style="font-family: Calibri, sans-serif; font-size: 15px; "><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); ">250-303-1831</span></span></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 11pt; font-family: Calibri, sans-serif; line-height: 12pt; "><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(0, 150, 186); ">SKYPE</span><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(102, 102, 102); "> spatialguru</span><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(31, 73, 125); "><br></span><a href="http://www.actian.com/" target="_blank" style="color: blue; text-decoration: underline; "><span style="font-size: 10pt; font-family: Arial, sans-serif; color: rgb(227, 102, 36); ">www.actian.com<br></span></a></div></td></tr></tbody></table></div></div></span></span></div></span></div></span></span>
</div>
<br></div></body></html>