Task note - where is the text stored?

vnava

Does anyone know which database table stores the text entered in the note field of a task?

I learned that a task is a record in the doc_document table but I didn't see the note information stored there.

To find my specific task I executed the following query:

select * from worksitemp.doc_document where p_name=''

The query result had the metadata for my specific task but not the notes field.

Thanks in advance.

dbguy

To accommodate (nearly) unrestricted length notes, they are stored as a singleton version of the task.

This will give you the path in the file server for the notes. Just add your condition at the end.

select FILE_SERVER_PATH from worksitemp.doc_document d inner join worksitemp.doc_version v on d.sid = v.document_rsid inner join worksitemp.doc_version_stream s on s.version_rsid = v.sid

A friendly reminder: never modify the DB directly.