I have a very simple query
query MyQuery {
entityQuery(
entityType: NODE
filter: {conditions: {field: "id", operator: EQUAL, value: "215201"}}
) {
items {
id
... on NodePerson {
id
fieldLastName
}
}
}
}
it returns. the following
{
"errors": {
"message": "Unexpected token 'T', \"The websit\"... is not valid JSON",
"stack": "SyntaxError: Unexpected token 'T', \"The websit\"... is not valid JSON"
}
}
Looking at the error logs we get the following tow entries:
{
"$operation": {
"queryId": null,
"query": "query MyQuery {\n entityQuery(\n entityType: NODE\n filter: {conditions: {field: \"id\", operator: EQUAL, value: \"215201\"}}\n ) {\n items {\n id\n ... on NodePerson {\n id\n fieldLastName\n }\n }\n }\n}\n",
"operation": "MyQuery",
"variables": {
"type": "MEDIA",
"uuid": "2fe40ab-9893-44e4-86d3-4b9d77ea1ca5"
},
"extensions": null
},
"$result->data": {
"entityQuery": {
"items": null
}
},
"$result->errors": [
{
"message": "'id' not found",
"locations": [
{
"line": 6,
"column": 5
}
],
"path": [
"entityQuery",
"items"
]
}
],
"$result->extensions": []
}
AND
<code>
Drupal\Core\Entity\Query\QueryException: 'id' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable() (line 369 of /var/www/html/telemundov2drupalstage_pubv2-telemundo-multiverse_d-1XPPOWYNN/docroot/core/lib/Drupal/Core/Entity/Query/Sql/Tables.php).
Fixed
1.0
Code
The error log is quite verbose and clear.
There is no "id" field on Node.
The field is called "nid". Adapt your query accordingly.
Please keep in mind, that if you use entity query you have to stick to the Drupal database field names.
Automatically closed - issue fixed for 2 weeks with no activity.