prjs = frappe.db.get_list(“Item”, filters=[{‘territory.pincode’:‘670101’}], fields=[‘item_code’,‘item_name’,‘property_type’,‘company’])
filters=[{‘territory.pincode’:‘670101’}] => How to filter based on child table value
I am getting error here saying there is no field like tabItem.territory.pincode