[Qgis-user] filter on joined table broken?

[Burghardt.Scholle at stadt.wolfsburg.de]

Hi Tobias,

I don't think you make something wrong. I can confirm your problem also with QGIS 2.18.x. 

If your data is in postgres, there is a workaround: create a view in postgres that includes both the table and the joins. Load this view into QGIS and you can set any filters again.

Regards
Burghardt

> -----Ursprüngliche Nachricht-----
> Von: Qgis-user [mailto:qgis-user-bounces at lists.osgeo.org] Im Auftrag von
> Tobias Wendorff
> Gesendet: Donnerstag, 16. August 2018 19:59
> An: qgis-user at lists.osgeo.org
> Betreff: [Qgis-user] filter on joined table broken?
> 
> Hi there,
> 
> when creating a table join using "joins" in "layer properties", you
> can't filter the resulting table. QGIS informs that it's needed to
> build a virtual layer to make filtering work. But even if you select
> "yes", the joined fields don't appear in attribute table.
> 
> It doesn't matter if you create a virtual join in memory or not.
> Sure, you create a join using "processing", but this creates a new
> dataset. I'm also missing a "drop none-joined rows" in here...
> (ArcGIS style) this seems to be only available from "processing"
> 
> I'm on latest QGIS 3.3 on Windows 7, 64 bit. The problem also occurs
> on QGIS 3.2 stable. Before filing a bug, I'd like to discuss it here.
> Perhaps I'm doing something wrong. I've tested this on three different
> systems (okay, one is running an older version of QGIS3.3-dev on Windows
> 10).
> 
> Best regards,
> Tobias
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user