<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">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">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_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">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_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">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_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">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>