- Posts: 1
- Thank you received: 0
Is it possible to search in Table JX on multiple words in a column so the hits can be narrowed?
For example:
The sentence "I really love icecream in the summer" is in a cell on our database in the column "sentence". Now i have 200 hits on the words icecream and 100 on summer but when i combine the words like "summer icecream" Table JX is suggesting there are 0.
Or with a kind of fuzzy search if the sentence is "I really love an icecreamcone in the summer".
Is it possible with Table JX to do a search in our database for a sentence containing some words and not the exact sentence? If not, is there another way to accomplish this?
Thanks in advance.
Please Log in or Create an account to join the conversation.
Hi,
Right now there isn't any nice way to achieve searching word by word. If you are familiar with php and sql you could try to achieve it by changing the way the sql query is generated. You would have to do something like this. Split the sentence by words, and add sql LIKE condition for every word. SQL query is generated in components/com_grid/GridBuilder.php
We put it on our todo list as well.
Please Log in or Create an account to join the conversation.