search

3liz / qgis-pgmetadata-plugin

QGIS Plugin to manage some metadata from PostgreSQL layer
GNU General Public License v2.0
12 stars 10 forks source link

Create new Fields in Dataset Table that can be used in HTML Template #121

Open petrik13 opened 2 years ago

petrik13 commented 2 years ago

My name is Petrik and I want to implement the pgmetadata solution in one of my clients. I tried create new fields in "Dataset table" and I need show this fields in HTML template. So I edited the HTML template to show them. (attachment)

The fields that have been before it's ok but the fields that I created, not. Is it possible to create what I need?

Thanks unnamed !

effjot commented 2 years ago

Do you mean a tool/setting to add user-defined metadata fields? I guess as a general solution this will be a bit tricky, because various views and maybe PL/SQL functions have to be modified. Then it would be difficult to keep the database structure upgradable, because the upgrade scripts would need to be careful not to destroy the user-defined fields.

Maybe instead we could add a new table to the metadatabase specifically for user-defined fields, which is nevere touched during upgrade?

effjot commented 2 years ago

@Gustry What do you think?