Poor exercise by name search results

[jmccaull]

I recently got back to using wger and had some issues updating. I had to start over and did a partial restore of routines and templates that I was using before from a sql dump, but manually re-added all of my custom exercises. I'm not sure if the results I'm seeing are due to some issues related to the restore or if its just the current experience.

When editing my routines and trying to select a new exercise the search results seem really off. I find I can search for the exact full title of one of my custom exercises, but it still is the last result in the list. Even when searching for ones I've synced from the main wger instance it is pretty difficult to find the one I'm looking for when using the exact string, it often being way down the list with higher results frequently have only one word in common. For example if I search for "Upright row w/ Dumbbells" it is the 26th item in the list, with the first few being "Benchpress Dumbbells", "Bent over dumbbell rows", etc.

Is there anything I run or update to improve this?

Thanks

[rolandgeider]

we use postgres' full text search to match the names or the aliases of the exercises. Do you feel this got worse after the update?

[jmccaull]

I can't remember how it performed before. I've never dealt with pg's full text search, but reading up on it a bit I can see why its doing what it is. Maybe it would perform better without stemming?

[rolandgeider]

I've opened #2279 so that it's possible to select using the explicit match, which can be useful in these situations

(closing here)