I'm trying to make query from field calculator so that it would be possible to connect to PostGIS layer (or local file on computer) and select data according to condition so that use this selection afterwards for layer in project.
Is it possible?
I've found great functions in Reffunctions plugin - e.g. dbvalue, that retrieve first targetField value from targetLayer when keyField is equal to conditionValue;
dbquery, that retrieve first targetField value from targetLayer when whereClause is true (for file in project) - this function seems to not work
But all these functions require a layer in a project, altough I wonder to connect to PostGIS layer or local file in a query. I suppose I will need to create custom function in function builder, but I don't know how turn to local or PostGIS layer from QGIS via python.
"NameError: name 'self' is not defined"
also don't add a PostGIS layer
I tried single quotes instead of double, but it doesn't help. Local file adds successfully after replacing single delimiter to double in path to file.