search api doesn't pull up partial matches or numeric search
I'm using smartsheet integrations and use search API to get the queried sheet name.
Example: Assume that these are the sheetnames I have created
- sheet a
- sheet ac
- sheet account
- sheet account10
These are the issues
- When I query "a", it returns only "a" and "sheet a". Infers that only exact word match applies when searched with one character
- When I query "ac", it returns only "ac and sheet ac". Infers again that only exact word match applies.
- However if I search "acc", it returns "sheet account and sheet account10". Infers partial match
- If I search for 10 it doesn't pull up any result.
Need clarification on how to make it partial search all the time irrelevant of whether the query is single character, double character, numeric or any word.
Please help with this.
Thanks in advance,