QGIS action loading layer in GPKG

Question

I have a kind of "vector catalog" in a GPKG. It's different rectangles with an attribute called "name of the layer".

In the same GPKG, I have all the different layers.

I'm trying to build an action in my vector catalog, so when I click on the rectangle I want, it loads the corresponding layer in QGIS.

I found some questions about loading raster, but I wasn't able to do something like that for vectors.

Is it possible?

Answer 1

You can find below solution to do the job

The full code is the following

from qgis.core import (
    QgsVectorLayer
)
# Change to your own GPKG path
path_to_gpkg = "path/to/your/own.gpkg"
# Replace [%layer_name%] with [%yourcolumnwithgpkglayername%]
gpkg_layer = path_to_gpkg + "|layername=[%layer_name%]"
vlayer = QgsVectorLayer(gpkg_layer, "[%layer_name%]", "ogr")
if not vlayer.isValid():
    print("Layer failed to load!")
else:
    QgsProject.instance().addMapLayer(vlayer)

Ive made a screen capture to illustrate the action