How filter None in doctype

I want to filter a doctype wich dose not has a value

I tried this :
frappe.get_list("Task", filters={ "exp_start_date": ( "!=",None), "exp_start_date": ( "!=",None)}, fields=["*"], order_by='name')

In this script I want to get all task wich dose not has a date but it is bring all task!

please Help


1 Like


You can use the mysql buit in functions in the filters i.e. ifnull

e.g. frappe.get_list("Task", filters={"ifnull(exp_start_date, '')": ["!=", ""]})