[Bug / Enhancement]: Wildcard characters in Filter By of GoogleSheet do not work

[cmeissner]

Is there an existing issue for this?

• [X] I have searched the existing issues

Description

When I try to use wildcard characters in a google spreadsheets query for Filter by it does not work. Known wildcard characters are * (any character) and ? (one arbitrarily character) both are not working with filter.

Steps To Reproduce

1. Create a spreadsheet with a single table, as followed:

   Name	Eye color	Height
   Peter	blue	182
   Mary	brown	172
   Andy	green	174
   Camille	blue	179
   Anna	yellow	160
   Cliff	brown	185

2. Create a filter for all columns and try to filter with wildcards

   • For column Eye color, text contains b*

     Name	Eye color	Height
     Peter	blue	182
     Mary	brown	172
     Camille	blue	179
     Cliff	brown	185

3. Create a r/o GoogleSheet data source

4. Create a query for the spreadsheet and table of step 1 a. without Filter By, run query and see result set b. with Filter By

   {
   	"condition": "AND",
   "children": [
   	{
   		"condition": "CONTAINS",
   		"key": "Eye color",
   		"value": "b*"
   	}
   ]
   }
   

   run query and see empty result set

Public Sample App

No response

Issue video log

No response

Version

Cloud

Front conversations