Forums

Question about search widget and where conditions

Fredolino 11 May, 2020
Hi,
I use the search widget to search database tables.
For this I have set up Where conditions with Condition and Operator.
(
Model.feldname1 = {data: keywords} / Use
OR
Model.feldname2 = {data: keywords} / Use
...
)
AND
user_id = {user_id} / Use

The search shows me the correct results in the table.
The only problem is that I no longer see the table (table_list) when I come to the page. I only see the table header but no rows with content.

How does it work that the complete table is shown on the page but the search still works and shows me the search results?
Max_admin 11 May, 2020
Hi Fredolino,

The only problem is that I no longer see the table (table_list) when I come to the page. I only see the table header but no rows with content.


How ? you mean when there is no search ?
Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?
Fredolino 11 May, 2020
Answer
1 Likes
Hi,
the problem is solved :-)
Make this not in Where condition. Make this in the searchable fields:
(
Model.feldname1
OR
Model.feldname2
OR
Model.feldname3
OR
Model.feldname4
OR
Model.feldname5
OR
Model.feldname6
)

F.
This topic is locked and no more replies can be posted.