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: 

Reporting DB Notes Field

Highlighted
Katy Cabral
Regular Collector

Reporting DB Notes Field

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

Thanks!
4 REPLIES
Sascha Mohr
Esteemed 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
Regular Collector

Re: Reporting DB Notes Field

Thank you I'll try that out!
Katy Cabral
Regular Collector

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
Honored Contributor

Re: Reporting DB Notes Field

Hi Katy,

Try KNTA_FIELD_CHANGE_NOTES
//Add this to "OnDomLoad" event