[Lizmap] Dataviz problem
Immo Blecher
immo at blecher.co.za
Thu Sep 23 04:17:23 PDT 2021
Nothing in the logs, sorry.
On 2021/09/23 12:59, Etienne Trimaille wrote:
> The logs are in lizmap/var/log/
>
> Le jeu. 23 sept. 2021 à 12:34, Immo Blecher <immo at blecher.co.za
> <mailto:immo at blecher.co.za>> a écrit :
>
> 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.
>
>
>
> --
>
> 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/589781ea/attachment-0001.html>
More information about the Lizmap
mailing list