Why does this Query: column 'mirror0' not display any value even though the 'mirror0' column has data? Is it a bug or is the Query incorrect?

monday Apps & Developers
,
1

Why does this code Query: column ‘mirror0’ not display any value even though the ‘mirror0’ column has data? Is it a bug or is the ‘code query’ incorrect?

Query 1

(some columns have data while others do not)

set headers “api-version”: “2024-04”

query ($boardId: ID!) {
  boards(ids: [$boardId]) {
    items_page(
      limit: 5,
      cursor: null,
      query_params: {
        rules: [
           {
             column_id: "name",
             compare_value: ["Monitoring"],
             operator: contains_text
           },
           {
             column_id: "mirror3",
             compare_value: "0944818233"
           },
           {
             column_id: "text43",
             compare_value: ["2023-02-01", "2024-12-31"],
             operator: between
           }
        ],
        order_by: [
          { column_id: "text43", direction: desc }
        ]
      }
    ) {
      cursor
      items {
        id
        name
        column_values {
          id
          type
          text
          value
        }
        subitems {
          id
          column_values {
            value
            text
          }
        }
      }
    }
  }
}

image
image1078×870 53.8 KB

Query 2

However, using this ‘code query,’ the ‘mirror0’ column has data, which matches the web page.

query {
  boards(ids: xxxxxxxx) {
    id
    name
    state
    items(limit: 50, page: 1) {
      name
      created_at
      column_values(ids: [
          "subitems",
          "long_text"
          "mirror0"
          "text43"
        ]) {
        id
        title
        text
      }
    }
  }
}

image
image917×862 48.7 KB

Question 1 :

How can I fix Query 1 so that the ‘mirror0’ column displays the correct results?

Question 2 :

image
image1920×1098 171 KB

.
I want ‘Code Query 1’ to get data from the ‘Conversation’ for each item (as highlighted in yellow in the image). What type of code query should I use to get the ‘Conversation’ data? Do you have any recommended code query?

2

Look at the use of display_value in a column value v2 for mirror column use.

3

Hello there @nitichas and welcome to the community!

I hope you like it here :muscle:

Regarding the mirror column value, I think what Cody mentioned is what you need to use.

Regarding the “conversation” you mentioned, that is the “updates section” and you can query updates as explained here :grin:

Cheers,
Matias

4

Do you have any recommendations on how to retrieve the values for “column mirror”, “Type mirror, subtasks, board_relation, board_relation” and be able to use items_page to search for values by type? Is this possible with API version 2023-10 or a higher version? I really need this functionality.

5

Do you have a recommended code query ‘{ column_id: “updates.created_at”, direction: desc }’ to sort the updates.created_at column from high to low? Do you have any recommendations?

api-version: 2024-04

query ($boardId: ID!) {
  boards(ids: [$boardId]) {
    id
    name
    items_page(
      limit: 5,
      cursor: null,
      query_params: {
        rules: [
        #   {
        #     column_id: "name",
        #     compare_value: ["Monitoring"],
        #     operator: contains_text
        #   },
        #   {
        #     column_id: "mirror3",
        #     compare_value: "0832656xxxx"
        #   },
        #   {
        #     column_id: "text43",
        #     compare_value: ["2023-02-01", "2024-12-31"],
        #     operator: between
        #   }
        ],
        order_by: [
          { column_id: "text43", direction: desc },
          { column_id: "updates.created_at", direction: desc }
        ]
      }
    ) {
      cursor
      items {
        id
        name
        url
        updates(limit:20) {
            body,
            created_at
            creator {
                name
                id
            }
        }
        column_values {
          id
          type
          value
          text
        }
        subitems {
          id
          name
          url
          column_values {
            id
            type
            value
            text
          }
        }
      }
    }
  }
}