[Qgis-user] filter on joined table broken?

[Tobias Wendorff]

Hi Burghardt,

thanks a lot for your test. I've just filed it as a bug.

Right now, the data isn't in PostgreSQL. For this project, I'm working
with GPKG, Shapefiles and temporary layers only.

Until the problem get fixed, I need to work with the join functions
from processing (or import the data in a DB, like you suggested).

Best regards,
Tobias


Am Fr, 17.08.2018, 07:44 schrieb 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
>