How to use OR in filters for frappe.get_all

Frappe Framework Custom Script
1 
record = frappe.get_all("Membership",
                    filters=[
                        ["mr_number", "=", ""],
                        "or",
                        ["reg_sms", "=", 0]
                    ],
                    fields=["name"]
                )

i am i using the OR condition correctly, getting error

1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘or and tabMembership.reg_sms = 0.0\n\t\t\t\n\t\t\t order by tabMembership.`modi…’ at line 3”)

2

Hi @Vinay1:

Use or_filters

record = frappe.get_all("Membership",
                    or_filters=[
                        ["mr_number", "=", ""],
                        ["reg_sms", "=", 0]
                    ],
                    fields=["name"]
                )

Hope this helps.