Notifications
Clear all

[Solved] How can I easily find the report I am viewing on the UI within the project?

1 Posts
1 Users
1 Reactions
785 Views
0
Topic starter

I have a report and need to change the underlying SQL. I find it difficult to search through the entire project and all modules to find the correct report that needs changing. What is the easiest way to find the report and SQL that I am viewing on the UI?

1 Answer
1
Topic starter

The easiest way to track down the report and SqlDef that is being used is by using DevTools and a file searching tool.

Open DevTools using Ctrl+Shift+I.
Click “Network” Tab.
Click “Clear” button to remove previous entries.

image
image

 

Open Report

image

View entry in DevTools. Click on report?reportName entry. We can now search on reportName within our project. 

image

Open file searching tool (example being Agent Ransack). Copy the value after the Module prefix into the “Containing Text”. Select a location based on module prefix. In this example, the report name was SCC.SearchBufferReport, so I will look in the SupplyChainCore module. If the reportName was DPX.ReportName, I would search in the DemandPlanning module.

image

Find the entry that has the exact text you searched for within the <Name> XML tags. Open that file and search for your reportName. This will display the underlying SQL that supports the report you are viewing on the UI

image