No searching on primary key with Laravel Scout?

Question

I'm using Laravel Scout with TNTSearch Engine at it's working fine but with one little problem. I have the following records.

| ID      | Name     |
+---------+----------+
| 9030100 | Car      |
| 9030150 | Car2     |
| 9030200 | Radio    |

Here is my query:

CatalogProducts::search( $query )->paginate( 15 );

When I'm looking for 'car,' it's returning all records with 'car' in the name.

When I'm looking for '9030100', it's returning the product 'Car.'

But when I'm looking for '9030', I don't have any results. Why? How do I fix it?

I think id is integer, if you change id to string, you can search with '9030' and get 9030100' — Vahe Galstyan, Apr 04 '17 at 12:05

Manish Champaneri · Answer 1 · 2017-04-05T14:14:35.357

0

try changing the fuzziness. set fuzziness to true.

'tntsearch' => [
'storage'  => storage_path(), //place where the index files will be stored
'fuzziness' => true,
'fuzzy' => [
    'prefix_length' => 2,
    'max_expansions' => 50,
    'distance' => 2
],
'asYouType' => false,

edited Apr 05 '17 at 14:14

answered Apr 04 '17 at 14:20

Manish Champaneri

654
3
8
28

I feed the data same as you in my db and found this solution. Just change the **distance = 4** and **prefix_length = 4** for 9030 to give result – Manish Champaneri Apr 05 '17 at 14:21
Fact is you have to optimize the prefix_length and distance according to your need . Best of luck – Manish Champaneri Apr 05 '17 at 14:30

No searching on primary key with Laravel Scout?

1 Answers1