<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Nothing in the logs, sorry.<br>
</p>
<div class="moz-cite-prefix">On 2021/09/23 12:59, Etienne Trimaille
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAO0ca9CM_-mYJXv8+dDTekkRgW5RHb7Z1bVDHWwp9H2jm2rK+A@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">The logs are in lizmap/var/log/<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">Le jeu. 23 sept. 2021 à 12:34,
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>I checked the logs, nothing in the error logs, at least
not looking in the admin interface. Where do I find the
logs on the server?<br>
</p>
<p>I'll try the foreign data wrapper or copy the table over
to be in the same database and then create the join. That
should work.</p>
<p>Immo<br>
</p>
<div>On 2021/09/23 12:20, Etienne Trimaille wrote:<br>
</div>
<blockquote type="cite">
<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" target="_blank"
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 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" 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_1808717176976471763gmail-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" 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">
<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>-- <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_1808717176976471763gmail-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">
<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>-- <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_1808717176976471763WISESTAMP_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" 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>