How to use items_page_by_column_values with Text of lookup field

monday Apps & Developers
,
1

I’m running the following query on 2023-10, which tries and restrict the results to subitems assigned to myTeam (using the summary column on the item level)

query {
	items_page_by_column_values (board_id: XXXXXXX, columns: [{column_id: "subitems_team", column_values: ["myTeam"]}]) {
    cursor
    items {
      id
      name
    }
  }
}

The above gives me a

Column of type lookup is not yet supported for this query

was hoping for a workaround? (even though the “not yet” is promising)

2

Hello there @tonicondor and welcome to the community!

I hope you like it here :muscle:

As of today, there is no direct workaround for this using the UI.

There are two things that come to mind to try to build a workaround:

  1. You can create a script tied to a webhook (or an app) that checks the connected board and connected items from a connect_boards column, and then query for the information inside those items, and cast the value of the desired column in a “text” column (instead of using a mirror column). This requires a script and some work, but it could solve the issue.

  2. This only works if you are doing a one time thing and you don’t plan on using the mirror column as such anymore: You can change the column type from mirror to text, and then you can use the text column to look for specific values. Again. This only works if you are not planning on adding more stuff to the mirror column

Let me know if you have any other questions :slightly_smiling_face:

Cheers,
Matias

1 Like