custom filter in report

[gangadhar kadam]

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

[Nabin Hait]

You can add filter in old query report by using add_filter() function in js file.

For reference, check https://github.com/webnotes/erpnext/tree/master/accounts/search_criteria/accounts_receivable

Regards,

Nabin Hait

www.erpnext.com

--
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...@googlegroups.com.
To post to this group, send email to erpnext-dev...@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.
 
 

[गंगाधर कदम]

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.

--
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?