weretaco-search-customers | Stripe Developers | Page 1

wraith sleet Aug 31, 2022, 8:38 PM

#

Starting up a thread for you!

kind tusk Aug 31, 2022, 8:38 PM

#

thanks

wraith sleet Aug 31, 2022, 8:40 PM

#

Yeah, I believe specifying a key name is required unfortunately.

kind tusk Aug 31, 2022, 8:41 PM

#

also when doing a search on customer do searches under a specific length get dropped? for example i have a customer name that starts with "A TO Z" but when i search for that i get no result. looks like the subtring search splits them on space as well so a search of TEST CUSTOMER would return customers with TEST and/or CUSTOMER in their name?

#

example search: email~"A TO Z" OR name~"A TO Z" OR phone~"A TO Z" OR metadata["old_id"]:"A TO Z" OR metadata["customer_id"]:"A TO Z" OR metadata["phone"]:"A TO Z"

#

doesn't return customer A TO Z Road...

#

nevermind on part 2, i think it's just dropping Z part if i search for example Z ENTER is just searches on ENTER

wraith sleet Aug 31, 2022, 8:49 PM

#

So are you still getting no results when you search for customer names that start with "A TO Z" or is that working now?

kind tusk Aug 31, 2022, 8:49 PM

#

A TO Z i get nothing

#

it's like it's dropping words under 3 characters or something

#

if i search for "Z ENTER" i get all customers with ENTER in their name, but no Z being used

wraith sleet Aug 31, 2022, 8:54 PM

#

Can you share the request ID so I can try and repro

kind tusk Aug 31, 2022, 8:57 PM

#

req_epNZFAL71sUUIF

wraith sleet Aug 31, 2022, 9:09 PM

#

Yeah I can repro - let me talk to my team and see if this is expected or not

kind tusk Aug 31, 2022, 9:14 PM

#

depending on your backend database i know mysql is a 4 character minimum (bydefault) for full text search, and mssql uses stop words so that might filter stuff like A-Z and other 2 character ones

wraith sleet Aug 31, 2022, 9:35 PM

#

Yeah we're still digging into a bit more

#weretaco-search-customers