message = “Test ToDo Report”
columns = [
{
‘fieldname’: ‘name’,
‘label’: _(‘ID’),
‘fieldtype’: ‘Data’,
‘width’: 200
},
{
‘fieldname’: ‘owner’,
‘label’: _(‘Opportunity Owner’),
‘fieldtype’: ‘Data’,
‘width’: 200
},
{
‘fieldname’: ‘todo_name’,
‘label’: _(‘ToDo’),
‘fieldtype’: ‘Data’,
‘width’: 200
},
]
mydata = “”"
SELECT
name,
owner,
name as todo_name
FROM tabToDo
“”"
data = frappe.db.sql(mydata, as_dict=True)
result = (columns, data, message, None, None)