Query to Return Column Value based on Another Column's value

Is it possible to merge two queries into one?

I want to return the column values for “Name” and “Email_Address” where the column “batch_5” = “70”.
this would be merging the queries for items_by_column_values and items?

This is the query I have but it returns all the columns:
query {
items_by_column_values (board_id: 1234, column_id: “batch_5”, column_value: “70”) {
name
column_values {
id
text
}
}
}

Was able to get it 99% there. Here is my query. Hope this helps someone in the future!
query {
items_by_column_values (board_id:1234, column_id:“batch_5”, column_value:“70”)
{name
column_values(ids:[“email_address”])
{text}}}

This returns:
{
“data”: {
“items_by_column_values”: [
{
“name”: “User1”,
“column_values”: [
{
“text”: “User1@gmail.com
}
]
},
{
“name”: “User2”,
“column_values”: [
{
“text”: “User2@gmail.com
}
]
},
{
“name”: “User3”,
“column_values”: [
{
“text”: “user3@gmail.com
}
]
},

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.