Hfrhyu

Is it dangerous to install hacking tools on my private linux machine?

White walkers, cemeteries and wights

Can you force honesty by using the Speak with Dead and Zone of Truth spells together?

Can humans save crash-landed aliens?

Relating to the President and obstruction, were Mueller's conclusions preordained?

Why is it faster to reheat something than it is to cook it?

Does the Black Tentacles spell do damage twice at the start of turn to an already restrained creature?

I got rid of Mac OSX and replaced it with linux but now I can't change it back to OSX or windows

Putting class ranking in CV, but against dept guidelines

Resize vertical bars (absolute-value symbols)

i2c bus hangs in master RPi access to MSP430G uC ~1 in 1000 accesses

Co-worker has annoying ringtone

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

Why not send Voyager 3 and 4 following up the paths taken by Voyager 1 and 2 to re-transmit signals of later as they fly away from Earth?

A term for a woman complaining about things/begging in a cute/childish way

Why is the change of basis formula counter-intuitive? [See details]

If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?

Sally's older brother

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

Is there hard evidence that the grant peer review system performs significantly better than random?

What is the "studentd" process?

what is the log of the PDF for a Normal Distribution?

Special flights

Simple HTTP Server

QGIS 3 Value Relation current_value() not working in custom ui form

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have a custom UI form made with Qt Designer with a couple of dropdown list, so I can easily edit a layer. I use a Value Relation on those fields to filter the displayed data. The problem is the function current_value() is not working when I use a provided ui file, but it works perfectly when I use the default autogenerated form. I've tried this both programatically and through the Layer Properties interface with the same result. I guess the problem is the function current_value() doesn't find the field to be filtered by, but I don't know how to point to that field correctly on my custom form. I want to set the state first, and then show only the towns that are on that state.

The form widget name is the same as the field name. I tried this both in QGIS 3.4.3 and 3.6.1. This is the code I used, though it worked fine on default form. Im I missing something or is this a bug ?

myLayer = QgsVectorLayer(uri.uri(), 'myLayer', 'postgres')
states = QgsVectorLayer(uri.uri(), 'states', 'postgres')
towns = QgsVectorLayer(uri.uri(), 'towns', 'postgres')

stateIndex = myLayer.fields().indexFromName('state')
townIndex = myLayer.fields().indexFromName('town')

myLayer.setEditorWidgetSetup(stateIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': states.id(),
 'Key': 'id',
 'Value': 'name'
 
))

myLayer.setEditorWidgetSetup(townIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': towns.id(),
 'Key': 'id',
 'Value': 'name',
 'FilterExpression': '"fk_state" = current_value('state')'
 
))

qgis pyqgis qgis-3 pyqt5

share|improve this question

edited Apr 12 at 12:55

J. Monticolo

1,958320

asked Apr 12 at 12:34

DanielDaniel

61

add a comment | 

1

I have a custom UI form made with Qt Designer with a couple of dropdown list, so I can easily edit a layer. I use a Value Relation on those fields to filter the displayed data. The problem is the function current_value() is not working when I use a provided ui file, but it works perfectly when I use the default autogenerated form. I've tried this both programatically and through the Layer Properties interface with the same result. I guess the problem is the function current_value() doesn't find the field to be filtered by, but I don't know how to point to that field correctly on my custom form. I want to set the state first, and then show only the towns that are on that state.

The form widget name is the same as the field name. I tried this both in QGIS 3.4.3 and 3.6.1. This is the code I used, though it worked fine on default form. Im I missing something or is this a bug ?

myLayer = QgsVectorLayer(uri.uri(), 'myLayer', 'postgres')
states = QgsVectorLayer(uri.uri(), 'states', 'postgres')
towns = QgsVectorLayer(uri.uri(), 'towns', 'postgres')

stateIndex = myLayer.fields().indexFromName('state')
townIndex = myLayer.fields().indexFromName('town')

myLayer.setEditorWidgetSetup(stateIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': states.id(),
 'Key': 'id',
 'Value': 'name'
 
))

myLayer.setEditorWidgetSetup(townIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': towns.id(),
 'Key': 'id',
 'Value': 'name',
 'FilterExpression': '"fk_state" = current_value('state')'
 
))

qgis pyqgis qgis-3 pyqt5

share|improve this question

edited Apr 12 at 12:55

J. Monticolo

1,958320

asked Apr 12 at 12:34

DanielDaniel

61

add a comment | 

I have a custom UI form made with Qt Designer with a couple of dropdown list, so I can easily edit a layer. I use a Value Relation on those fields to filter the displayed data. The problem is the function current_value() is not working when I use a provided ui file, but it works perfectly when I use the default autogenerated form. I've tried this both programatically and through the Layer Properties interface with the same result. I guess the problem is the function current_value() doesn't find the field to be filtered by, but I don't know how to point to that field correctly on my custom form. I want to set the state first, and then show only the towns that are on that state.

The form widget name is the same as the field name. I tried this both in QGIS 3.4.3 and 3.6.1. This is the code I used, though it worked fine on default form. Im I missing something or is this a bug ?

myLayer = QgsVectorLayer(uri.uri(), 'myLayer', 'postgres')
states = QgsVectorLayer(uri.uri(), 'states', 'postgres')
towns = QgsVectorLayer(uri.uri(), 'towns', 'postgres')

stateIndex = myLayer.fields().indexFromName('state')
townIndex = myLayer.fields().indexFromName('town')

myLayer.setEditorWidgetSetup(stateIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': states.id(),
 'Key': 'id',
 'Value': 'name'
 
))

myLayer.setEditorWidgetSetup(townIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': towns.id(),
 'Key': 'id',
 'Value': 'name',
 'FilterExpression': '"fk_state" = current_value('state')'
 
))

qgis pyqgis qgis-3 pyqt5

share|improve this question

edited Apr 12 at 12:55

J. Monticolo

1,958320

asked Apr 12 at 12:34

DanielDaniel

61

myLayer = QgsVectorLayer(uri.uri(), 'myLayer', 'postgres')
states = QgsVectorLayer(uri.uri(), 'states', 'postgres')
towns = QgsVectorLayer(uri.uri(), 'towns', 'postgres')

stateIndex = myLayer.fields().indexFromName('state')
townIndex = myLayer.fields().indexFromName('town')

myLayer.setEditorWidgetSetup(stateIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': states.id(),
 'Key': 'id',
 'Value': 'name'
 
))

myLayer.setEditorWidgetSetup(townIndex, QgsEditorWidgetSetup('ValueRelation', 
 'Layer': towns.id(),
 'Key': 'id',
 'Value': 'name',
 'FilterExpression': '"fk_state" = current_value('state')'
 
))

share|improve this question

edited Apr 12 at 12:55

J. Monticolo

1,958320

asked Apr 12 at 12:34

DanielDaniel

61

share|improve this question

edited Apr 12 at 12:55

J. Monticolo

1,958320

asked Apr 12 at 12:34

DanielDaniel

61

edited Apr 12 at 12:55

J. Monticolo

1,958320

edited Apr 12 at 12:55

J. Monticolo

1,958320

asked Apr 12 at 12:34

DanielDaniel

61

asked Apr 12 at 12:34

DanielDaniel

61