Adding or condition in get_value

[jayakumar]

Is it possible to add or condition in get_value

date = frappe.db.get_value(
“Leave Statement”,
{
“employee”: ‘EMP-00001’,
“leave_type”: ‘Annual Leave’,
“type”: “Assignment” Or “type”:“Accrual”
},
“MAX(posting_date)”
)

"type": "Assignment" Or "type":"Accrual"

[Vipul_Kumar]

Atlernatively you can use frappe.db.sql

date = frappe.db.sql(
    """
    SELECT MAX(posting_date)
    FROM `tabLeave Statement`
    WHERE employee = %s AND leave_type = %s AND (type = %s OR type = %s)
    """,
    ('EMP-00001', 'Annual Leave', 'Assignment', 'Accrual')
)

[jayakumar]

@jayakumar

rappe.db.get_value

is any option in rappe.db.get_value

[Vipul_Kumar]

check this one

date = frappe.db.get_value(
    "Leave Statement", 
    {
        "employee": 'EMP-00001', 
        "leave_type": 'Annual Leave', 
        "type": ["in", ["Assignment", "Accrual"]]
    }, 
    "MAX(posting_date)"
)

[jayakumar]

Thanks for the support