Filter data error with numeric field

[news24lor]

What is the bug?

Filter data with form is an excellent feature but it doesn't work with numeric fields. The other fields work.

Steps to reproduce the issue

I tried with all formats, gpkg, pgsql, spatialite but the numeric field I can not see. There are no two boxes to enter the minimum and maximum values.

Expected behavior

I want to see the slider with the two boxes for values

Screenshots and logs

Environment

• Lizmap 3.8.3:
• QGIS Server 3.8.3:
• QGIS 3.8.3:
• OS (Linux Ubuntu):
• Browser (Firefox, Chrome, ...):

[mdouchin]

Could you please provide a sample test project and lizmap config + gpkg data, so that we can reproduce the bug ?

[news24lor]

Hi I have always this error for any numeric field:

`2019-10-22 11:04:45 192.168.59.1 warning 2019-10-22 11:04:45 [2] SQLite3::loadExtension(): SQLite Extension are disabled /media/sf_shared/virtualhostx/webgis/maps/demo/lib/jelix/plugins/db/sqlite3/sqlite3.dbconnection.php 90

2019-10-22 11:04:45 192.168.59.1 warning 2019-10-22 11:04:45 [2] SQLite3::query(): Unable to prepare statement: 1, misuse of aggregate function Min() /media/sf_shared/virtualhostx/webgis/maps/demo/lib/jelix/plugins/db/sqlite3/sqlite3.dbconnection.php 112

2019-10-22 11:04:45 192.168.59.1 error query non valida (misuse of aggregate function Min() ( SELECT Min(Min("COD_PRO")) AS min, Max(Max("COD_PRO")) AS max FROM ercom2016 WHERE 2>1))`

If you want I have a gpkg file but the error is the same for any numeric field in any file. The SQL command does not work

[news24lor]

I also used your example file 'Montpellier_Events'. I saw that:

• TEXT works: the box is created and I can enter the text;
• UNIQUE VALUE works either with a text field or numeric with the checkbox or combo-box;
• DATE does not work: the two boxes are there to enter dates but the slider below is not selectable;
• NUMERIC does not work and neither the two boxes for entering values nor the slider below are created

[dobignies]

I noticed that primary key must be integer in db for sql functions (locate, selection and filter) to work properly. Removing the z-value before importing shp to db solved some problems with the same symptoms. In my project the filter works properly, including numeric and date fields (the fields in db must be set numeric an date) with LWC 3.4pre and QGIS 3.4.x , 3.6.x or 3.8.x. However, the export button returns only a corrupt ODS (spreadsheet) as output format since the release of the tool.

[news24lor]

If I have a true date field, DATE works. Now only NUMERIC does not works and my primary key is integer....

[dobignies]

Strange. Try to check the table integrity (wrong values). The only problem I found with the numeric filter is the decimal values behavior. If I have the following limits in my table: 1.2345 and 20.6789, the slide will freeze the smallest decimal value (, 2345) for both at any position, eg 7.2345, 15.2345, etc.