Items_page for group

Platform discussions monday apps & integrations
,
1

Hello,
Im using GraphQL with the new api version (2024-04) and im trying to pull all the items in a specific board and group and also that the value in the date column will be a specific date as well.

Im a bit new to items_page and so Ive managed to create the following query which doesn’t work for some reason.

Im not getting any error, its just that the result is empty which is surely not correct.
Also, Im sure the columns id and variables are correct, so its probably the request structure.

Do you have any idea what can be the issue?
Thanks!

query {
  boards(ids: 2454720532) {
    items_page(query_params: { rules: [
        { column_id: "group", compare_value: ["topics"] },
        { column_id: "date", compare_value: ["2024-03-28"] }
      ] }) {
      cursor
      items {
        id
        name
      }
    }
  }
}
2

Few things here.

  • “group” is not a column_id, you can’t query by group using the query_params
  • when comparing dates, you need a compare operator

Something like this will work

{
  boards(ids: 2454720532) {
    groups(ids: "topics") {
      items_page(
        query_params: {rules: [{column_id: "date", compare_value: ["EXACT", "2024-03-28"], operator: greater_than_or_equals}]}
      ) {
        cursor
        items {
          id
          name
        }
      }
    }
  }
}```
1 Like
3

It worked!
You are awesome, Thanks!

Ive got another question if I may:

Is that possible to use labels within query params for a “status” column?
I see that it works with index (int) but failed to receive text as for label.

I also looked for it on the documentation and couldn’t find a solution.
I noticed that its possible to use text when i use “items_page_by_column_values” but not on “items_page”.

This is the code i used for retrieving the status with text, that didn’t work:

query {
  boards(ids: 4857196688) {
    items_page(query_params: {
      rules: [
        { 
          column_id: "status", 
          compare_value: ["Done"]
        },
        { 
          column_id: "date4", 
          compare_value: ["EXACT", "2024-03-28"],
          operator: greater_than_or_equals
        }
      ],
      operator: and
    }) {
      cursor
      items {
        id
        name
      }
    }
  }
}

Again, Thanks a lot

4

See Status

Filtering a status column can only be done by the label index, not the label text

5

I’ve actually had success using the “contains_terms” operator with a precise label match to get a single label choice. (Can’t seem to items matching more than one label since its an all terms not any terms)

6

The query structure is correct, but the problem may be with the comparison parameters. Make sure the compare_value for the date column is in the correct date format and matches the format used in your database. Also make sure your filter rules correctly identify the group and date. Check your data and make sure it matches the request.