Loading...
 
Skip to main content

Search within tables

Status
Open
Subject
Search within tables
Version
12.x
Category
  • Usability
Feature
Search
Resolution status
New
Submitted by
mikko.koivusaari
Lastmod by
mikko.koivusaari
Rating
(0)
Description

The search function cannot find words within the fancytables. This is quite important function so I would like to know a solution. Is it maybe possible to use the alternative query when the search returns empty set? and check if the query can be found with this alternative. And site is using mysql search currently. Does this work on other search engines?
By using SQL i can find it by changing the search query from

Not found
Copy to clipboard
select * from tiki_pages where data='myQuery'; or Select * from tiki_pages where data='%myQuery%';

Found
Copy to clipboard
Select * from tiki_pages where data like '%myQuery%';


But if you leave out the wildcards it still returns nothing

Importance
10 high
Easy to solve?
1 difficult
Priority
10
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
5516
Created
Thursday 11 December, 2014 10:08:47 UTC
by mikko.koivusaari
LastModif
Thursday 11 December, 2014 10:15:33 UTC


Show PHP error messages