How to see the mysql query passed by report on Firefox console?

[Aditya Duggal]

Hi,

I have been writing a lot of script reports on erpnext for my own purposes. I am facing a problem while debugging my code, the problem is that I am not able to find the mysql query which is being passed on after application of filters etc.

Is there a way that we could look at the query on the console so that I could debug it properly.

[MP]

Hi Aditya,

In version 2 (Apache + CGI), you can enable logging of SQL queries by setting logging = 2 in conf.py file under erpnext directory. I am not sure if it has been implemented in version 3 and version 4. This is very helpful when debugging reports etc. It should be part of version 3 and Version 4.

Kind regards,
Mayur Patel