diff options
| author | it-fixcomart <it@fixcomart.co.id> | 2025-02-07 09:36:38 +0700 |
|---|---|---|
| committer | it-fixcomart <it@fixcomart.co.id> | 2025-02-07 09:36:38 +0700 |
| commit | 62c558bf0f97121f804762780374f44adfb0406e (patch) | |
| tree | f278e859c2f922a69195f630607851a499483608 /indoteknik_api/controllers/api_v1/user.py | |
| parent | 1abbebda5ab707b014e8e01a7ab418861beef420 (diff) | |
<iman> add query search similar bussiness
Diffstat (limited to 'indoteknik_api/controllers/api_v1/user.py')
| -rw-r--r-- | indoteknik_api/controllers/api_v1/user.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/indoteknik_api/controllers/api_v1/user.py b/indoteknik_api/controllers/api_v1/user.py index f71af89f..1d26d356 100644 --- a/indoteknik_api/controllers/api_v1/user.py +++ b/indoteknik_api/controllers/api_v1/user.py @@ -171,7 +171,8 @@ class User(controller.Controller): query = """ SELECT id, name, levenshtein(name::text, %s) AS distance FROM res_partner - WHERE levenshtein(name::text, %s) < 3 + WHERE is_company = true AND active = true + AND levenshtein(name::text, %s) < 3 ORDER BY distance ASC """ params = (business_name, business_name) |