TNTSearch returns no results for partial queries. about tntsearch

[nticaric]

Ok, great. Oh yeah, and don't forget to order the results correctly. Something like:

$airports = Airport::whereIn('id', $result['ids'])->orderByRaw("FIELD (ID, $result['ids'])")->get();

because mysql doesn't keep the order when you use whereIn

And don't forget to star the package ;)

[nticaric]

The demo page uses the search not the searchBoolean method, so try with:

$tnt->asYouType = true;
$result = $tnt->search($request->input('query'), 10);

Does this solve your issue?

[awgv]

Thank you, it did. I've just realized that I tried search() method, but forgot to try it in conjunction with asYouType().

[nticaric]

Great! Can you share some performance data, how long does the indexing take and how fast are the result queries? I'm just eager to know how it works on uses cases other than mine :)

[awgv]

I'm developing it locally on Homestead, so I guess it doesn't matter right now — I'll remember to send you an email or mention here when the project goes live in a couple of months.

[jonstavis]

I'm running into a similar issue and am wondering if you could offer some advice.

I have two rows in my db that are getting indexed, with column values

• 3-(Trimethoxysilyl)propyl Acrylate
• Propylparaben

When I search for 'propyl' I only get the first result. When I search for 'propylp' I get the second result.

I looked at the query being executed when asYouType is true and see this if I run it directly against the search index:

sqlite> select * from wordlist where term like 'propyl%' order by length(term) asc, num_hits DESC limit 1;
1168|propyl|1|1

If I modify the query slightly I see this, which looks like each is being treated as a separate word with 1 hit only:

sqlite> select * from wordlist where term like 'propyl%' order by length(term) asc, num_hits DESC;
1168|propyl|1|1
442|propylparaben|1|1

Is there something that could be happening when building the index that omits the 'propylparaben' hit from the 'propyl' wordlist since there is a space immediately following 'propyl'?

Thanks!

[nticaric]

The words propyl and propylparaben are two different words that only share the same base which is propyl. If we omit the LIMIT clause like in your second example we could have performance problems with a larger dataset. Instead, we are returning the most frequent word that matches your base propyl.

If you think you'll have a small dataset and won't run into performance problems, you can query the index wordlist table directly

[jonstavis]

Thanks for your response. I managed to come up with a solution that involves overriding several of the methods in TNTSearch.php. Is there a cleaner way to do this through the existing API?