Solved

Help database

  • 11 January 2021
  • 1 reply
  • 66 views

Userlevel 5

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 }}}}}}}}}""}"

 

icon

Best answer by Roberto Chavarria 13 January 2021, 13:49

View original

1 reply

Userlevel 5
Badge +5

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.

Reply