I have two PostgreSQL tables:
1 table name "features" 1 table name material containing material types
In table "features" I have a "material" field set to value relation widget linked to the the material table.
I set the "multiple choice" button on.
Everything works for recording and I get these kind of values as "material":
feature 1 : {wood;metal}
feature 2: {metal;stone;brick}
and so on.
The problem is that when I want to filter my "features" table using the QGIS forms, I can't choose to filter my table using one value like metal or wood. The "contains" option is not available for value relation widget set field or lists (array) fields.
Am I doing something wrong here? Should I set the "material" field as an array field?