Loading...
 
Skip to main content

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
(0)
Description

Unified Index:

Works both in Elasticsearch and MariaDB
This works: https://dev.tiki.org/Wishlist-Search-Page

But:
https://dev.tiki.org/Tiki19#Open_or_Pending_blockers_and_regression works with Elasticsearch but not MariaDB

Code 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
  1. 2018 10 12 104734
Importance
7
Easy to solve?
7
Priority
49
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6864
Created
Friday 12 October, 2018 14:50:26 UTC
by Marc Laporte
LastModif
Saturday 06 July, 2024 10:21:44 UTC


Show PHP error messages