[SOLVED] Frappe Sql query needed

I have a sql query

Select  * from abc where con='qwer'

The result of this query is a list of data.
How do I get that data in frappe ?

Should I use

list = frappe.db.fetch_as_dict("Select * from `tabAdd to Order` where parent = (%s);",(self.order_list))

Please provide me a frappe module to do similar functioning.

Using

fetch = frappe.db.sql("Select selected,quantity from `tabAdd to Order` where parent = (%s);",(self.order_list))

solved my problem.
Thank you.

2 Likes