[Lizmap] Filter misbehaving?

[Paolo Cavallini]

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
> 

-- 
Paolo Cavallini - www.faunalia.eu
QGIS.ORG Chair:
http://planet.qgis.org/planet/user/28/tag/qgis%20board/