The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Using notes field in Portlet

SOLVED
Go to solution
Highlighted
ramana.vkn
Collector

Using notes field in Portlet

Hi,

I want to use Notes field in portlet, I am using the following query to acheive this, but the notes filed is displaying "oracle.sql.CLOB@489ed9"

SELECT kpp.REQUEST_ID PROJECT_NUMBER, kpp.REQUEST_ID PROJECT_NUMBER_HYPERLINK, kpp.PROJECT_NAME PROJECT_NAME, kr.STATUS_NAME PROJECT_STATUS, kpp.PRJ_PROJECT_MANAGER_USERNAME PROJECT_MGR, kn.NOTE NOTE
FROM KCRT_FG_PFM_PROJECT, KCRT_REQUESTS_V kr, KNTA_NOTE_ENTRIES kn
WHERE kpp.REQUEST_ID= kr.REQUEST_ID
AND kpp.REQUEST_ID= kn.PARENT_ENTITY_PRIMARY_KEY

Am I missing any thing.
Can someone help me solving this issue please.
7 REPLIES
Mahen M
Honored Contributor

Re: Using notes field in Portlet

I hope you need to convert the CLOB to VarChar.

Regards,
Mahendran M
Mahen M
Honored Contributor
Solution

Re: Using notes field in Portlet

Sample Query

select DBMS_LOB.SUBSTR(Note, 85)
from KNTA_NOTE_ENTRIES
where note_entry_id =
(select max(note_entry_id)
from KNTA_NOTE_ENTRIES
where parent_entity_primary_key = rqst.request_id)

Regards,
Mahendran M
ramana.vkn
Collector

Re: Using notes field in Portlet

Hi Mahendran,

Thanks for your help, it worked.

I have one more issue, I created a portlet for customizing the project, using this project I am able to get the data, but when I click on Project Name, it is throwing error.

I have attached the logs, screen shot of the error, could you please help me solving this issue.
ramana.vkn
Collector

Re: Using notes field in Portlet

Adding the attachment
ramana.vkn
Collector

Re: Using notes field in Portlet

Thanks Mahendran
Mahen M
Honored Contributor

Re: Using notes field in Portlet

Sorry, Can you send the attachment to mahendran.m@rediffmail.com

I'm not able to open the attachment in my home.

Regards,
Mahendran M
ramana.vkn
Collector

Re: Using notes field in Portlet

Hi Mahendran,

Sent you the email.
//Add this to "OnDomLoad" event