Date filters one2many field in Payroll salary rules

salary_rule.py

# Access employee shipments and filter by payslip date range
shipment_count = len(employee.shipments.filtered(
    lambda s: s.scheduled_date and s.scheduled_date.date() >= payslip.date_start and s.scheduled_date.date() <= payslip.date_end
))

# Return the shipment count for further calculations if needed
result = shipment_count

# Access employee shipments and filter by payslip date range
total_trip_cost = sum(employee.x_studio_one2many_field_5kk_1ia59qec4.filtered(
    lambda s: s.scheduled_date and s.scheduled_date.date() >= payslip.date_from and s.scheduled_date.date() <= payslip.date_to
).mapped('x_studio_trip_expenses'))

# Return the total trip expenses cost for further calculations if needed
result = total_trip_cost