Hello All,
I have to add custom filters in report of custom query in old framework. My custom query is
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 to add filters for site id, site name, vendor id etc.
Thank you
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To post to this group, send email to er...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/rzP-N7a-u4IJ.
For more options, visit https://groups.google.com/groups/opt_out.
You can add filter in old query report by using add_filter() function in js file.
On 08-Mar-2013, at 12:49 PM, gangadhar kadam wrote:
Hello All, I have to add custom filters in report of custom query in old framework. My custom query is
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 to add filters for site id, site name, vendor id etc.
Thank you
–
You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.
To post to this group, send email to er…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/rzP-N7a-u4IJ.
For more options, visit https://groups.google.com/groups/opt_out.
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To post to this group, send email to er...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Thank you Sir,
I have added filters but not working.
I have to add filter in vendor master report and custom query is
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
Thank you.
On 8 March 2013 12:53, Nabin Hait
<na...@gmail.com> wrote:
You can add filter in old query report by using add_filter() function in js file.
On 08-Mar-2013, at 12:49 PM, gangadhar kadam wrote:
Hello All, I have to add custom filters in report of custom query in old framework. My custom query is
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 to add filters for site id, site name, vendor id etc.
Thank you
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.
To post to this group, send email to er…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/rzP-N7a-u4IJ.
For more options, visit https://groups.google.com/groups/opt_out.
--
Thanks & Regards,Mr.Gangadhar N.Kadam.
Cell: +91 9960066444
Software Engineer,
New Indictrans Technologies Pvt. Ltd., Pune
P SAVE TREES - Please consider the environment before printing this email.
SAVE ENERGY - My monitor is off whenever I am away from my desk. I am helping prevent global warming by reducing consumption of power... ARE YOU?
–
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To post to this group, send email to er...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.