[Lizmap] Filter misbehaving?

[Nicolas Boisteault]

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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/lizmap/attachments/20200205/03584eb5/attachment.html>