Skip to main content

`newest_first` argument does not work in new API

  • September 6, 2023
  • 13 replies
  • 598 views

kolaai
Forum|alt.badge.img

At the moment, it seems the newest_first argument does not work on item queries in the new API. Is it still supported? If not, how does one reproduce that functionality in the new API?

13 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 7, 2023

Hello there @kolaai,

At the moment, there is no way to order by creation date, but I have shared this with our R&D team and we will implement it in the future.

I will let you know here when that happens.

Cheers,
Matias


kolaai
Forum|alt.badge.img
  • Author
  • monday.com Partner
  • September 7, 2023

Hello @Matias.Monday,

Thank you but this is a breaking change that is not mentioned anywhere. In fact, it is an important feature and I’m wondering why it was removed. Say you have 1000s of items on a board and would like to get the last added item, does it mean that currently there is no way to do that?


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 10, 2023

Hello again,

Until the team implements it, there is no way to do this directly like it used to be.

I will share your feedback with the team so that we can announce this and with the team in charge of the implementation, so that they can take your feedback into account.

Cheers,
Matias


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 10, 2023

Hello again @kolaai,

I shared this with the R&D team and heard back immediately. They said they are working on this and it will be ready very soon. I will update you when it is!

Cheers,
Matias


kolaai
Forum|alt.badge.img
  • Author
  • monday.com Partner
  • September 10, 2023

Great news. Thank you very much


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 18, 2023

Hello again @kolaai,

I was just informed that we will implement a way to sort by created_at and last_updated this week.

Beware of announcements 😁


  • New Participant
  • September 26, 2023

Hi there!

Eagerly awaiting this feature as well!

Was wondering what progress is looking like from the Monday team in this regard.


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 27, 2023

Hello everyone!

You can use these queries now to order your results (documentation on the way):

{
  boards(ids: [1234567890]) {
    items_page(
      query_params: {order_by: [{column_id: "__creation_log__", direction: desc}]}
    ) {
      items {
        id
        created_at
      }
    }
  }
}
{
  boards(ids: [1234567890]) {
    items_page(
      query_params: {order_by: [{column_id: "__last_updated__", direction: asc}]}
    ) {
      items {
        id
        updated_at
      }
    }
  }
}

Cheers,
Matias


kolaai
Forum|alt.badge.img
  • Author
  • monday.com Partner
  • September 27, 2023

Great news! Thank you 🙂


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 27, 2023

Happy to help @kolaai !


rachelatmonday
Forum|alt.badge.img
  • monday.com Team Member
  • September 27, 2023

Link to the announcement! 😃


samicaracand
Forum|alt.badge.img
  • Participating Frequently
  • September 28, 2023

It would be fantastic to allow us to query the board based on the order displayed to the user. For example, if the items have been rearranged manually or sorted via the sort option.

Is this on the roadmap?


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • September 28, 2023

Hi @samicaracand!

It is in the roadmap and I have added your vote for that request 😀 (No ETA yet)

Cheers,
Matias