Tuesday, 8 March 2011

Queries with Hyperlinks

From PeopleTools 8.50 the PS Query tool allows the user to create a hyperlink to another Query, PeopleSoft component or an external link. You can also bind into the url string fields from the query. Very powerful. However, there are two BIG issues that I've discovered

1) if you schedule a Query to Excel then the Query parameters are displayed horizontally in the first rows of the worksheet. The code that inserts in the hyperlinks is not expecting the parameters to be there and so starts adding the links at row 2. This means that the hyperlinks are out of step with the rows of data and the last n rows have no hyperlink at all. Reported this to Oracle support and have a POC to fix this for 8.50.11.

2) The other issue is that hyperlinks seem to increase the size of the Excel file massively. So when a Query is run to window there is a size in bytes shown to the right of the links to download to Excel, CSV and XML. Not sure quite what this size is but it never matches any of the download sizes (could well refer to the JOLT data message in bytes). Anyway, the screenshot below shows the result of adding a single drilling link to an existing field. The Excel file without the link is 8,721KB and the same Query with the link added increases the size of the Excel file to a massive 36,516KB. Note the CSV and XML output types are similar sizes.

Logging this with Oracle.