appsmithorg / appsmithorg/appsmith
[Bug]-[560]:Where condition on GSheets fails to query if there's mixed data type present in column data
Offen
Backend
Bug
Datatype issue
Google Sheets
Integrations Product
Medium
Medium effort
Production
Query & JS Pod
Query Widgets & IDE Pod
- Vorherrschende Sprache
- TypeScript
- Sterne
- 40.9k
- Forks
- 4.8k
- Ø Merge
- 1 T. 22 Std.
- Gemergte PRs (30 T.)
- 45
Beschreibung
## Description
If a GSheet column has mixed data type (number and string) then where condition fails to query results that favour the filter condition.
This is an extension of #7688
### Steps to reproduce the behaviour:
1. Go to GSheets datasource and add a new query
2. Add where condition for a table where mixed data types are present and observe the error
### Important Details
- Version: Cloud
- OS: Win10
- Browser: Chrome
- Environment: Release
[Front conversations](https://app.frontapp.com/open/top_65i30)
Beitragsleitfaden
Bewertung
Dieses Issue wurde noch nicht bewertet.