Use filter in get_list

ERPNext Customize ERPNext
,
1

Hi,
I have below code

    request_site_expense = frappe.get_all("Request Site Expense", filters={
        "approval":frappe.session.user,
        "owner": frappe.session.user
        }, fields=["name", "total_amount", "workflow_state", "date", "total_amount_worker_advance", "payment_type"])

above code is use and between two filter, but I want to use or

Ho I can achieve this?

2

maybe I can solve this using

frappe.db.sql

but I need the response be like below key:Value

Screenshot from 2024-04-21 11-58-00
Screenshot from 2024-04-21 11-58-001059×618 37.8 KB

3 
# get all request site expense
@frappe.whitelist()
def get_request_site_expense():
    query = """
        SELECT name, total_amount, workflow_state, date, total_amount_worker_advance, payment_type
        FROM `tabRequest Site Expense`
        WHERE (approval = %s OR owner = %s)
    """
    values = (frappe.session.user, frappe.session.user)
    request_site_expense = frappe.db.sql(query, values, as_dict=True)  # Fetch data as dictionaries
    return request_site_expense