Insights Global variable with Month(Visit_Date) Equals {{Variable_Key} throwing error [INVALID_PAYLO | Directus | Page 1

dusk dagger Nov 8, 2022, 6:40 AM

#

{
"errors": [
{
"message": "GraphQL schema validation error.",
"extensions": {
"code": "INVALID_PAYLOAD",
"graphqlErrors": [
{
"message": "Syntax Error: Expected ":", found "(".",
"locations": [
{
"line": 1,
"column": 1914
}
]
}
]
}
}
]
}

exotic wave Nov 8, 2022, 10:45 AM

#

This could be caused by the initial value of null before you fill the variable. Does setting a default value help?

dusk dagger Nov 8, 2022, 11:42 AM

#

No. I even tried this but still issue persists

#

this as well

#

#

even this

dusk dagger Nov 10, 2022, 1:48 PM

#

@exotic wave any guess on the issue?

exotic wave Nov 10, 2022, 1:53 PM

#

type mismatch for the month function perhaps

dusk dagger Nov 10, 2022, 2:22 PM

#

you mean it is a bug right?

#

should i post it in github?

dusk dagger Nov 10, 2022, 4:48 PM

#

exotic wave type mismatch for the month function perhaps

Month filter works fine well for the tabular view very well but it happens through Rest Api i guess

dusk dagger Nov 11, 2022, 8:37 AM

#

query { query_2695f143: Billsfromexcel_aggregated (limit: 1, sort: null, filter: {_and: [{status: {_nin: ["archived", "Draft", "draft"]}}, {_or: [{Bill_Number: {_contains: null}}, {PRO_Name: {_contains: null}}, {Department_Name: {_contains: null}}, {Client_Id: {_contains: null}}]}, {Department_Name: {_neq: "OTHERS"}}, {month(VisitDate): {_eq: "01"}}]}) { count { id } } }

#