Items_page sort desc with non-empty first

monday Apps & Developers
, , ,
1

Hi!

Is there a way to call items_page sorting by a column using desc direction and bring the non-null (non-empty) items first?

Screenshot 2023-11-08 at 09.58.06
Screenshot 2023-11-08 at 09.58.062384×1426 166 KB

In this query I’d like to return in this order [8, 4, null] instead of [null, 8, 4].

2 Likes
2

Hello there @helderalvesappfire,

If you want the order to be desc, you will get the null first unless you exclude the nulls with a query like this one:

{
  boards(ids: 1234567890) {
    groups(ids: "topics") {
      items_page(
        query_params: {order_by: [{column_id: "score54", direction: desc}], rules: [{column_id: "score54", compare_value: "", operator: is_not_empty}]}
      ) {
        items {
          id
          column_values(ids: "score54") {
            text
          }
        }
      }
    }
  }
}

Cheers,
Matias

1 Like
3

Thank you @Matias.Monday .

But I would like to bring the nulls at the end also and it starts to get complex to track pagination for 2 queries (one with is_not_empty and other with is_empty).
It would be nice to have something like

query_params: {order_by: [{column_id: "score54", direction: desc, nullsLast: true}]}
3 Likes
4

Hello again @helderalvesappfire,

I will share this as a request for our R&D team!

Cheers,
Matias

3 Likes