Can anyone advise how to include most recent note in a portlet. I have the SQL working and getting the Note_Entry_ID but instead of the note, I am getting the Oracle pointer to the CLOB.
Go to Solution.
Try the KNTA_LATEST_NOTES_V View.
Hi, Please check the datatype of notes column in the portlet data source.
Notes entry in PPM are stored as CLOB datatype, so you need to select them in different way i.e. you need to convert the CLOB into VARCHAR.
You can do this as:
select dbms_lob.substr( NOTE, 400, 1) from KNTA_NOTE_ENTRIES