Check unique rows in child table

[NCP]

Hi @Masoud_Hosseini,

Please check it.
I hope you help.

Count unique item in Child table

@Osama_Muhammad You can do that with ease using Query Builder. Replace "Sales Order Name" with the name of row you want, like docu.name. from frappe.query_builder.functions import Count doc = frappe.qb.DocType("Sales Order Item") data = ( frappe.qb.from_(doc) .select(doc.item_code, Count(doc.item_code).as_("total")) .where(doc.parent.eq("Sales Order Name")) .where(doc.parenttype.eq("Sales Order")) .where(doc.parentfield.eq("items")) .groupby(doc.ite…

Thank You!