OS info
- Operating System : Windows 10.0.19045
- Wappler Version : 7.0.0-rc.4
Problem description
{
"name": "validation",
"module": "core",
"action": "validation",
"options": {
"error": "Invoice not found. Please check the invoice ID and try again.",
"condition": "{{verify}}",
"status": "400"
},
"meta": []
},
{
"name": "transaction",
"module": "dbupdater",
"action": "transaction",
"options": {
"connection": "db",
"queries": [
{
"type": "delete",
"table": "invoice_items",
"wheres": {
"condition": "AND",
"rules": [
{
"id": "invoice_id",
"field": "invoice_id",
"type": "double",
"operator": "equal",
"value": "{{$_GET.invoice_id}}",
"data": {
"column": "invoice_id"
},
"operation": "="
}
]
},
"query": "DELETE\nFROM invoice_items\nWHERE invoice_id = :P1",
"params": [
{
"name": ":P1",
"type": "expression",
"value": "{{$_GET.invoice_id}}"
}
]
},
{
"type": "delete",
"table": "invoices",
"wheres": {
"condition": "AND",
"rules": [
{
"id": "id",
"field": "id",
"type": "double",
"operator": "equal",
"value": "{{$_GET.invoice_id}}",
"data": {
"column": "id"
},
"operation": "="
}
]
},
"query": "DELETE\nFROM invoices\nWHERE id = :P1",
"params": [
{
"name": ":P1",
"type": "expression",
"value": "{{$_GET.invoice_id}}"
}
]
}
]
},
"meta": [
{
"name": "affected",
"type": "number"
}
],
"output": true
},
