frappe.db.sql frappe.db.sql(query, values=None, as_dict=False)
parameter
| Parameter | Description |
|---|---|
query |
SQL query string |
values |
Dynamic values for query |
as_dict |
Return result as dictionary |
data = frappe.db.sql("""
SELECT
name,
customer,
grand_total
FROM tabSales Invoice
WHERE docstatus = %s
""", 1, as_dict=True)
[ { "name": "ACC-SINV-0001", "customer": "ABC", "grand_total": 5000 } ]
Last updated 2 months ago
Was this helpful?