<div dir="ltr"><div>The dataviz module in LWC is making some SQL queries straight to the database. (without using QGIS Server/WFS to improve performance)<br></div><div>So it might be that the SQL query is failing due to missing fields (which are only in QGIS).</div><div><br></div><div>But when the SQL query to PG is failing, LWC should fallback on WFS (so using QGIS) and the join must be there.</div><div><br></div><div>Maybe you hit a bug ? Do you have somethings in the Lizmap logs ? (the SQL query must be logged when it's failing)<br></div><div><br></div><div>Maybe you can a foreign datawrapper in Postgresql to make the join there ?<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le jeu. 23 sept. 2021 à 11:56, Immo Blecher <<a href="mailto:immo@blecher.co.za">immo@blecher.co.za</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Etienne,</p>
<p>I am adding the join in QGIS layer properties, as the table with
the data is in a different PostgreSQL database.</p>
<p>RC2 works well so far. Looking forward to final. I will check out
3.6 plugin, thanks.</p>
<p>Immo<br>
</p>
<div>On 2021/09/23 11:52, Etienne Trimaille
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>Where are you adding the join ? In the PG view or in QGIS
Layer properties ?</div>
<div><br>
</div>
<div>Nice that you are trying 3.5 RC 2.</div>
<div>We have just released Lizmap plugin 3.6.0 which add the
last new feature for LWC 3.5 : filtering by polygon.<br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Le jeu. 23 sept. 2021 à 11:49,
Immo Blecher <<a href="mailto:immo@blecher.co.za" target="_blank">immo@blecher.co.za</a>> a écrit :<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Everyone,</p>
<p>I have a weird Dataviz problem: I am using a PostgreSQL
view to extract data from a database with Date/Time as
X-axis and different values on y-axis. So basically ID,
sitenr, date, value fields. The Dataviz charts work
perfectly, but: as soon as I add a join with other tables
to add additional fields, the charts stop working.</p>
<p>Is it supposed to work like that? Are joins not allowed
for the charts to keep working? Or what must I do to keep
the charts working?</p>
<p>Setup:</p>
<p>Linux server with PostgreSQL and QGIS 3.16 LTR, Lizmap
3.5 RC2, QGIS 3.16 LTR desktop on Ubuntu 20.04<br>
</p>
<p>Thanks</p>
<div>-- <br>
<p style="border:medium none;padding:0cm;background:transparent none repeat scroll 0% 0%"> <strong><font color="#000000"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">Immo F. Blecher</font></font></font></strong><strong><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><br>
</font></font></font></strong><em><span style="font-variant:normal"><font color="#000000"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><span style="font-style:normal"><b>Mobile:</b></span></font></font></font></span></em><em><font color="#000000"> </font></em><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">+27 83 272 6791 </font></font></font><font color="#ff6600"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">|</font></font></font><font color="#666666"> </font><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">+49</font></font></font><font color="#808080"> </font><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">1512</font></font></font><font color="#808080"> </font><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">639 6176<br>
</font></font></font><font color="#000000"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><b>Email:</b></font></font></font><font color="#808080"> </font><a href="mailto:immo@blecher.co.za" target="_blank"><font color="#0000ff"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><u>immo@blecher.co.za</u></font></font></font></a>
<font color="#ff6600"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">| </font></font></font><a href="mailto:immob19@gmail.com" target="_blank"><font color="#0000ff"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><u>immob19@gmail.com</u></font></font></font></a><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><br>
</font></font><font color="#000000"><span style="text-decoration:none"><font face="FreeSans,
sans-serif"><font style="font-size:10pt" size="2"><b>Internet:</b></font></font></span></font><font color="#666666"><span style="text-decoration:none"> </span></font><a href="https://www.blecher.co.za/" target="_blank"><font color="#0000ff"><span style="text-decoration:none"><font face="FreeSans,
sans-serif"><font style="font-size:10pt" size="2"><u>https://www.blecher.co.za/</u></font></font></span></font></a></p>
<p style="border:medium none;padding:0cm;background:transparent none repeat scroll 0% 0%;text-decoration:none"> <font face="FreeSans, sans-serif"><font style="font-size:8pt" size="1">Please consider your
environmental responsibility. Before printing this
e-mail message, ask yourself whether you really need
a hard copy.</font></font></p>
<div id="gmail-m_8259474488773230486gmail-m_-310789483911240942WISESTAMP_SIG_9425" dir="ltr">
<p style="margin-bottom:0cm;border-color:rgb(128,128,128) currentcolor;border-style:solid none;border-width:1px medium;padding:0.2cm 0cm"> <font face="FreeSans,
sans-serif"><font style="font-size:8pt" size="1"><font color="#ff0000"><b>IMPORTANT</b></font><font color="#ff0000">: </font><font color="#808080">The
contents of this email and any attachments are
confidential. They are intended for the named
recipient(s) only. If you have received this
email by mistake, please notify the sender
immediately and do not disclose the contents to
anyone or make copies thereof.</font></font></font></p>
</div>
</div>
</div>
_______________________________________________<br>
Lizmap mailing list<br>
<a href="mailto:Lizmap@lists.osgeo.org" target="_blank">Lizmap@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/lizmap</a><br>
</blockquote>
</div>
<br clear="all">
<br>
-- <br>
<div dir="ltr">
<div dir="ltr">
<div>
<div dir="ltr">
<div>
<div dir="ltr">
<p> <span style="font-weight:bold;color:rgb(154,205,50)">Etienne
Trimaille</span> <br>
Ingénieur géomaticien <br>
<a href="http://www.3liz.com" style="text-decoration:none;color:rgb(154,205,50)" target="_blank">www.3liz.com</a>
<br>
</p>
<p><span style="font-size:0.8em"> +33 6 12 93 11 39<br>
</span></p>
<p><span style="font-size:0.8em"> <br>
<b>Siège social</b> <br>
73, allée Kleber <br>
Boulevard de Strasbourg <br>
34000 Montpellier </span> </p>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
<div>-- <br>
<p style="border:medium none;padding:0cm;background:transparent none repeat scroll 0% 0%">
<strong><font color="#000000"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">Immo
F. Blecher</font></font></font></strong><strong><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><br>
</font></font></font></strong><em><span style="font-variant:normal"><font color="#000000"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><span style="font-style:normal"><b>Mobile:</b></span></font></font></font></span></em><em><font color="#000000">
</font></em><font color="#808080"><font face="FreeSans,
sans-serif"><font style="font-size:10pt" size="2">+27
83 272 6791 </font></font></font><font color="#ff6600"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">|</font></font></font><font color="#666666">
</font><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">+49</font></font></font><font color="#808080">
</font><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">1512</font></font></font><font color="#808080">
</font><font color="#808080"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">639
6176<br>
</font></font></font><font color="#000000"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><b>Email:</b></font></font></font><font color="#808080">
</font><a href="mailto:immo@blecher.co.za" target="_blank"><font color="#0000ff"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><u>immo@blecher.co.za</u></font></font></font></a>
<font color="#ff6600"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2">|
</font></font></font><a href="mailto:immob19@gmail.com" target="_blank"><font color="#0000ff"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><u>immob19@gmail.com</u></font></font></font></a><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><br>
</font></font><font color="#000000"><span style="text-decoration:none"><font face="FreeSans,
sans-serif"><font style="font-size:10pt" size="2"><b>Internet:</b></font></font></span></font><font color="#666666"><span style="text-decoration:none">
</span></font><a href="https://www.blecher.co.za/" target="_blank"><font color="#0000ff"><span style="text-decoration:none"><font face="FreeSans, sans-serif"><font style="font-size:10pt" size="2"><u>https://www.blecher.co.za/</u></font></font></span></font></a></p>
<p style="border:medium none;padding:0cm;background:transparent none repeat scroll 0% 0%;text-decoration:none">
<font face="FreeSans, sans-serif"><font style="font-size:8pt" size="1">Please
consider your environmental responsibility. Before printing
this
e-mail message, ask yourself whether you really need a hard
copy.</font></font></p>
<div id="gmail-m_8259474488773230486WISESTAMP_SIG_9425" dir="ltr">
<p style="margin-bottom:0cm;border-color:rgb(128,128,128) currentcolor;border-style:solid none;border-width:1px medium;padding:0.2cm 0cm"> <font face="FreeSans, sans-serif"><font style="font-size:8pt" size="1"><font color="#ff0000"><b>IMPORTANT</b></font><font color="#ff0000">: </font><font color="#808080">The
contents of this email and any attachments are
confidential. They are intended for the named
recipient(s) only. If you have received this email by
mistake, please notify the sender immediately and do not
disclose the contents to anyone or make copies thereof.</font></font></font></p>
</div>
</div>
</div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><p> <span style="font-weight:bold;color:rgb(154,205,50)">Etienne Trimaille</span>
<br>Ingénieur géomaticien <br>
<a href="http://www.3liz.com" style="text-decoration:none;color:rgb(154,205,50)" target="_blank">www.3liz.com</a> <br>
</p><p><span style="font-size:0.8em"> +33 6 12 93 11 39<br></span></p><p><span style="font-size:0.8em">
<br>
<b>Siège social</b> <br>
73, allée Kleber <br>
Boulevard de Strasbourg <br>
34000 Montpellier </span>
</p></div></div></div></div></div></div>