Skip to content

[Bug]: Returns empty data when searching for long numbers in the filter of table #41445

@TAUnionOtto

Description

@TAUnionOtto

Is there an existing issue for this?

  • I have searched the existing issues

Description

When I specify a long numeric string in the table's filter, such as 202409190201409610, the table displays empty data.

When the number is slightly shorter (e.g., after removing the last two digits: 2024091902014096), the table displays the filtered data correctly.

This issue occurs when using "contains", "starts with", "ends with", or "is exactly".

No such problem is observed when searching for non-numeric strings.

Image Image

Steps To Reproduce

  1. Create a table that stores data with a field (e.g., order ID) containing long numeric values.
  2. Enable client-side search for the table
  3. Open the filter and select this field, specifying the filter type as “contains”, “starts with”, “ends with”, or “is exactly”
  4. Enter a relatively long numeric filter value, such as 202409190201409610

Public Sample App

No response

Environment

Release

Severity

Medium (Frustrating UX)

Issue video log

No response

Version

Self Hosted - v1.80

Metadata

Metadata

Labels

BugSomething isn't workingCommunity Reportedissues reported by community membersContributor Expressed InterestIssues where community has raised interest to pick it upMediumIssues that frustrate users due to poor UXNeeds TriagingNeeds attention from maintainers to triageRelease

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions