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

how to add notes for the automated scripts which process multiple requests

SOLVED
Go to solution
Highlighted
Satish_Ganga
Super Collector

how to add notes for the automated scripts which process multiple requests

Hello  All,

 

Can you please let me know how to add notes for the automated scripts which  process multiple requests???

 

thanks in advance.

 

Thanks,

Satish

 

4 REPLIES
Satish_Ganga
Super Collector

Re: how to add notes for the automated scripts which process multiple requests

Insert by using table knta_note_entries

Utkarsh_Mishra
Honored Contributor
Solution

Re: how to add notes for the automated scripts which process multiple requests

Refer this, you'll get the SQL

http://h30499.www3.hp.com/t5/Project-and-Portfolio-Management/HELP-URGENT/m-p/5855993/highlight/true#M19467
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Satish_Ganga
Super Collector

Re: how to add notes for the automated scripts which process multiple requests

Thanks

 

Satish_Ganga
Super Collector

Re: how to add notes for the automated scripts which process multiple requests

INSERT INTO knta_main.KNTA_NOTE_ENTRIES(
note_entry_id,
parent_entity_primary_key,
note,
last_update_date,
last_updated_by,
creation_date,
created_by,
parent_entity_id,
author_id,
authored_date,
note_context_value,
note_context_visible_value)
select knta_main.KNTA_NOTE_ENTRIES_S.nextval,request_id
,'Put your Notes here',
sysdate - (1/(24 *60*60)),
1,
sysdate - (1/(24 *60 *60)),
1,
20, --parent_entity_id for Request is 20
1,
sysdate - (1/(24 *60 *60)),30242,
'Request Status Value here'
from kcrt_requests  
where
request_id in (Request IDs separated by commas);

//Add this to "OnDomLoad" event