Table Filter for Datetime Doesn't Respect Managed Timezone

[shawnhoffman]

In the table shown, the value is UTC while the label is showing Local. The filter applies only to the value, but that's not very intuitive for a user since they would expect the filter to match what they see, not the underlying UTC data.

Basically need to be able to apply the same "Manage time zones" option to the filter. There are a few other requests out there for options related to the filter component... hopefully that's the next one that gets some treatment!

[Biren_Panchal]

• Use JavaScript for Custom Filtering
  Retool allows the use of JavaScript in queries or transformers. You can write custom logic to handle the conversion and apply the filter accordingly.

const localTime = new Date(yourTableData.timeField).toLocaleString('en-US', { timeZone: 'America/New_York' }); // Adjust as needed

[shawnhoffman]

Not sure where exactly I would do that because the transformation I need is on the filter component itself -- maybe this helps explain a bit more:

Is your suggestion still applicable?

[Tess]

We have a request in our backlog to better support different formatting in this table filter UI. I don't have a timeline yet, but I can reach out if it gets picked up

It may be easier to have a date separate component that triggers a setFilter query

[toiroakr]

request in our backlog to better support different formatting in this table filter UI

Is this included the words like "Where", "Add", "is after" and others?

As for other components, it would be nice to be able to localize the month, day of the week, etc. for the calendar input component.

[Tess]

Hi there,

No, the request is to apply the date column format to table filter

For the calendar input, can you share an example? Would you want the month to be written in the local language? Are you looking to transform {{calendarInput1.value}}

[toiroakr]

Hi Tess,

Would you want the month to be written in the local language?

Yes.
I want to localize months and day of week written in English (August, Su, Mo, Tu, ...) to local language.

And also I want to localize words in table filters (And, Where, Clear filters, does not include, is empty, ...) too.

It would be nice to have keywords that Retool uses published and be able to override it with localization.

[Quirkz]

I'm also experiencing the same issue.
MNy table is set to display a UTC datetime in localtime using retools managed time option on the column.

When filtering, the datetime selector there is selecting a UTC date, rather than localtime - resulting in filters that look like they're in error, because the filter is being applied to the underlying UTC time, which is not what is showed.

A simple option to configure the filter datetime select to also use managed time would resolve this.

In the mean time, I'll try your suggestion of custom UI that calls setFilter