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

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.

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

1 Like

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"
},

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

Hi @Arjun-C-S! :wave:

I suggest you to try Time in Status app which track time the Item has spent in each workflow status. So you can monitor how fast the Item moves between statuses.
You’ll get user-friendly data on the board in a few seconds.

Also you will be able to track how much time your issue spends in each status and much more by generating 3 types of reports:

:chart_with_upwards_trend: And use charts to visualize your reports a sample of a certain number according to time range/item range, or a single item:

  • Pie Charts
  • Bar Charts
  • Area Charts

The app is also available in the format of board integration.

You can try it on the Monday Marketplace and share your experience with us.
Hope you find this app helpful.