OS info
- Operating System : Windows 10.0.22631
- Wappler Version : 7.3.6
- Claude Sonnet 3.7
Problem description
{
"name": "checkCurrentVendorCount",
"module": "dbconnector",
"action": "single",
"options": {
"connection": "db",
"sql": {
"type": "SELECT",
"columns": [
{
"table": "",
"column": "COUNT(*) AS vendor_count"
}
],
"table": {
"name": "expo_vendors"
},
"joins": [],
"wheres": {
"condition": "AND",
"rules": [
{
"id": "expo_vendors.expo_id",
"field": "expo_id",
"type": "double",
"operator": "equal",
"value": "{{$value.expo_id}}",
"data": {
"column": "expo_id"
},
"operation": "="
}
]
}
}
},
"meta": [
{
"name": "vendor_count",
"type": "number"
}
],
"outputType": "object"
}