Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
Hello Team,
I am trying to check like how many edges(entities in my case) are null in the view(event) is there any specific way to do so? I am trying right now sdk query api like below, but not working. Please give your insights.
{
"with": {
"Event": {
"nodes": {
"filter": {
"hasData": [
{
"type": "view",
"space": "slb-pdm-dm-governed",
"externalId": "Event",
"version": "1_7"
}
]
},
"chain_to": "destination",
"direction": "outwards"
},
"limit": 10000
},
"Event_2_entities.Entity": {
"edges": {
"from": "Event",
"direction": "outwards",
"filter": {
"and": [
{
"equals": {
"property": [
"edge",
"type"
],
"value": {
"space": "slb-pdm-dm-governed",
"externalId": "Event.entities"
}
}
},
{
"and": [
{
"hasData": [
{
"type": "view",
"space": "slb-pdm-dm-governed",
"externalId": "Event",
"version": "1_7"
}
]
},
{
"not": {
"exists": {
"property": [
"slb-pdm-dm-governed",
"Event/1_7",
"entities"
]
}
}
}
]
}
]
},
"chain_to": "destination"
},
"limit": 10000
},
"entities.Entity": {
"nodes": {
"from": "Event_2_entities.Entity",
"filter": {
"hasData": [
{
"type": "view",
"space": "slb-pdm-dm-governed",
"externalId": "Event",
"version": "1_7"
}
]
},
"chain_to": "destination",
"direction": "outwards"
},
"limit": 10000
}
},
"select": {
"Event": {
"sources": [
{
"source": {
"space": "slb-pdm-dm-governed",
"external_id": "Event",
"version": "1_7",
"type": "view"
},
"properties": [
"*"
]
}
]
},
"Event_2_entities.Entity": {}
},
"cursors": {
"Event": null,
"Event_2_entities.Entity": null
}
}
