collection_func.count is not working
#22443
Comments
|
Heya, I've tried replicating this in v10.11.0 on my end, but so far my GraphQL queries seem to work just find for m2m, m2a and o2m relations. Can you please share your collection setup, DB vendor and maybe even a stack trace you might be seeing in your Directus logs? |
|
Right! With this query: {
battles {
id
videos_func { count }
}
}The response is: {
"errors": [
{
"message": "An unexpected error occurred.",
"extensions": {
"code": "INTERNAL_SERVER_ERROR"
}
}
]
}And the error is:
From: Using PostgreSQL v15. And the collection is (both matchday & video are M2O): 
|
|
Are you seeing this in the app or when querying the API? Because the DB query looks like some additional filters are applied? |
|
Just with the query:
Payload: |
|
Just to double check, you're not using any custom hooks or flows that might transform that query before it hits the DB? |
|
Yes, no custom hooks / flows related to this query. |
|
The missing piece to reproducing this were the {
"_and": [{
"_or": [{
"battle": {
"status": {
"_eq": "published"
}
}
}, {
"matchday": {
"status": {
"_eq": "published"
}
}
}]
}]
} |
|
Right, in my matchdays and battle collections I have the status field. And in the permission I required to published. The videos has no status field. |
Describe the Bug
From Directus v10.11.0,
collection_func.counthas stopped working.With a GraphQL query like this (each battle has a list of videos):
{ battles { id videos_func { count } } }I get this error:
{ "errors": [ { "message": "An unexpected error occurred.", "extensions": { "code": "INTERNAL_SERVER_ERROR" } } ] }And if I remove the
videos_func { count }it works.It was working before update to v10.11.0.
To Reproduce
Create a GraphqQL query with
_func.count.Directus Version
v10.11.0
Hosting Strategy
Self-Hosted (Docker Image)
The text was updated successfully, but these errors were encountered: