https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× This is the optional Forum header for the Suggestion Box.

Searchfield: Search on multiple words in a column.

  • dgouweleeuw
  • dgouweleeuw's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 10 months ago #2319

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.

Last edit: 10 years 10 months ago by dgouweleeuw.

Please Log in or Create an account to join the conversation.

More
10 years 10 months ago #2323

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.

Last edit: 10 years 10 months ago by tomaz.

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.165 seconds

Contact Us

Contact us on Discord

Contact us on Facebook