The "searchabletext" field might be redundant now that we got real item stats?
The real item stats contains a lot of color/bold/etc tags like ^K which are not stripped out, causing the text search to fail: (PI.namelowercase LIKE :name OR PI.searchabletext LIKE :wildcard OR R.text LIKE :wildcard)
Maybe time to deprecate the manual searchabletext column and instead strip item stats tags to better support search?
(PI.namelowercase LIKE :name OR PI.searchabletext LIKE :wildcard OR R.text LIKE :wildcard)
Maybe time to deprecate the manual searchabletext column and instead strip item stats tags to better support search?