Filtering a Multivalue does not work with MySQL search
- Status
- Closed
- Subject
- Filtering a Multivalue does not work with MySQL search
- Version
- 22.x
- Category
- Consistency
- Feature request
- Feature
- Search
Trackers
Wiki Plugin (extends basic syntax) - Resolution status
- Fixed or Solved
- Submitted by
- Bernard Sfez / Tiki Specialist
- Lastmod by
- Bernard Sfez / Tiki Specialist
- Rating
- Description
Search (index) need sometimes to "Explode" a itemList field values as an array of string so each value can be filtered
For an exemple, in a tracker you have an itemList fields using this date field with such values:
- tracker_field_date: 2021-03-24, 2021-01-14, 2020-10-22
To filter per date (we need item that contain "2021-03-24" only) we can should be able to use multivalue.filter set in a smarty template, work the same elsewhereCopy to clipboard{filter field="tracker_field_date" multivalue="{/literal}{$row.tracker_field_holidayDay}{literal}"}
Note: if you use content you may filter "2021-03-24 and 2021-01-14 because they both contain "2021"This is working fine if you use elasticSearch but doesn’t when you use Mysql.
- tracker_field_date: 2021-03-24, 2021-01-14, 2020-10-22
- Importance
- 7
- Easy to solve?
- 5
- Priority
- 35
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 7719
- Created
- Sunday 04 April, 2021 06:59:51 UTC
by Bernard Sfez / Tiki Specialist - LastModif
- Wednesday 07 December, 2022 11:48:47 UTC