Search code examples
erpnextfrappe

ERPNext: Join multiple tables using script report

Anyone know what is the ORM function for joining multiple db tables in ERPNext? I need query result from 2 DB tables join using script report

*I don't need query report answer since i already have it. I only looking for an example do it using script report

Solution

  • Frappe currently doesn't have ORM support for joining tables. You might have to use frappe.db.sql for the time being.