query underneath the report, possible?

andy_dufresne · ‎05-17-2017

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 · ‎05-17-2017

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

View solution in original post

Alikutty A · ‎05-17-2017

Hi Andy,

You can navigate to Reports -> All module, add Filter column on the list layout and then copy the encoded query from the column.

Thank You

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

andy_dufresne · ‎05-17-2017

Thanks Alikutty. Which version are you using? I'm on Istanbul I can't find filter, but able to see the other fields like title, table from your screenshot. Is this configured differently in Istanbul, by any chance?

Alikutty A · ‎05-17-2017

You will need to configure your list layout and add the filter column.

Thank You

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

andy_dufresne · ‎05-17-2017

Thanks for quick response, but there is no such thing for me. See: