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: u{column_id: "email_1", column_values: l${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: u{column_id: "email_2", column_values: l${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: u{column_id: "email_3", column_values: l${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
