<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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 class="moz-cite-prefix">On 2021/09/23 11:52, Etienne Trimaille
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAO0ca9C7-Hs+gHgjYZGr96TmqyYTd5w137NS1kvNaCrWLoy93Q@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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"
moz-do-not-send="true"><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"
moz-do-not-send="true"><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"
moz-do-not-send="true"><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_-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"
moz-do-not-send="true">Lizmap@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/lizmap"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/lizmap</a><br>
</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" moz-do-not-send="true">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 class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>
<meta name="generator" content="LibreOffice 6.4.7.2 (Linux)">
<meta name="created" content="00:00:00">
<meta name="changedby" content="Immo Blecher">
<meta name="changed" content="2021-08-12T10:48:37.299434663">
<meta name="created" content="00:00:00">
<meta name="created" content="00:00:00">
<style type="text/css">
@page { size: 21cm 29.7cm; margin-left: 2cm; margin-right: 1cm; margin-top: 1cm; margin-bottom: 1cm }
p { margin-bottom: 0.25cm; background: transparent; color: #000000; line-height: 115%; background: transparent }
strong { font-weight: bold }
em { font-style: italic }
a:link { color: #000080; so-language: zxx; text-decoration: underline }
a:visited { color: #800000; so-language: zxx; text-decoration: underline }
</style>
<p style="border: none; padding: 0cm; background: transparent">
<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"><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"><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/"><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: none; padding: 0cm; background: transparent;
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="WISESTAMP_SIG_9425" dir="ltr">
<p style="margin-bottom: 0cm; border-top: 1px solid #808080;
border-bottom: 1px solid #808080; border-left: none;
border-right: none; 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>
</body>
</html>