Using RTE enabled fields in BI Publisher with PeopleTools 8.52

In PeopleTools 8.50 adding a Rich Text Editor to Long fields was introduced. With this RTE users are able to actually format text like you would do in for example Microsoft Word. This was a great feature for online entry and presentation in PeopleSoft. Unfortunately this does have a downside. The text that is entered and formatted using RTE gets stored in the database as HTML. This means that when you are using PSQuery to query the data, the data is presented as plain text with the HTML tags and therefor also not usable in any BI Publisher reporting.

With PeopleTools 8.52 a new tempate is introduced that solves this issue and renders the HTML tags in the Long field to the actual formatting the same way as presented in online PeopleSoft.

Get in control of your HTML Pagelets

With PeopleTools you have the ability to create pagelets using the Pagelet Wizard. Pagelet Wizard pagelets, also known to the rest of the world as portlets, are small pages that provide display-only snapshots of applicable content which can be placed on the PeopleSoft Homepage. With the Pagelet Wizard you can create a variety of pagelets:

• HTML
• IB Connector
• Integration Broker
• Navigation Collections
• OBIEE Report
• PeopleSoft Query
• Rowset
• Search record
• URL

This post describes how you can get more control in formatting and setting up your HTML pagelets.