Is there currently any way to search for partial m...
# community-help
t
Is there currently any way to search for partial matches in words? Eg. a product with code
157B2210
should be findable with query
B2210
, but currently that doesn't seem possible as only prefix queries are supported?
k
We've just had a couple of other customers ask for this feature. This requires suffix searching, which is not an easy problem to solve. It requires building a suffix tree, which is really complex and requires a high memory foot print or requires just doing a fast brute force search on the strings. It's a memory vs speed trade off. How big is your dataset?
t
Around 300k records, using ~700MB of memory
Perhaps a possible brute force search could be enabled on a field by field basis? For example when searching through product codes, the strings are short and probably quickly searchable.
k
Yes that should be doable.
j
One workaround in the meantime is to split each character combination into an array field and search on that.
👍 1
@Tatu Ulmanen Mind creating a github issue for this, so we can track it?
t