Does anyone know how to write a SQL to update to the package notes tab?
I would like to run a script that can add a comment to the Notes tab (ie, package notes section). From JDBC debug it looks like its inserting to KNTA_NOTE_ENTRIES. Has anyone done this from object type / commands?
Re: Does anyone know how to write a SQL to update to the package notes tab?
The key here is to know the entity type where you want to add the note.
So here is the list of entities in PPM:
select * from knta_entities order by entity_id
-- For Packages entity id is 1
select * from knta_entities where entity_id=1
So, you can check in the KNTA_NOTE_ENTRIES records for packages using this query:
select * from KNTA_NOTE_ENTRIES where parent_entity_id=1 --and parent_entity_primary_key=<id of a specific package>
So, you can use the SQL Jim provide above and change the parent_entity_id to 1 and parent_entity_primary_key to the id of the package you want to add the note.
PD: Updates from the backend are not supported, so test any change in your TEST instance first. Also, you can add notes in workbench. Just open the package, click in the Notes tab and add the note you need.
Hope this helps!
(Remember to mark the topic as solved and provide kudos if a post answered your query)