Filter results from a multi-select field
Posted: Wed Mar 07, 2012 6:33 am
Hi,
When I use filtering on a multi-select field, records containing multiple values in the field cannot be filtered as wished. When a single value exists on the field, then I see it properly displayed in filter results. However, if there are multiple values existing on the field, then I see ID's of these values rather than their display titles in filter results.
fields.ini
[fieldX]
widget:type=select
repeat=1
vocabulary=vocabularyX
filter=1
valuelists.ini
[vocabularyX]
__sql__="select id, name from fieldX order by name"
How can I fix it?
When I use filtering on a multi-select field, records containing multiple values in the field cannot be filtered as wished. When a single value exists on the field, then I see it properly displayed in filter results. However, if there are multiple values existing on the field, then I see ID's of these values rather than their display titles in filter results.
fields.ini
[fieldX]
widget:type=select
repeat=1
vocabulary=vocabularyX
filter=1
valuelists.ini
[vocabularyX]
__sql__="select id, name from fieldX order by name"
How can I fix it?