[Lizmap] Filter misbehaving?

[Nicolas Boisteault]

All providers others than postgres as far as I understand the code.

Le 05/02/2020 à 19:18, Paolo Cavallini a écrit :
> Merci Nicolas.
> So the issue should be limited to gpkg?
> Cheers.
>
> Il 05/02/20 10:49, Nicolas Boisteault ha scritto:
>> Paolo,
>>
>> Both fields return errors in console:
>>
>> Invalid Query: Erreur dans la requête (misuse of aggregate function
>> Min() ( SELECT  Min(Min("capacity_m")) AS min, Max(Max("capacity_m")) AS
>> max FROM power WHERE 2>1))
>> Invalid Query: Erreur dans la requête (misuse of aggregate function
>> Min() ( SELECT  Min(Min("year_of_ca")) AS min, Max(Max("year_of_ca")) AS
>> max FROM power WHERE 2>1))
>>
>> As a workaround, I think you can put your 'power' layer in postgresql
>> and it should work.
>>
>> Michaël, something is wrong here :
>> https://github.com/3liz/lizmap-web-client/blob/release_3_3/lizmap/modules/filter/classes/filterDatasource.class.php#L278
>>
>> Le 31/01/2020 à 19:10, Paolo Cavallini a écrit :
>>> Furthermore, Numeric type filters do not seem to work, as they do not
>>> appear in the dialog, even if I have configured it, see attached.
>>> Cheers.
>>>
>>> Il 31/01/20 19:02, Paolo Cavallini ha scritto:
>>>> Hi all,
>>>> I'm experimenting with filters, and I think I've vound a bug:
>>>> * go to
>>>> https://lizmap.faunalia.eu/index.php/view/map/?repository=foss4gto&project=filter
>>>> * activate filter
>>>> * type `ita` in the box `Nazione`
>>>> * you'll find Italy and Mauritania
>>>> * choose Italy, which will appear in the text box
>>>> * both Italy and Mauritania will be shown on the map
>>>> * if you type `italy` (full name, only Italian points will be displayed.
>>>> QGIS 3.4.15, LM 3.3.3.
>>>> Should I file a ticket?
>>>> Cheers.
>>>>
>>> _______________________________________________
>>> Lizmap mailing list
>>> Lizmap at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/lizmap
>> -- 
>> Nicolas Boisteault
>> Ingénieur
>> www.3liz.com <http://www.3liz.com>
>>
>> *Tel.* 06 19 36 78 32
>> *Bureau*
>> 31, rue de l'Argenterie
>> <https://maps.google.com/?q=31,+rue+de+l'Argenterie+34000+Montpellier&entry=gmail&source=g>
>> 34000 Montpellier
>> <https://maps.google.com/?q=31,+rue+de+l'Argenterie+34000+Montpellier&entry=gmail&source=g>
>> *Siège social*
>> 73, allée Kleber
>> <https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g>
>> Boulevard de Strasbourg
>> <https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g>
>> 34000 Montpellier
>> <https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g>
>>
>> _______________________________________________
>> Lizmap mailing list
>> Lizmap at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/lizmap
>>
-- 
Nicolas Boisteault
Ingénieur
www.3liz.com <http://www.3liz.com>

*Tel.* 06 19 36 78 32
*Bureau*
31, rue de l'Argenterie 
<https://maps.google.com/?q=31,+rue+de+l'Argenterie+34000+Montpellier&entry=gmail&source=g> 

34000 Montpellier 
<https://maps.google.com/?q=31,+rue+de+l'Argenterie+34000+Montpellier&entry=gmail&source=g> 

*Siège social*
73, allée Kleber 
<https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g> 

Boulevard de Strasbourg 
<https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g> 

34000 Montpellier 
<https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20200205/3ce9d0be/attachment.html>