Project and Portfolio Management Practitioners Forum
cancel

Reporting DB Notes Field

Highlighted
Katy Cabral
Respected Contributor.

Reporting DB Notes Field

Does anyone know how to pull the notes for a request number into a query?

Thanks!
4 REPLIES
Sascha Mohr
Acclaimed Contributor.

Re: Reporting DB Notes Field

SELECT note, CREATION_DATE
FROM knta_note_entries
WHERE PARENT_ENTITY_PRIMARY_KEY =
AND PARENT_ENTITY_ID = 20
ORDER BY CREATION_DATE DESC;

hth
Katy Cabral
Respected Contributor.

Re: Reporting DB Notes Field

Thank you I'll try that out!
Katy Cabral
Respected Contributor.

Re: Reporting DB Notes Field

sorry- one more question. what about system generated notes such as when fields that write to notes are updated?

Thanks!
Erik Cole
Acclaimed Contributor.

Re: Reporting DB Notes Field

Hi Katy,

Try KNTA_FIELD_CHANGE_NOTES