Search feature in data table not working for Google Sheets

[robstevens7182]

Checklist

• [x ] I have searched budibase discussions and github issues to check if my issue already exists

Hosting

• Self
  • Method:
  • Budibase Version: 2.29.20
  • App Version: NA
• Cloud
  • Tenant ID: Not Shown

Describe the bug I am on the Data screen. I see my data that is linked to my google sheets. I place my mouse over the header and the magnifying glass appears. I click on the magnifying glass. I type in a value I know exists. All records disappear. I clear the search criteria. All records reappear.

To Reproduce Steps to reproduce the behavior:

1. Go to the data screen
2. Click on the magnifying glass at the top of a column
3. Enter a search term
4. All data disappears

Expected behavior

1. Go to the data screen
2. Click on the magnifying glass at the top of a column
3. Enter a search term
4. The rows with data that matches the search term should remain.

Screenshots

App Export

Desktop (please complete the following information):

• OS: Edition Windows 11 Home Version 22H2 Installed on ‎2/‎1/‎2023 OS build 22621.3880 Experience Windows Feature Experience Pack 1000.22700.1020.0

• Browser Chrome

• Version 126.0.6478.127 (Official Build) (64-bit)

Additional context None

[linear[bot]]

BUDI-8462 Search feature in data table not working

[aptkingston]

Google Sheets is a bit of an edge case in terms of how we handle searching. Could you check if exact matches work? Like searching for Robert. Just wondering if it works at all.

[robstevens7182]

Exact matches don't work either. Is it technically searching Google sheets? I thought I was just trying to get it to search the data table in the app. I discovered this by initially trying to create a filtered drop down in the app and it wouldn't work. It took me a while to realize none of my search terms were matching any data.

[deanhannigan]

This has been fixed as part of https://github.com/Budibase/budibase/pull/14315 and should be deployed soon.