Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieving most recent note

SOLVED
Go to solution
Highlighted
Dale Colliver
Regular Collector

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
Regular Collector

Re: Retrieving most recent note

Dale,

 

Try the KNTA_LATEST_NOTES_V View.

 

Good Luck

Greatppm
Acclaimed Contributor

Re: Retrieving most recent note

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

Utkarsh_Mishra
Honored 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
Regular Collector
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. 
 
 
//Add this to "OnDomLoad" event