Thanks for you quick response. This is the code of the flow I was editing, while it also happens once in a while in others flows, so I don't think the code in the flow really causes the error.
{
"meta": {
"$_GET": [
{
"type": "text",
"name": "sort"
},
{
"type": "text",
"name": "dir"
}
]
},
"exec": {
"steps": [
{
"name": "",
"module": "core",
"action": "exec",
"options": {
"exec": "check_logged_in"
}
},
{
"name": "query",
"module": "dbconnector",
"action": "select",
"options": {
"connection": "Supabase",
"sql": {
"type": "select",
"columns": [],
"params": [
{
"operator": "equal",
"type": "expression",
"name": ":P1",
"value": "{{$_GET.datum}}",
"test": ""
}
],
"table": {
"name": "data_endex_kwartalen"
},
"primary": "id",
"joins": [],
"query": "select * from \"data_endex_kwartalen\" where \"data_endex_kwartalen\".\"datum\" = ? order by \"jaar\" ASC",
"orders": [
{
"table": "data_endex_jaren",
"column": "jaar",
"direction": "ASC",
"recid": 1
}
],
"wheres": {
"condition": "AND",
"rules": [
{
"id": "data_endex_kwartalen.datum",
"field": "data_endex_kwartalen.datum",
"type": "date",
"operator": "equal",
"value": "{{$_GET.datum}}",
"data": {
"table": "data_endex_kwartalen",
"column": "datum",
"type": "date",
"columnObj": {
"type": "date",
"primary": false,
"unique": false,
"nullable": true,
"name": "datum"
}
},
"operation": "="
}
],
"conditional": null,
"valid": true
}
}
},
"output": true,
"meta": [
{
"type": "text",
"name": "id"
},
{
"type": "datetime",
"name": "created_at"
},
{
"type": "date",
"name": "datum"
},
{
"type": "number",
"name": "jaar"
},
{
"type": "number",
"name": "base"
},
{
"type": "number",
"name": "p12hrs"
},
{
"type": "number",
"name": "op12hrs"
},
{
"type": "boolean",
"name": "verwijderd"
},
{
"type": "text",
"name": "kwartaal"
}
],
"outputType": "array"
}
]
}
}
