Table filter not working as expected

💬 App Building
1

Hi,

I have a date input component. I have a table that is using a filter to show only events that are greater or equal to the value of the date input. It seems the filter is not showing events on the same date until I press on the date input field: Screen capture - 9427d17cf0461b0ce9d43720c5aa7179 - Gyazo

As you can see from the above video, I should be seeing Feb 1st events but it only shows after I click on the date input component (no change in value).

Seems like a Retool bug to me?

Thanks, Jake

2

Hi Jake,

It's a bit difficult to tell from that screenshot alone, but it's possible it's just an issue with the formatting differences between the Filter Dates and the Table Dates.

I'd suggest adding a Text Component, and referencing your Date Filter there to see the format of the date and then comparing that with the format of the Table Date field

3

That should be a video not a screenshot.

I don’t believe it’s an issue with the data type as it works once you click on and off the DateInput component (as shown in the video)

4

Hi. I have 3 follow-up questions:

  1. Before clicking on the data input field, is your data filtered always exactly off-set by 1 day? It there a pattern i mean?
  2. I can imagine that in order to select a date in the date input, one would naturally click on it at least once anyway. So when do you really face this issue? Only page-loads perhaps?
  3. I can see an event handler on your date component (date_from). Have you made sure that that's not causing the issue?

If possible, can you also share another video in which:

  1. we can see {{date_from.value}} in a plain text component?
  2. add a custom column in your table, select data source the same as "Event Date" column, except set the format of this custom column as "Datetime" instead of date.

Need to make sure that this is not time-zone related issue. You are in +9:00 timezone. This could cause issues. Although this still wouldn't explain why everything is fixed upon clicking the date input.

1 Like
5

Thank you for your input AbduI followed your questions in a video here: Retool.mp4 - Google Drive

As I was recording I noticed that on page load the DataInput value is showing time however on clicking on-off the component it changes to date only. So I'm guessing that's the issue, the page load value needs to be date only.

Thanks for your help, unless you hear from me I should be able to fix.