<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Paolo,<br>
</p>
<p>Both fields return errors in console:</p>
<p>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))<br>
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))</p>
<p>As a workaround, I think you can put your 'power' layer in
postgresql and it should work.<br>
</p>
<p>Michaël, something is wrong here : <a
href="https://github.com/3liz/lizmap-web-client/blob/release_3_3/lizmap/modules/filter/classes/filterDatasource.class.php#L278">https://github.com/3liz/lizmap-web-client/blob/release_3_3/lizmap/modules/filter/classes/filterDatasource.class.php#L278</a></p>
<div class="moz-cite-prefix">Le 31/01/2020 à 19:10, Paolo Cavallini
a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:dad914e2-779a-8322-9edd-4f04bff3d6e4@faunalia.it">
<pre class="moz-quote-pre" wrap="">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:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Hi all,
I'm experimenting with filters, and I think I've vound a bug:
* go to
<a class="moz-txt-link-freetext" href="https://lizmap.faunalia.eu/index.php/view/map/?repository=foss4gto&project=filter">https://lizmap.faunalia.eu/index.php/view/map/?repository=foss4gto&project=filter</a>
* 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.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Lizmap mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Lizmap@lists.osgeo.org">Lizmap@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/lizmap">https://lists.osgeo.org/mailman/listinfo/lizmap</a>
</pre>
</blockquote>
<div class="moz-signature">-- <br>
<span style="font-weight:bold;color:rgb(154,205,50)">Nicolas
Boisteault</span><br>
<span style="background-color:rgb(255,255,255)">Ingénieur</span><br>
<a href="http://www.3liz.com"
style="text-decoration:none;color:rgb(154,205,50)"
target="_blank">www.3liz.com</a>
<span style="background-color:rgb(255,255,255)"> </span><br>
<span style="font-size:0.8em"><br>
<b>Tel.</b> 06 19 36 78 32 <br>
<b>Bureau</b> <br>
<a
href="https://maps.google.com/?q=31,+rue+de+l'Argenterie+34000+Montpellier&entry=gmail&source=g"
target="_blank">31, rue de l'Argenterie</a> <br>
<a
href="https://maps.google.com/?q=31,+rue+de+l'Argenterie+34000+Montpellier&entry=gmail&source=g"
target="_blank">34000 Montpellier</a> <br>
<b>Siège social</b> <br>
<a
href="https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g"
target="_blank">73, allée Kleber</a> <br>
<a
href="https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g"
target="_blank">Boulevard de Strasbourg</a> <br>
<a
href="https://maps.google.com/?q=73,+all%C3%A9e+Kleber+Boulevard+de+Strasbourg+34000+Montpellier&entry=gmail&source=g"
target="_blank">34000 Montpellier</a></span></div>
</body>
</html>