Help - Query Report

ERPNext Reports
1

Hi Guys,

I would like to create a query report where entering a production order would bring the material transferred between the warehouse . The materials being transferred between warehouses will be entered in the stock referring a production order , so when creating an alias the script does not work ,

select
    ste.production_order as "Production Order:Link/Production Order:120",
    ste_item.qty as "Cutting Qty:Float:60",
    ste_item1.qty as "Forging Qty:Float:60"
        
from
	`tabStock Entry` ste JOIN `tabStock Entry Detail` ste_item ON ( ste.name = ste_item.parent and ste.docstatus = 1 and  ste_item.t_warehouse in ('Cutting - OGE'))

JOIN `tabStock Entry Detail` ste_item1 ON ( ste.name = ste_item1.parent and ste.docstatus = 1 and  ste_item1.t_warehouse in ('Forging - OGE'))

Atleast how do I restrict where clause to specific select statement ?
Any help ?

Thanks

2

Please check this link, it maybe helpful to understand SQL

1 Like
3

Yes I did , I created few reports , everything works fine , now I am struck with this , I want to create multiple alias for tabStock Entry Detail (child table) how to do that ? The above code bricks the report ?
Any idea ?

Thanks