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]

Do you have admin access? On the left navigation you should traverse to Reports -> All module as highlighted

Thank You

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

[andy_dufresne]

Thanks Alikutty, I was able to 'show xml' it shows the metadata but can't find any 'filter' or the table name mentioned.   I'm doing this on cmdb_rel_ci table. btw, I have admin access. After you said, I have gone ahead and added explicitly the 'report_admin' role.

[Alikutty A]

This is a sort of workaround, If you think the length of Filter column is too short on the list layout, You can remove all other columns except Titleand filter

Or else if the encoded query is too long then you can open a report and right click on header to Show XML and then copy the filter.

Thank You

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

[Alikutty A]

Hello Andy,

Did you check this screen print above, This is how you can locate the filter value. You can also use Control + F and search on the XML

Thank You

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

[andy_dufresne]

yes Sir 😞 I even exported into a text file and to check that.   May be something wired about my account or if something has changed in Istanbul.