Status - last updated date and time not updating even after changing from one status to other

monday Apps & Developers
, , , ,
1

Hi,

When cards status changed from yet to work to any other status, the changes are not reflected on the status receiving from sending request through API playground (eg: last_changed). Even though status is changed for many task the changed_at field in status key is showing null.

{
                        "id": "4*5*4*5*4*",
                        "name": "Collection Banner",
                        "created_at": "2023-02-27T20:21:03Z",
                        "column_values": [
                            {
                                "title": "Planned Effort",
                                "value": "\"1\"",
                                "text": "1"
                            },
                            {
                                "title": "Status",
                                "value": "{\"index\":9,\"post_id\":null,\"changed_at\":null}",
                                "text": "Delivered"
                            },
                            {
                                "title": "Timeline",
                                "value": "{\"to\":\"2023-03-15\",\"from\":\"2023-03-14\",\"changed_at\":\"2023-03-14T13:50:43.111Z\"}",
                                "text": "2023-03-14 - 2023-03-15"
                            },
                            {
                                "title": "Preview Link",
                                "value": "\"NA\"",
                                "text": "NA"
                            },
                            {
                                "title": "AM",
                                "value": "{\"changed_at\":\"2023-03-03T11:44:59.334Z\",\"personsAndTeams\":[{\"id\":2*4*5*8*,\"kind\":\"person\"}]}",
                                "text": "Aliva P"
                            },
                            {
                                "title": "POC",
                                "value": null,
                                "text": ""
                            },
                            {
                                "title": "Dev",
                                "value": "{\"changed_at\":\"2023-03-14T13:54:30.441Z\",\"personsAndTeams\":[{\"id\":2*2*7*6*,\"kind\":\"person\"}]}",
                                "text": "Meenakhi Panigrahy"
                            },
                            {
                                "title": "Time Tracking",
                                "value": "{\"running\":false,\"duration\":2664,\"startDate\":1678769855,\"changed_at\":\"2023-03-14T05:41:59.124Z\",\"additional_value\":[{\"id\":3*5*8*2*1,\"account_id\":1*07**93,\"project_id\":4*5*4*5*4*,\"column_id\":\"time_tracking\",\"started_user_id\":2*2*7*6*,\"ended_user_id\":2*2*7*6*,\"started_at\":\"2023-03-14T04:57:35Z\",\"ended_at\":\"2023-03-14T05:41:59Z\",\"manually_entered_start_time\":false,\"manually_entered_end_time\":false,\"manually_entered_start_date\":false,\"manually_entered_end_date\":false,\"created_at\":\"2023-03-14T04:57:35Z\",\"updated_at\":\"2023-03-14T05:41:59Z\",\"status\":\"active\"}]}",
                                "text": "00:44:24"
                            }
                        ]
                    }

In above response it clearly showing that the status of the task is change to Delivered from Yet to start. But the changed_at key in status key is showing null.

2

Hello there @Arjun-C-S and welcome to the community!

I hope you like it here :muscle:

Would you be able to share with us the query you are using?

Also, if I understand correctly, what happens here is that:

  1. You change a status column
  2. You query for the information
  3. You get the new value in the “text” for the status column but in the “value” for that status column you see :null

Is that accurate?

Looking forward to hearing from you :slightly_smiling_face:

Cheers,
Matias

3

Hi,

I changed the status from yet to start to some other status. The problem is the time I changed the status of the task is not reflecting at changed_at (title : Status) field in response.
The new status is reflecting on the response but the time is not.

{
    "title": "Status",
    "value": "{\"index\":9,\"post_id\":null,\"**changed_at\":null**}",
    "text": "Delivered"
},
4

Hello again @Arjun-C-S,

I am trying to reproduce the issue but I can not do so.

Would you be able to please send an email to appsupport@monday.com with a screen recording of the steps you are taking and the result you are seeing?

Please show your code, the board and the response you get.

From there we can take a closer look and open a report if necessary.

Looking forward to hearing from you via email!

Cheers,
Matias