-
Notifications
You must be signed in to change notification settings - Fork 4.6k
[Bug]-[560]:Where condition on GSheets fails to query if there's mixed data type present in column data #7794
Copy link
Copy link
Open
Labels
BackendThis marks the issue or pull request to reference server codeThis marks the issue or pull request to reference server codeBugSomething isn't workingSomething isn't workingDatatype issueIssues that have risen because data types weren't handledIssues that have risen because data types weren't handledGoogle SheetsIssues related to Google SheetsIssues related to Google SheetsIntegrations ProductIssues related to a specific integrationIssues related to a specific integrationMediumIssues that frustrate users due to poor UXIssues that frustrate users due to poor UXMedium effortTakes < 2 weeksTakes < 2 weeksProductionQuery & JS PodIssues related to the query & JS PodIssues related to the query & JS PodQuery Widgets & IDE PodAll issues related to Query, JS, Eval, Widgets & IDEAll issues related to Query, JS, Eval, Widgets & IDE
Description
Metadata
Metadata
Assignees
Labels
BackendThis marks the issue or pull request to reference server codeThis marks the issue or pull request to reference server codeBugSomething isn't workingSomething isn't workingDatatype issueIssues that have risen because data types weren't handledIssues that have risen because data types weren't handledGoogle SheetsIssues related to Google SheetsIssues related to Google SheetsIntegrations ProductIssues related to a specific integrationIssues related to a specific integrationMediumIssues that frustrate users due to poor UXIssues that frustrate users due to poor UXMedium effortTakes < 2 weeksTakes < 2 weeksProductionQuery & JS PodIssues related to the query & JS PodIssues related to the query & JS PodQuery Widgets & IDE PodAll issues related to Query, JS, Eval, Widgets & IDEAll issues related to Query, JS, Eval, Widgets & IDE
Type
Fields
Give feedbackNo fields configured for issues without a type.
Projects
StatusShow more project fields
No status
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:
Important Details