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: 

Question on table "knta_documents" and historical attachments

Highlighted
cut2kill
Occasional Advisor

Question on table "knta_documents" and historical attachments

hi everybody,

i'm trying to realize some sort of "version history portlet" for all "Business Case Doc" and "Requirements Doc" documents (see "Business Case Details" section for all request types) that can be attached to a request!

my problem:

is there a way to get to all of the historical data for document-attachments, through table "knta_documents" for a particular request? the data itself remains in "knta_documents" after a document is changed (delete old doc., attach new one) for example, but the link/relation to the "parent" request exists only for the currently attached document only (see table field "PARENT_PRIMARY_KEY")!

unfortunately also no entries in "knta_references" are made in this case!

do you guys have an idea for a possible approach to this solution?

by now we don't want to use the documentum integration!

kind regards,
nenad
1 REPLY
Sascha Mohr
Esteemed Contributor

Re: Question on table "knta_documents" and historical attachments

Hi Nenad,
if you activated transaction history for the attachment field in your request, you will have some tracebility in the table kcrt_transactions like for other fields. knta_documents does contain infos on the files (like type, size) and even for previously attached files, if you don't have cleanup enabled in your server.conf; lines like these:
com.kintana.core.server.ENABLE_DOCUMENT_CLEANUP_SERVICE=true
com.kintana.core.server.DOCUMENT_CLEANUP_SERVICE_DELAY=1440
If you need more functionality, you could add the documentum DMS available for PPM without separate licensing.
regards
Sascha
//Add this to "OnDomLoad" event