[Bug]: Problem with filter tool (LWC 3.6) - Data not displayed

[Alain-LG]

What is the bug?

When I use the filter tool, no data is displayed or some data is displayed without correctly matching the filter.

Steps to reproduce the issue

The number of fetaures is correctly updated but not the map.

For example, his is the map without filter (34514 features) :

If i check one option "commune = Angerville-la-Martel", there are 957 features left but only 2 points are displayed on the map and they are not corresponding to the filter (not the good municipalitie).

May you help me to solve this issue please ?

Versions

Versions :

• Lizmap Web Client : 3.6.3
• Lizmap plugin : 3.13.0
• QGIS Desktop : 3.28.6 (test also with 3.22.6)
• Lizmap.com : Yes
• QGIS Server : 3.28.4
• Py-QGIS-Server : 1.8.8
• QGIS Server plugin atlasprint : 3.3.2
• QGIS Server plugin cadastre : 1.17.3
• QGIS Server plugin lizmap_server : 2.7.1
• QGIS Server plugin wfsOutputExtension : 1.7.1

Check Lizmap plugin

• I have done the step just before in the Lizmap QGIS desktop plugin before opening this ticket. Otherwise, my ticket is not considered valid and might get closed.

QGIS server version, only if the section above doesn't mention the QGIS Server version

No response

Operating system

W10 for desktop / Unknown for server

Browsers

Firefox

Browsers version

Firefox 113

Relevant log output

No response

[gioman]

@Alain-LG Please add a title/subject.

[Gustry]

What the primary key used in your layer datasource ? What kind of field ?

[Alain-LG]

It's the fid field which is a bigint type field.

and the filters are done on two string fields : commune(varchar(30)) and usage(varchar).

[mdouchin]

I suspect the bigint type to be problematic (as QGIS cannot use it as a real feature ID but must create and maintain a relation between an internal ID and this column).

If your number of objects is not too big, and can fit in the classical integer (int4) data type, could you just convert it to integer with something LIKE

ALTER TABLE "OM_potentiel_compostage" ALTER COLUMN "fid" SET DATA TYPE integer USING "fid"::integer;

[Alain-LG]

Thanks a lot, I have updated the table with your alter table request.
Now, it's OK.

[Gustry]

I have added it in 3liz/lizmap-plugin#389

[Gustry]

Quick and dirty for now, a warning is now raised in the next version of the plugin when primary keys are :

• tid but this field doesn't exist
• int8 bigint primary keys

3liz/lizmap-plugin@39a6798

We will make a proper "check panel" later