Transform the PSQuery

You might have already noticed a new tab on the PSQuery Manager - Transformations.

This is the place where you can place your custom XSL code and render the query in a much better way, than displaying it in a traditional way.

The best part I loved about this is that, you can create excellent report from the query, without using any existing reporting tools, but with just few lines of XSL + HML fused together. That's awesome!

To add a new XSL, click on the Add XSLT button.

It opens the data entry window for you to place the XSL.

To view the XSL effect on the query, click on the Preview button.

The XSL which I placed, transforms the query into a  tabular structure and easy to go through.

If you want to generate the transformed report, then schedule the query and you have it!

Connected Query - PeopleCode Implementation

The link below the PeopleCode implementation of the connected query.

http://mfinchps.blogspot.com/2011/05/how-to-launch-connected-query-xml.html

PSQuery drilling feature

For those who havn't tried this feature:
After creating the query, go to Expressions tab and click on the Add Expression.

Search keys when clicked on it will give you the URL keys scroll which you selects as the parameters passed to the target component.

Map URl to Query coloumns: to hyperlink the field of your wish in the query result

In the above query result you can see the emplid KU0007 is hyperlinked.