Good morning everyone. Is there a way to do a part...
# community-helpa
Alan Boody
10/31/2022, 1:36 PMGood morning everyone. Is there a way to do a partial search on a specific field?
k
Kishore Nallan
10/31/2022, 1:37 PM👋 Can you please elaborate with an example?
a
Alan Boody
10/31/2022, 1:45 PMWe have a field for phone numbers, along with various other fields we want to search, but for the phone number we need to match partials:
Alan Boody
10/31/2022, 1:45 PM15155555050, but if someone were to search 5050 that would need to match.
k
Kishore Nallan
10/31/2022, 1:46 PMGot it. You have to use infix search for it.
Kishore Nallan
10/31/2022, 1:47 PMa
Alan Boody
10/31/2022, 1:50 PMIf I'm following correctly I need to both add infix: true to the data structure of the field itself and then infix: on in the query?
k
Kishore Nallan
10/31/2022, 2:04 PMCorrect
a
Alan Boody
10/31/2022, 2:40 PMIf I drop/add the field to add the infix is this going to drop all the data currently indexed?
k
Kishore Nallan
10/31/2022, 2:44 PMNo, it will just drop and recreate the in-memory index. For large collections, this could take some time.
a
Alan Boody
10/31/2022, 2:46 PMAlright. Ty. Again, as usual, thanks for the quick responses. Your support is top notch.
🙌 1
Alan Boody
10/31/2022, 2:57 PMHey, quick question. With the site live and data constantly being indexed if I ran this right now would it have a negative affect on data being indexed, current searching, etc? Basically, do you recommend I do this after hours or is it no big deal?
k
Kishore Nallan
10/31/2022, 3:03 PMYes it will block both writes and reads.
Kishore Nallan
10/31/2022, 3:03 PMI recommend creating a new collection and using an alias to switch if you can do that.
a
Alan Boody
10/31/2022, 3:03 PMok
k
Kishore Nallan
10/31/2022, 3:04 PMOfc, this is an area we want to improve in future.
a
Alan Boody
10/31/2022, 3:17 PMStill a good product already. Thanks again!