<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<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 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>