Feature request #11424
QGIS Attribute table - visual cue for immutable columns
|Pull Request or Patch supplied:||No||Resolution:|
|Easy fix?:||No||Copied to github as #:||19700|
Basically if you use postgis you may have columns that update using triggers automatically, maybe having a visual cue (highlight the column) would make it easier for technicians to know those columns are filled using triggers. See attached, maybe even have the possibility to change the color to the one you desire
#2 Updated by Matthias Kuhn over 6 years ago
Currently, QGIS has no knowledge about such information from postgres. Is it possible to detect this without inspecting the triggers themselves (possibly even parsing them)?
That said, I assume you will have to set this manually.
An option I could imagine is, that you set the fields to not-editable (you probably do not want users to edit them as this can be overwritten by the trigger). That already works. A slight improvement could be to e.g. add a lock icon to the table header.
Another feature could be to define colors for columns that would be used in the attribute table (and maybe feature forms). This feature would be disconnected from triggers/editable state of the widget etc and purely visual.
#3 Updated by Antonio Locandro over 6 years ago
That sounds ok! So I would need to create a template project to give to other technicians before hand correct? (This is done in the Edit Widget correct). The lock icon would provide visual cue and would be a nice addition.
I don't quite grasp the color part.
#4 Updated by Matthias Kuhn over 6 years ago
Yep, the first one is related to edit widgets and the lock Icon would be a feature request for the visual cue.
The color part would be a completely new feature request, to let you manually define arbitrary colors for attributes. Not sure though if that's something that people are waiting for.