I have some doctype like this
Doctype Karyawan (in english is Employee) have field:
Perusahaan (table options to Karyawan Perusahaan doctype)
Doctype Karyawan Perusahaan (child table) have field:
Perusahaan (link options to Perusahaan doctype)
Doctype Perusahaan (in english is company) have field:
Nama (data mandatory)
I need to filter Karyawan where have Perusahaan A, how i do filter this? for now i have this code, but it didnt work
attendance_records = frappe.get_all(
"Absensi",
filters={
"waktu_absen": ["between", date_range],
"tipe": "In",
"karyawan": ["in", frappe.get_all(
"Karyawan",
filters={
"perusahaan": filters.perusahaan
},
pluck="name"
)]
},
fields=["lokasi_absen", "karyawan", "tipe", "waktu_absen", "ambil_jatah_makan", "telat", "izin"],
)