Skip to main content

SubItems By Multiple Column Values

  • January 27, 2023
  • 5 replies
  • 823 views

  • Participating Frequently

Am I missing something or didn’t we used to be able to specify the Subitem Board ID when performing queries like listing subitems or subitems by column values or multiple column values?

Ive been trying to query multiple dates using a date column and it errors “500” when using subitem board id and finds nothing when using the main board id since my items do not include the date column. Is there a way to include the columns from subitems?

5 replies

Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • January 29, 2023

Hello @dean_m,

Let me know if I understand correctly.

You are using the items_by_column_values to get the data of subitems. Correct?

If that is the case, I just tested it and it is working fine to me. I used this query:

{
  items_by_column_values(board_id: SUBITEMBOARDID, column_id: "SUBITEMCOLUMNID", column_value: "THEVALUEIAMLOOKINGFOR") {
    id
  }
}

Can you share the query you are using and the exact error you are getting?

Cheers,
Matias


  • Author
  • Participating Frequently
  • January 29, 2023

@Matias.Monday I was searching using items_by_column_values

{
  items_by_multiple_column_values(column_values: ["2023-01-25","2023-01-26"], board_id: 3886193895, column_id: "date8") {
    id
    name
    column_values {
        id
        value
        text
        }
  }
}

I get the error

{
“error_message”: “Internal server error”,
“status_code”: 500
}


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • January 30, 2023

Hello again @dean_m,

Thank you for that information.

That is strange. I used the exact same structure and it works:

Are you sure that the board ID you are using is correct?

If you use a wrong board ID, you can get a 500 error.


  • Author
  • Participating Frequently
  • January 30, 2023

I’ll just chalk it up to a glitch with my account. I’m no longer using date due and using date range/time range. Will post to another discussion the issue Im having with that to keep them clean.


Matias.Monday
Forum|alt.badge.img
  • monday.com Team Member
  • January 31, 2023

Let us know if you need anything else here!