MariaDB (MySQL) Unified Index doesn't permit same reports as Elasticsearch (No results for query)
- Status
- Open
- Subject
- MariaDB (MySQL) Unified Index doesn't permit same reports as Elasticsearch (No results for query)
- Version
- 18.x
19.x - Category
- Indexing
- Feature
- Trackers
- Resolution status
- New
- Submitted by
- Marc Laporte
- Keep informed
- Victor Emanouilov, Jonny Bradley
- Lastmod by
- Marc Laporte
- Rating
- Description
Unified Index:
Works both in Elasticsearch and MariaDB
This works: https://dev.tiki.org/Wishlist-Search-PageBut:
https://dev.tiki.org/Tiki19#Open_or_Pending_blockers_and_regression works with Elasticsearch but not MariaDBCode copied below:
Copy to clipboard{LIST()} {filter content="5" field="tracker_id"} {filter field="tracker_status" content="o OR p"} {filter field="tracker_field_version" content="331"} {filter field="tracker_field_category" content="265 OR 172"} {filter field="tracker_field_resolution_status" content="New OR Accepted OR Confirmed"} {* sort mode="modification_date_ndesc" *} {sort mode="tracker_field_priority_ndesc"} {OUTPUT(template="table")} {column field="mod_date" label="LastModif" mode="raw"} {column field="tracker_status" label="" mode="raw"} {column sort="tracker_field_resolution_status" field="tracker_field_resolution_status" label="Resolution Status" mode="raw"} {column sort="tracker_field_submitted_by" field="tracker_field_submitted_by" label="Submitted By"} {column field="tracker_field_assigned_to" label="Volunteered" mode="raw"} {column field="tracker_field_subject" label="Title" mode="raw"} {column label="Category" field="category" mode="raw"} {column sort="tracker_field_version" field="tracker_field_version" label="Version" mode="raw"} {column field="tracker_field_feature" label="Feature" mode="raw"} {column sort="tracker_field_priority" field="tracker_field_priority" label="Priority" mode="raw"} {tablesorter server="n" sortable="y"} {OUTPUT} {FORMAT(name="mod_date")}{display name="modification_date" format="date"}{FORMAT} {FORMAT(name="tracker_status")}{display name="tracker_status" format="trackerrender"}{FORMAT} {FORMAT(name="tracker_field_resolution_status")}{display name="tracker_field_resolution_status" default="" format="trackerrender" editable=inline}{FORMAT} {FORMAT(name="tracker_field_submitted_by")}{display name="tracker_field_submitted_by" format="trackerrender"}{FORMAT} {FORMAT(name="tracker_field_assigned_to")}{display name="tracker_field_assigned_to" format="trackerrender" editable=inline default=""}{FORMAT} {FORMAT(name="tracker_field_subject")}{display name="tracker_field_subject" format="trackerrender"}{FORMAT} {FORMAT(name="category")}{display name="tracker_field_category" format="trackerrender"}{FORMAT} {FORMAT(name="tracker_field_version")}{display name="tracker_field_version" format="trackerrender"}{FORMAT} {FORMAT(name="tracker_field_feature")}{display name="tracker_field_feature" format="trackerrender"}{FORMAT} {FORMAT(name="tracker_field_priority")}{display name="tracker_field_priority" format="trackerrender" default="" }{FORMAT} {LIST}- Files
- Importance
- 7
- Easy to solve?
- 7
- Priority
- 49
- 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
- 6864
- Created
- Friday 12 October, 2018 14:50:26 UTC
by Marc Laporte - LastModif
- Saturday 06 July, 2024 10:21:44 UTC