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

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.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5086ceb7-515a-4f4b-8b10-45ddbd3b0429%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
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



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    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 view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/23bb22e7-b6e6-485c-9f2f-bee9d91c2b53%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.