Find the SQL Generated for the Report

General
#1

Hi,

I want to verify what SQL is getting generated for the report in Open mode. How can I do this?

Thank You

1 Like
#2

Hi,

This can be achieved by using the Developer Tools of the browser.

  1. Press F12 or right click on the browser and go to Inspect. Developer Tools will open.

  2. Go to “Network” tab and open the Service call.

  3. You will see the formData section. Copy the encrypted text that is present within formData.

image

  1. Now, go to “Console” section.

  2. Use the following function in the console. Within quotes, pass the formData encrypted text (as shown in the image) and click enter.

atob(‘ENTER FORM DATA TEXT HERE’)
image

  1. You will see the decrypted formData. You can see the SQL columns, filters, filter values, metadata information etc. in the formData.

image

Thank You
From Team Helical