Filter Stack breaks for Phone Number fields

[Charlie_Evett]

• Goal: Use client side filtering in a table component with Phone Numbers.

• Steps:

Add to the filter stack using setFilterStack and the array of keys and comparison operators using something like:

[{
  columnId:'cus_phone',
  operator: 'includes',
  value: {{self.value}}
}]

If the column of the table is set to display as Phone, this will break the filtering capability, without any error messages. Filtering on all columns will not work, not just the phone number one.

• Details:

The work around for this is to format the phone number field as String.

[Tess]

Hi @Charlie_Evett,

Thanks for reporting this! I haven't been able to reproduce this on Retool Cloud yet it seems to be working for me.

What does {{self.value}} evaluate to?

[Charlie_Evett]

Well, it kind of works for filtering on just the phone, but breaks the other fields.

Here is what it looks like with the broken filter on "sam" with the phone number field format:

the filters look like:

Here is it working with the text format for the same field:

the filters look like:

[Tess]

Thanks! I was able to reproduce this, so I'll reach out to our team for a fix

[Tess]

This should be fixed on Cloud now (as of version 3.178) For self hosted accounts, the fix will land in and edge release shortly after and the next stable release for Q2 2025