Getting the above error when running the following query: query
{
useCompany(no: 4816282)
{
queryResult : order
(
filter: {_and :[{orderNo :{_gt:100}},{customerNo :{_gt:0}}]},
groupBy: [{customerNo : DEFAULT},{orderDate : DEFAULT},],
having: {_or :[{_and :[{_sum : {orderSumNetDomestic :{_gt:100000}}},{_sum : {orderSumNetDomestic :{_lt:200000}}}]},{_count : {orderNo :{_gt:100}}},{_sum : {orderSumNetInCurrency :{_gt:30000}}}]}
)
{
totalCount
pageInfo
{
hasNextPage
hasPreviousPage
startCursor
endCursor
}
items
{
customerNo
orderDate
aggregates
{
sum
{
orderSumNetDomestic
}
count
{
orderNo
}
}
}
}
}
} The response : {
"errors": [
{
"message": "Error: SQL command no. 3010 failed.Database error.",
"extensions": {
"data": {
"status": 2,
"status_name": "DatabaseError"
}
}
}
],
"data": {
"useCompany": {
"queryResult": {
"totalCount": 906,
"pageInfo": {
"hasNextPage": false,
"hasPreviousPage": false,
"startCursor": null,
"endCursor": null
},
"items": null
}
}
},
"extensions": {
"vbnxt-trace-id": "0000000000000000e39a78870186bda1"
}
} This query worked about a week ago so something must have happened ??
... View more