Hi Hussain, at around 47:10 you noticed that the filters you set have no impact on your front end, i.e. the filter field is not shown. You then made a note that the filters section should be removed if "Is Standard" is set to "Yes". I generally agree though it was helpful that you were able to simply copy the lines in the json file over to your js file in order to show the filter field. As such, wouldn't it be more user friendly if any filters set in the UI there will automatically change the js file instead of the json file (if Is Standard is set to Yes)?
Dear Hussain... Your work is awesome. How can we create an installment report based upon payment terms at sales invoice. Kindly make a short video. Thanks
why can't I see default option in filter for "Query Reports" even after clicking on edit button? I have checked the fields by customization option too, but a total of 6 fields are there only. Our site is hosted on frappe cloud. without default field, its giving error using popup every time, for each filter i am setting. Defining filters using JS script is not showing filter options all together.
Hi on 23rd minute you mentioned that we have functions in query reports that shows all records if nothing is selected in the filters, but I have tried so many things so many times, nothing seems to work on the Frappe Cloud environment. so If you have some solution that would be amazing
How your System console is able to run SQL query also i dont have field type in my system console did you change code in backend and also added this field from frontend what you did tell me, i also want to do that??
Hussain, I just want to than you for this awesome tutorial. It is well thought and brilliantly presented. Shukran Bhai
🤝 Really glad you found this useful!
Hi Hussain, at around 47:10 you noticed that the filters you set have no impact on your front end, i.e. the filter field is not shown. You then made a note that the filters section should be removed if "Is Standard" is set to "Yes". I generally agree though it was helpful that you were able to simply copy the lines in the json file over to your js file in order to show the filter field. As such, wouldn't it be more user friendly if any filters set in the UI there will automatically change the js file instead of the json file (if Is Standard is set to Yes)?
Really good tutorials! I wonder if it's possible you can clear the fog around Tree type doctypes since it adds extra fields to the actual DB table.
Dear Hussain... Your work is awesome.
How can we create an installment report based upon payment terms at sales invoice. Kindly make a short video. Thanks
Hello, is it possible to create an Override for the Jinja file for the general ledger report in my app ?
why can't I see default option in filter for "Query Reports" even after clicking on edit button? I have checked the fields by customization option too, but a total of 6 fields are there only. Our site is hosted on frappe cloud. without default field, its giving error using popup every time, for each filter i am setting. Defining filters using JS script is not showing filter options all together.
Hi 👋
Can you post this question here: discuss.frappe.io?
Hi on 23rd minute you mentioned that we have functions in query reports that shows all records if nothing is selected in the filters, but I have tried so many things so many times, nothing seems to work on the Frappe Cloud environment. so If you have some solution that would be amazing
There are functions on the SQL side, but Framework’s application logic does not work.. so I figured out it won’t work as of now.
How your System console is able to run SQL query also
i dont have field type in my system console
did you change code in backend and also added this field from frontend
what you did tell me, i also want to do that??
Hi 👋
Which version of Frappe are you on? It’s a Framework feature, not customisation.
@@BuildWithHussain 13 version
which one is yours
Cool. Can I set this report to only show to a specific user or role?
You can role permissions in report document.
where does these customs reports are saved in server side........?
How to add pie chart in Report list, Report Type - custom report.
Hussain how do you implement SST (Malaysia) inside ERPNext system though? My first time in erp. By the way your video are good.
You can make a custom app for the same. Here is the implementation of India’s tax localisation (GST): github.com/resilient-tech/india-compliance
where is the code ? Can you please provide its link
how to do filters? I think You have missed that.
Yeah, have to create a separate video for that 😀
Will cover it in a separate real world use case video I think.
@@BuildWithHussain thanks