Hello dears:
please, how to apply IS NULL filter in frappe queries
SQL query: select * from categories where parent IS NULL;
what is the opposite in frappe:
frappe.get_list(“categories”,
fields=[
“name”],
filters={
“parent”: ‘IS NULL’ ??
},
ignore_permissions=True)
@Omar_Salah You can try this.
frappe.get_list("Category", fields=["name"], filters = {"parent": ("=", "")})