lizmap-web-client icon indicating copy to clipboard operation
lizmap-web-client copied to clipboard
verified publisher icon 3liz

[Question]: allow NULL value in Relation Reference widget

Open RobiFag opened this issue 3 years ago • 3 comments

What is the question?

Hi all! Is the option "allow NULL value" in the the relation reference widget supported by Lizmap? Because in the Lizmap edition tool the field with widget relation reference is mandatory even if I set the option "allow NULL value", obviously the NOT NULL constraint is not set.

image

image

Versions

The QGIS project has been created with QGIS 3.22.9-Białowieża (installed via osgeo4w on Windows 10), Lizmap Plugin version 3.8.3 Lizmap version 3.5.4

Check Lizmap plugin

  • [X] I have done the step just before in the Lizmap QGIS desktop plugin before opening this ticket. Otherwise, my ticket is not considered valid and might get closed.

QGIS server version, only if the section above doesn't mention the QGIS Server version

3.16.16

Operating system

Server Ubuntu 18.04.6, PC Windows 10

Browsers

Chrome

Browsers version

Versione 104.0.5112.102

Relevant log output

No response

RobiFag avatar Sep 01 '22 13:09 RobiFag

Have you tried publishing using the same QGIS Desktop version as the QGIS Server version (3.16)? I note they are different. (this functionality does work on my install: 3.16 desktop, 3.16 server, 3.5.3 LMWC

timbo-barnes avatar Sep 01 '22 20:09 timbo-barnes

QGIS Desktop 3.22.9 QGIS Server 3.16.16

I don't know if it's related to your issue but indeed you are running into issues. You are asking QGIS Server (3.16) to read a QGS project generated with 3.22, so in the future compare to server 3.16.

We have some tests projects having NULL, I think I haven't checked with a relation reference https://demo.snap.lizmap.com/lizmap_3_6/index.php

Gustry avatar Sep 02 '22 08:09 Gustry

I tried to create and publish the project with QGIS 3.16.16 (QGIS Server 3.16.16 and Lizmap 3.5.1/3.5.3/3.5.4) but I got the same problem. The column with the relation reference widget is mandatory on lizmap edition tool even if the "allow NULL value" option is set.

RobiFag avatar Sep 02 '22 09:09 RobiFag

Hiya! This issue has gone quiet. 👻 We get a few questions in the bug tracker, we are currently slowly closing issues. If we missed this issue or if you want to keep it open, please reply here. As a friendly reminder: the best way to see this issue, or any other, fixed is to open a Pull Request. Thanks for being a part of the Lizmap community! 🦎

3liz-bot avatar Mar 06 '23 04:03 3liz-bot