Loading...
 
Skip to main content

Syntax suggestion for Unlimited search results

  • Tracker item actions
Trackers
Items
Status
Open
Subject
Syntax suggestion for Unlimited search results
Version
21.x
22.x
23.x
Category
  • Consistency
  • Feature request
Feature
Search
Resolution status
New
Submitted by
Jean-Marc Libs
Lastmod by
Jean-Marc Libs
Rating
(0)
Description

We have no syntax for expressing we want an unlimited number of LIST plugin results.

Using mysql Full-Text indexation, one can express the idea with a huge number like so :
{CODE()}{LIST()}
{filter field="object_type" content="trackeritem" }
{filter field="tracker_id" exact="1"}
{pagination max="99999999"}
{OUTPUT(template=)}
{LIST}{CODE}

It is ugly but it does the job in an expressive way (people will understand 99999999 does not mean exactly 99999999).

Using Elascticsearch, the above will fail with an obscure error message « all shards failed » because Elascticsearch has a hard limit which defaults to 10000 but it can be changed at the server level.
See Results Per Query in https://www.elastic.co/guide/en/app-search/current/limits.html
So I need to use:
{CODE()}{LIST()}
{filter field="object_type" content="trackeritem" }
{filter field="tracker_id" exact="1"}
{pagination max="9999"}
{OUTPUT(template=)}
{LIST}{CODE}
Because "10000" looks like I really want "10000" rather than unlimited.

It is bad that the LIST plugins need to be rewritten when one changes the unified search indexation method. Also, it is not obvious why it fails.

SUGGESTION I feel we should allow for a real syntax for unlimited results such as :

SUGGESTED SYNTAX
Copy to clipboard
{pagination max="-1"}


Then if Tiki uses Elascticsearch searches it could look up the Results Per Query value (or assume 10000 for starters) when "-1" is encountered.
If Tiki uses "Mysql Full-Text search" if should not have a limit (or it should have a very high one).

Importance
8
Easy to solve?
5
Priority
40
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7708
Created
Thursday 25 March, 2021 01:49:37 UTC
by Jean-Marc Libs
LastModif
Friday 26 March, 2021 12:21:40 UTC


Show PHP error messages