Project and Portfolio Management Practitioners Forum
cancel

Retrieving most recent note

SOLVED
Go to solution
Highlighted
Dale Colliver
Super Contributor.

Retrieving most recent note

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.

4 REPLIES
kintanadan
Super Contributor.

Re: Retrieving most recent note

Dale,

 

Try the KNTA_LATEST_NOTES_V View.

 

Good Luck

Greatppm
New Member.

Re: Retrieving most recent note

Hi, Please check the datatype of notes column in the portlet data source.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Retrieving most recent note

Hi Dale,

 

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

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Dale Colliver
Super Contributor.
Solution

Re: Retrieving most recent note

Kintanadan, thank you. that simplifies getting the latest note. I had that part working but I was not aware of this view and it is much easier.