I have added following custom filter but it does not working for following query
Query:- select * from (select dsr.site_id,dsr.site_name,a.vendor_id,a.types_of_services,ifnull(v.no_of_employee,0),ifnull(a.present_vendor,0),ifnull((v.no_of_employee),0)-ifnull((a.present_vendor),0) as Short_Fall,dsr.name,a.modified from (select f.site_id,f.site_name,f.name,f.modified from (select site_id,site_name,max(modified) as maxtime from tabDaily Site Report group by site_id) as x inner join tabDaily Site Report as f on f.site_id=x.site_id and f.modified=x.maxtime) as dsr join tabDSR Vendor Detail Main as a on a.parent=dsr.name join tabVendor Master Detail v on v.parent=dsr.site_id and v.types_of_services=a.types_of_services order by dsr.name) as z where z.Short_Fall=0 order by z.name
I have added following custom filter but it does not working for following query
Query:- select * from (select dsr.site_id,dsr.site_name,a.vendor_id,a.types_of_services,ifnull(v.no_of_employee,0),ifnull(a.present_vendor,0),ifnull((v.no_of_employee),0)-ifnull((a.present_vendor),0) as Short_Fall,dsr.name,a.modified from (select f.site_id,f.site_name,f.name,f.modified from (select site_id,site_name,max(modified) as maxtime from `tabDaily Site Report` group by site_id) as x inner join `tabDaily Site Report` as f on f.site_id=x.site_id and f.modified=x.maxtime) as dsr join `tabDSR Vendor Detail Main` as a on a.parent=dsr.name join `tabVendor Master Detail` v on v.parent=dsr.site_id and v.types_of_services=a.types_of_services order by dsr.name) as z where z.Short_Fall=0 order by z.name
I have added following custom filter but it does not working for following query
Query:- select * from (select dsr.site_id,dsr.site_name,a.vendor_id,a.types_of_services,ifnull(v.no_of_employee,0),ifnull(a.present_vendor,0),ifnull((v.no_of_employee),0)-ifnull((a.present_vendor),0) as Short_Fall,dsr.name,a.modified from (select f.site_id,f.site_name,f.name,f.modified from (select site_id,site_name,max(modified) as maxtime from `tabDaily Site Report` group by site_id) as x inner join `tabDaily Site Report` as f on f.site_id=x.site_id and f.modified=x.maxtime) as dsr join `tabDSR Vendor Detail Main` as a on a.parent=dsr.name join `tabVendor Master Detail` v on v.parent=dsr.site_id and v.types_of_services=a.types_of_services order by dsr.name) as z where z.Short_Fall=0 order by z.name
I have added following custom filter but it does not working for following query
Query:- select * from (select dsr.site_id,dsr.site_name,a.vendor_id,a.types_of_services,ifnull(v.no_of_employee,0),ifnull(a.present_vendor,0),ifnull((v.no_of_employee),0)-ifnull((a.present_vendor),0) as Short_Fall,dsr.name,a.modified from (select f.site_id,f.site_name,f.name,f.modified from (select site_id,site_name,max(modified) as maxtime from `tabDaily Site Report` group by site_id) as x inner join `tabDaily Site Report` as f on f.site_id=x.site_id and f.modified=x.maxtime) as dsr join `tabDSR Vendor Detail Main` as a on a.parent=dsr.name join `tabVendor Master Detail` v on v.parent=dsr.site_id and v.types_of_services=a.types_of_services order by dsr.name) as z where z.Short_Fall=0 order by z.name