DB Column alias in frappe

Hi All,

Anybody know, if there is any function existing in frappe for getting columns with aliases ? like"Select first_name as Student_name from…"

I need a list of dict, so i am using frappe.get_all function. But want to retieve columns with aliases.

Thanks

Use

frappe.get_all('Task', ['first_name as name'])
1 Like

Thank You @netchampfaris

Its working…