I have a set of symbols based on a table in postgis such as this
id|type|action_1|action_2|geom In QGIS I have this table symbolised using a rule expression which works effectively.
However this table was setup as a bit of a rush job, as it doesn't adhere to 3NF structure and is inflexible (i.e. what if more than 2 actions needed). As such the structure is now:
Table 1
id|type Table 2
id|tbl_1_id|action Where I have a 1-n relationship between table 1 and table 2. I have incorporated the forms and entering data works perfect. However I am trying to incorporate the same rule based symbology as I had previously.
I have tried using the reffuntion plugin, which doesn't do this (or I haven't been using correctly). I have tried creating a view in my database and joining it to table one so I have a field which I can then symbolise on. However when I edit the data, the view table does update - however the joined table does not update - even after pressing the refresh data button.
Any thoughts on how to symbolise based on two tables OR refreshing data in joined tables would be great.
أكثر...
id|type|action_1|action_2|geom In QGIS I have this table symbolised using a rule expression which works effectively.
However this table was setup as a bit of a rush job, as it doesn't adhere to 3NF structure and is inflexible (i.e. what if more than 2 actions needed). As such the structure is now:
Table 1
id|type Table 2
id|tbl_1_id|action Where I have a 1-n relationship between table 1 and table 2. I have incorporated the forms and entering data works perfect. However I am trying to incorporate the same rule based symbology as I had previously.
I have tried using the reffuntion plugin, which doesn't do this (or I haven't been using correctly). I have tried creating a view in my database and joining it to table one so I have a field which I can then symbolise on. However when I edit the data, the view table does update - however the joined table does not update - even after pressing the refresh data button.
Any thoughts on how to symbolise based on two tables OR refreshing data in joined tables would be great.
أكثر...