How to add IN and NOT IN in the ERPNext Script Report

ERPNext Reports
1

Hello,

Can anybody teach me how to add IN and NOT IN in the ERPNext Script Report filter.

Thanks in advance. SDG :+1:

2

you can pass dict to filters parameter, for example

def get_data(filters):
    filters_dict = {}

    filters_dict["status"] = ["in", "Paid", "Unpaid"]

    si_list = frappe.get_all("Sales Invoice", filters=filters_dict)
3

Thank you for the reply @PyJumper .

image
I want to achieve this kind of filter on report filters.

image
image1363×543 37 KB

Just like this