LWC send userid to postgis layer column

[pierluigiderosa]

Dear All,

In case of editing layer I would like to save the userid in a specific column (ie User) in the attribute table of the layer.
I saw some posts quite old like:

How to send current login User-ID to PostgreSQL

So maybe now there is a simpler solution? even because the link is not working anymore.

I did not understand whether LWC users should be saved in sqlite or postgres. For now I have user saved in sqlite

Thanks for your help

[etrimaille]

@pierluigiderosa

So maybe now there is a simpler solution? even because the link is not working anymore.

One solution, for creating new objets only (because expressions are not evaluated totally for edition):

Lizmap - Documentation

Otherwise, for JS, the corrected link :

Lizmap - Documentation

I did not understand whether LWC users should be saved in sqlite or postgres. For now I have user saved in sqlite

This is up to you. If you want your users/groups to be in a SQLite file or in PostreSQL … (for backup, to do SQL join with users&groups …)