query underneath the report, possible?

[andy_dufresne]

Thanks to nice graphical representation of parent and dot-walking in the report-module, I was able create the exact report. Now my next step is to write it in query format, so I can build further on it.   I'm struggling to get the parent child relationship as easily as in the report. So I was wondering if there was anyway we can find the 'encoded query', regular query behind a report? Any clues? Thanks for reading!

[Alikutty A]

I am also on Istanbul, What are you seeing at your end. Can you share a screen print so I can check on it?

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[andy_dufresne]

[Alikutty A]

It seems you are on a different table for CI relations, Can you please open the report for which you want to copy the query?

You should search your report first from Reports -> All navigation menu and then open it to perform Show XML.

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response

[andy_dufresne]

tried both edit report and view report:

[Alikutty A · Accepted solution]

On your first image, Click on the i information icon and this will open the actual report configuration.

The report configuration will look something like this

On this form, you should right click on header and do a Show XML.

Please try it once, If this does not help you can add the Filter column on the list layout and also export the data.

Thank You

Please Hit Like, Helpful or Correct depending on the impact of response