Best way to search for multiple emails across multiple boards

Hey @Zepticona
I checked with the team and got a code that this should look like this:

query GetBoardItems {
  boards(ids: [7753601158, 7753604175, 37753606898]) {
    items_page(
      limit: 50
      query_params: {rules: [{column_id: "email__1", compare_value: ["a@a.com", "b@a.com", "c@a.com"], operator: any_of}]}
    ) {
      items {
        id
        name
        column_values {
          id
          value
        }
      }
    }
  }
}

Let me know if this helps

Hi @OmerK

I really apprecaite you getting back to me on this. It just shows how dedicated you are to helping the community.

Now, that’s amazing what you’ve given me. I kind of knew that it would be something like this but I couldn’t really figure it out.

By the way, on the process of lowering the query time, I discovered that the query takes significantly less time if I chain the queries per board. So if I have an email column titled email_1, email_2, and email_3 on 3 different boards, I could do somehting like

query {
  firstQuery: items_page_by_column_values(
    limit: 50
    board_id: 1613606727
    columns: [{column_id: "email_1", column_values: [${emails.map((str) => `"${str}"`).join(", ")}]}]
  ) {
    cursor
    items {
      id
      name
      board {
        name
      }
      column_values(ids: ["email_1"]) {
        id
        value
      }
    }
  }
  secondQuery: items_page_by_column_values(
    limit: 50
    board_id: 1613687876
    columns: [{column_id: "email_2", column_values: [${emails.map((str) => `"${str}"`).join(", ")}]}]
  ) {
    cursor
    items {
      id
      name
      board {
        name
      }
      column_values(ids: ["email_2"]) {
        id
        value
      }
    }
  }
  thirdQuery: items_page_by_column_values(
    limit: 50
    board_id: 1613695311
    columns: [{column_id: "email_3", column_values: [${emails.map((str) => `"${str}"`).join(", ")}]}]
  ) {
    cursor
    items {
      id
      name
      board {
        name
      }
      column_values(ids: ["email_3"]) {
        id
        value
      }
    }
  }
}

I have chained a total of 8 queries like this for 8 boards. I get a query time of about 7seconds on average for 3/4 emails which is pretty good for now.

My question to you is, will this new query lower the search time by a few seconds? Keep in mind that I’ll still have to chain a few queries like this. Because while 5 of my boards have the same column_id value for the email column, 2 of them use a different one, and 1 of them use another one. Obviously I’ll do my tests as well but wanted to know if you or the team have any data on the time complexity of this. Thanks!

Hello there @Zepticona,

Matias from the technical support team here!

We can not specify the response time for the queries since there are many fields and factors that can affect them.

We encourage the developers to test in their own specific scenarios, what works best for them in relation to response times when comparing different queries 😀

Let us know if you have any other questions!

Cheers,
Matias