Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug]: incorrect Unix Timestamp value when updating a Date type column #35631

Closed
1 task done
simonfvr opened this issue Aug 12, 2024 · 7 comments · Fixed by #36455
Closed
1 task done

[Bug]: incorrect Unix Timestamp value when updating a Date type column #35631

simonfvr opened this issue Aug 12, 2024 · 7 comments · Fixed by #36455
Assignees
@Nikhil-Nandagopal @rahulbarwal @somangshu @pranavkanade @jacquesikot @carinanfonseca
Labels
Bug Something isn't working Community Reported issues reported by community members High This issue blocks a user from building or impacts a lot of users Needs More Info Needs additional information Needs Triaging Needs attention from maintainers to triage Production QA Pod Issues under the QA Pod QA Needs QA attention Table Inline Edit Issues related to inline editing Widgets & Accelerators Pod Issues related to widgets & Accelerators Widgets Product This label groups issues related to widgets

Comments

@simonfvr
Copy link

Is there an existing issue for this?

  • I have searched the existing issues

Description

When I update a Date type column in a table with data extracted from a database, the Unix timestamp value returned is incorrect.

E.g., when setting 2024-08-13 in the datepicker, the updated value internally is 8iAug 13, 2024i02con20.

This makes impossible the update of the date for any table row.

Steps To Reproduce

  1. Create a table widget.
  2. Extract data from a DB with any date column.
  3. For that date column, set type as Date, date format as Unix Timestamp (ms) and display format as YYYY-MM-DD
  4. Make the column editable.
  5. Change the value of the column using the datepicker.
  6. Now, if you check the computed value, it is incorrect.

imagen

Public Sample App

No response

Environment

Production

Severity

High (Blocker to building or releasing)

Issue video log

No response

Version

Appsmith v1.31.1
@simonfvr simonfvr added Bug Something isn't working Needs Triaging Needs attention from maintainers to triage labels Aug 12, 2024
@Nikhil-Nandagopal Nikhil-Nandagopal added Community Reported issues reported by community members High This issue blocks a user from building or impacts a lot of users Production labels Aug 12, 2024
@Nikhil-Nandagopal
Copy link
Contributor

@simonfvr it's possible the unix timestamp format being supplied as the data may be incorrect. Can you share a sample of the data that the table widget has?

@Nikhil-Nandagopal Nikhil-Nandagopal added Needs More Info Needs additional information Table Inline Edit Issues related to inline editing labels Aug 20, 2024
@github-actions github-actions bot added Widgets Product This label groups issues related to widgets Widgets & Accelerators Pod Issues related to widgets & Accelerators labels Aug 20, 2024
@simonfvr
Copy link
Author

simonfvr commented Aug 20, 2024 •
edited
Loading

@Nikhil-Nandagopal The unix timestamp in the data is correct as you can see in the following image.
imagen
The first row has been updated to show the incorrect timestamp format.

@simonfvr
Copy link
Author

simonfvr commented Sep 2, 2024

Hello, what's the status of this?

@carinanfonseca
Copy link
Contributor

Thanks for reporting this @simonfvr. We'll analyze this and get back to you as soon as possible.

@simonfvr
Copy link
Author

@carinanfonseca Hello Carina, this is a high severity error since users are not able to update the dates in a column with Date type. Please, solve it ASAP.

@jacquesikot
Copy link
Contributor

@simonfvr I will pick this up this week. Sorry for the delays.

@jacquesikot jacquesikot self-assigned this Sep 18, 2024
@jacquesikot jacquesikot mentioned this issue Sep 20, 2024
Merged
2 tasks
@appsmith-bot appsmith-bot added the QA Needs QA attention label Sep 30, 2024
@github-actions github-actions bot added the QA Pod Issues under the QA Pod label Sep 30, 2024
@jacquesikot
Copy link
Contributor

@simonfvr This PR will be available in the next release - 1.44

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Nikhil-Nandagopal Nikhil-Nandagopal

@rahulbarwal rahulbarwal

@somangshu somangshu

@pranavkanade pranavkanade

@jacquesikot jacquesikot

@carinanfonseca carinanfonseca

Labels
Bug Something isn't working Community Reported issues reported by community members High This issue blocks a user from building or impacts a lot of users Needs More Info Needs additional information Needs Triaging Needs attention from maintainers to triage Production QA Pod Issues under the QA Pod QA Needs QA attention Table Inline Edit Issues related to inline editing Widgets & Accelerators Pod Issues related to widgets & Accelerators Widgets Product This label groups issues related to widgets
Projects
None yet
Milestone
No milestone
8 participants
@Nikhil-Nandagopal @rahulbarwal @somangshu @pranavkanade @jacquesikot @appsmith-bot @carinanfonseca @simonfvr