[Lizmap] Dataviz problem

[Immo Blecher]

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?

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.

Immo

On 2021/09/23 12:20, Etienne Trimaille wrote:
> The dataviz module in LWC is making some SQL queries straight to the 
> database. (without using QGIS Server/WFS to improve performance)
> So it might be that the SQL query is failing due to missing fields 
> (which are only in QGIS).
>
> But when the SQL query to PG is failing, LWC should fallback on WFS 
> (so using QGIS) and the join must be there.
>
> Maybe you hit a bug ? Do you have somethings in the Lizmap logs ? (the 
> SQL query must be logged when it's failing)
>
> Maybe you can a foreign datawrapper in Postgresql to make the join there ?
>
> Le jeu. 23 sept. 2021 à 11:56, Immo Blecher <immo at blecher.co.za 
> <mailto:immo at blecher.co.za>> a écrit :
>
>     Hi Etienne,
>
>     I am adding the join in QGIS layer properties, as the table with
>     the data is in a different PostgreSQL database.
>
>     RC2 works well so far. Looking forward to final. I will check out
>     3.6 plugin, thanks.
>
>     Immo
>
>     On 2021/09/23 11:52, Etienne Trimaille wrote:
>>     Where are you adding the join ? In the PG view or in QGIS Layer
>>     properties ?
>>
>>     Nice that you are trying 3.5 RC 2.
>>     We have just released Lizmap plugin 3.6.0 which add the last new
>>     feature for LWC 3.5 : filtering by polygon.
>>
>>     Le jeu. 23 sept. 2021 à 11:49, Immo Blecher <immo at blecher.co.za
>>     <mailto:immo at blecher.co.za>> a écrit :
>>
>>         Hi Everyone,
>>
>>         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.
>>
>>         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?
>>
>>         Setup:
>>
>>         Linux server with PostgreSQL and QGIS 3.16 LTR, Lizmap 3.5
>>         RC2, QGIS 3.16 LTR desktop on Ubuntu 20.04
>>
>>         Thanks
>>
>>         -- 
>>
>>         *Immo F. Blecher**
>>         */*Mobile:*///+27 83 272 6791 |+491512639 6176
>>         *Email:*_immo at blecher.co.za_ <mailto:immo at blecher.co.za> |
>>         _immob19 at gmail.com_ <mailto:immob19 at gmail.com>
>>         *Internet:*_https://www.blecher.co.za/_
>>         <https://www.blecher.co.za/>
>>
>>         Please consider your environmental responsibility. Before
>>         printing this e-mail message, ask yourself whether you really
>>         need a hard copy.
>>
>>         *IMPORTANT*: 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.
>>
>>         _______________________________________________
>>         Lizmap mailing list
>>         Lizmap at lists.osgeo.org <mailto:Lizmap at lists.osgeo.org>
>>         https://lists.osgeo.org/mailman/listinfo/lizmap
>>         <https://lists.osgeo.org/mailman/listinfo/lizmap>
>>
>>
>>
>>     -- 
>>
>>     Etienne Trimaille
>>     Ingénieur géomaticien
>>     www.3liz.com <http://www.3liz.com>
>>
>>     +33 6 12 93 11 39
>>
>>
>>     *Siège social*
>>     73, allée Kleber
>>     Boulevard de Strasbourg
>>     34000 Montpellier
>>
>     -- 
>
>     *Immo F. Blecher**
>     */*Mobile:*///+27 83 272 6791 |+491512639 6176
>     *Email:*_immo at blecher.co.za_ <mailto:immo at blecher.co.za> |
>     _immob19 at gmail.com_ <mailto:immob19 at gmail.com>
>     *Internet:*_https://www.blecher.co.za/_ <https://www.blecher.co.za/>
>
>     Please consider your environmental responsibility. Before printing
>     this e-mail message, ask yourself whether you really need a hard copy.
>
>     *IMPORTANT*: 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.
>
>
>
> -- 
>
> Etienne Trimaille
> Ingénieur géomaticien
> www.3liz.com <http://www.3liz.com>
>
> +33 6 12 93 11 39
>
>
> *Siège social*
> 73, allée Kleber
> Boulevard de Strasbourg
> 34000 Montpellier
>
-- 

*Immo F. Blecher**
*/*Mobile:*///+27 83 272 6791 |+491512639 6176
*Email:*_immo at blecher.co.za_ <mailto:immo at blecher.co.za> | 
_immob19 at gmail.com_ <mailto:immob19 at gmail.com>
*Internet:*_https://www.blecher.co.za/_ <https://www.blecher.co.za/>

Please consider your environmental responsibility. Before printing this 
e-mail message, ask yourself whether you really need a hard copy.

*IMPORTANT*: 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20210923/7139778c/attachment-0001.html>