Value-relation lists are displaying multiple occurrences of the same values when there are duplicate values in the relation table, even with the filters applied.
Steps to reproduce the issue
I'm working with multi-select value relations (field "alim"), where the lists are populated from the field "spec" and filtered using the field "id_poly" from the table LISTE_ESPECES_PO. In LISTE_ESPECES_PO, the spec field can contain multiple identical values, but for the same values, the id_poly is always unique (it can be the same if "spec" is different).
Here is the filter I'm using:
id_poly = current_value('ID_REL') AND compart = current_value('compart') AND compart <> 'Flore'
Here is a picture of how it looks like on the LISTE_ESPECES_PO table.
If I’m not mistaken, I believe there is a bug in how the values are displayed in the attribute table. The list is properly displayed, and we can select the values we want:
However, once finished, the list looks like this:
Instead of showing only one occurrence of each value from LISTE_ESPECES_PO as it is done in editing mode, every instance of the selected values is displayed after saving.
What is the bug or the crash?
Hello,
Value-relation lists are displaying multiple occurrences of the same values when there are duplicate values in the relation table, even with the filters applied.
Steps to reproduce the issue
I'm working with multi-select value relations (field "alim"), where the lists are populated from the field "spec" and filtered using the field "id_poly" from the table LISTE_ESPECES_PO. In LISTE_ESPECES_PO, the spec field can contain multiple identical values, but for the same values, the id_poly is always unique (it can be the same if "spec" is different).
Here is the filter I'm using: id_poly = current_value('ID_REL') AND compart = current_value('compart') AND compart <> 'Flore'
Here is a picture of how it looks like on the LISTE_ESPECES_PO table.
If I’m not mistaken, I believe there is a bug in how the values are displayed in the attribute table. The list is properly displayed, and we can select the values we want:
However, once finished, the list looks like this:
Instead of showing only one occurrence of each value from LISTE_ESPECES_PO as it is done in editing mode, every instance of the selected values is displayed after saving.
Versions
Extensions Python actives GeoCoding | 2.19 GroupStats | 2.2.7 mapswipetool_plugin | 1.3 networks | 2.7.19 OpenTopography-DEM-Downloader | 2.0 qfieldsync | v4.9.1 Qgis2threejs | 2.7.3 quick_map_services | 0.19.34 SemiAutomaticClassificationPlugin | 8.2.2 Submission | 0.10 db_manager | 0.1.20 MetaSearch | 0.3.6 processing | 2.12.99