Adding a CLOB field in Jaspersoft Studio and display it as String in the report in Clarity PPM

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How to add CLOB field in Jaspersoft Studio, looking in the report it just shows an Oracle field reference but not the actual text value. How can the file be displayed as a String?

Environment

Release : All Supported Releases with Clarity

Resolution

• There are few things you can do to call the field and convert to String.
• We recommend using Java as described here:
  https://community.jaspersoft.com/questions/538454/how-convert-clob-varchar2
• Check out the attached file for an example how it will look into Studio.