I'm trying to see all the data related with my database (table) for all my organizations.I'm using this query bellow:
Can anyone support me with this? Because I can't see the record
{""query"": ""{ organizations { id tables{edges{node{id table_fields{id label {id name} } table_records{ edges {node {id title parent_relations {id repo }}}}}}}}}""}"
Best answer by Roberto Chavarria
Hello Nigel! Here is an example of how you should create the query. (There must be parameters added to specify what organization you want to look at)
{
organization (id:123456) {
id
tables {
edges {
node {
id
table_fields {
id
label
}
labels{
name
id
color
}
table_records {
edges {
node {
id
title
parent_relations {
id
repo
}
}
}
}
}
}
}
}
}
Also, the “label” attribute inside the “table_fields” object is the field’s name, and not actual color labels. I added that section below the table fields object so that you can see those as well.
+5Hello Nigel! Here is an example of how you should create the query. (There must be parameters added to specify what organization you want to look at)
{
organization (id:123456) {
id
tables {
edges {
node {
id
table_fields {
id
label
}
labels{
name
id
color
}
table_records {
edges {
node {
id
title
parent_relations {
id
repo
}
}
}
}
}
}
}
}
}
Also, the “label” attribute inside the “table_fields” object is the field’s name, and not actual color labels. I added that section below the table fields object so that you can see those as well.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.