[QGIS-Developer] Filtering features in a layer by a report group

[Tim Sutton]

Hi

Sorry small correction:

> Ideally I should set my filter of my vegetation layer based on the atlas feature id like this:  "plant_type_id" = attribute(@atlas_feature,id)

Should have read:

"plant_type_id" = @atlas_feature,id

I added a fake point geom to my lookup table and it lets me control map by report now, though still trying to figure out how to get the atlas current feature in my symbology rule.

Regards

Tim

> On 7 Aug 2019, at 07:22, Tim Sutton <tim at kartoza.com> wrote:
> 
> Hi All
> 
> I am trying to create a section in my report (not layout) which iterates over my plant types lookup table and applies a filter to my vegetation points layer based on the plant type ID.
> 
> Ideally I should set my filter of my vegetation layer based on the atlas feature id like this:  "plant_type_id" = attribute(@atlas_feature,id)
> 
> Instead I tried to make a rule using the same above expression so that symbols are blank for non matching plant features.
> 
> However in my report group, ‘Controlled by report’ is greyed out for my map and so when rendering the report the map comes out as a single blank copy instead of one per plant type. 
> 
> I suspect this is because report wants to have geometries to zoom to for each record. Other than adding a fake geometry column to my plant type lookup table, is there any way to get reporting to control my map by report when the reporting layer is a non-spatial table?
> 
> 
> Side note: QGIS layer filtering is a "poor relation” it is one of the few places in QGIS where a non standard expression editor is used. The other major one was the raster calculator but now at least we have the raster calculator processing algorithm.
> 
> BTW using 3.8 on macOS here.
> 
> 
> Thanks!
> 
> Regards
> 
> Tim
> —
> 
> 
> <KartozaNewLogoThumbnail.jpg>
> 
> 
> 
> 
> 
> 
> Tim Sutton
> 
> Co-founder: Kartoza
> Ex Project chair: QGIS.org <http://qgis.org/>
> 
> Visit http://kartoza.com <http://kartoza.com/> to find out about open source:
> 
> Desktop GIS programming services
> Geospatial web development
> GIS Training
> Consulting Services
> 
> Skype: timlinux 
> IRC: timlinux on #qgis at freenode.net <http://freenode.net/>
> 
> I'd love to connect. Here's my calendar link <https://calendly.com/timlinux> to make finding time easy.
> 

—









Tim Sutton

Co-founder: Kartoza
Ex Project chair: QGIS.org

Visit http://kartoza.com <http://kartoza.com/> to find out about open source:

Desktop GIS programming services
Geospatial web development
GIS Training
Consulting Services

Skype: timlinux 
IRC: timlinux on #qgis at freenode.net

I'd love to connect. Here's my calendar link <https://calendly.com/timlinux> to make finding time easy.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190807/de9f65e3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KartozaNewLogoThumbnail.jpg
Type: image/jpeg
Size: 6122 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20190807/de9f65e3/attachment-0001.jpg>