value by default in postgresql table does not appear in lizmap

[jancelin]

the value by default in postgresql table does not appear in lizmap but work fine in qgis

[mdouchin]

Could you be more specific ? If I understand correctly, you have some fields in your table with a default value set, and this value is not used when the user does not write another value in Lizmap form for this field ?

[jancelin]

Sorry, It's for a postgresql view, not a table:

CREATE OR REPLACE VIEW inv_gps_view AS
SELECT row_number() OVER () AS unique_id, inventaire_gps.ig_id,
inventaire_gps.ig_date, inventaire_gps.ig_buffer, inventaire_gps.ig_cla_id,
classe_quantite.cla_gps2, inventaire_gps.ig_id_plante,
t_plante.nom_francais, inventaire_gps.ig_terrain_id, t_terrain.type_terrain,
inventaire_gps.ope_id, operateur_utilisateur.ope_nom_pre,
inventaire_gps.geom
FROM t_terrain, t_plante, operateur_utilisateur,
inventaire_gps
LEFT JOIN classe_quantite ON inventaire_gps.ig_cla_id = classe_quantite.cla_id
WHERE inventaire_gps.ig_id_plante = t_plante.id_plante AND inventaire_gps.ig_terrain_id = t_terrain.id_terrain AND inventaire_gps.ope_id = operateur_utilisateur.ope_id;

ALTER TABLE inv_gps_view
OWNER TO postgres;
ALTER TABLE inv_gps_view ALTER COLUMN ig_buffer SET DEFAULT 3000;

My default value is 3000 but it's not appear in lizmap

[jancelin]

works well, thanks

[mdouchin]

@jancelin Can you test again with your view (described above) in Lizmap release_3_0 by commenting this line ?
https://github.com/3liz/lizmap-web-client/blob/release_3_0/lizmap/modules/lizmap/controllers/edition.classic.php#L1163

I tried it myself with a very simple view, and this is not needed anymore since some further modifications in the edition code. Grabing default values representation from PostgreSQL and putting it in the form leads to side effects such as #417

[mdouchin]

ping @jancelin ;)

[rldhont]

Reopened if a9cd647 not help

[jancelin]

I test in January, désolé du retard mais je sème mon orge de brasserie.

[jancelin]

hi,
I just tested with version 3.1beta4

• The default value for the integer works well.
• The default value for a relational value on a table edition is OK
• The default value for a relational value on a View edition is not available, The same if we edit the default value of qgis.