Viewing Query Results With Drilling URLs
When you access the Run page of a query that has a Drilling URL defined, its query results are shown as links. Clicking these result links either:
Runs the destination query with prompt key values if the source query has prompt criteria defined and prompt keys are mapped to source query result columns.
Launches the component with the search key values if the source query has search keys defined and search keys are mapped to source query result columns.
Redirects the external URL.
You can also view the query results of a query that has drilling URL defined using the HTML links in Query Manager or Query Viewer.
In this query result page:
You can click the Excel Spreadsheet link to download query results to Microsoft Excel.
Note: The Excel Spreadsheet link in this query result page has the same usage as the Excel link in Query Manager or the Query Viewer search result page.
You can click the CSV Text File link to download query results into a CSV format file.
Note: Because CSV file is opened using a text editor such as Notepad and links do not apply to text editors, unlike HTML and Excel, no links exist in the CSV format file. However, if you select drilling URL as query selected field, then the drilling URL appears in a fully expanded version.
This is an example of CSV file content:
"QEDM1","10900","10900","http://myserver.example.com:8920/psp/ps_2/EMPLOYEE
/QE_LOCAL/c/QE_SAMPLE_APPS.QE_DEPT_TBL.GBL?Action=U&DEPTID=10900&SETID=QEDM1"