Navigation:


FORUMS > SentryFile Version 5 Topics > SF5 - API Integration / Programming Assistance < refresh >
Topic Title: IN PROGRESS Checking
Created On Fri March 14, 2014 3:42 PM
Topic View:

View thread in raw text format


hellason

Posts: 189
Joined: Mar 2006

Fri March 14, 2014 3:42 PM
User is offline

I would like to set up a SSIS package to check to see if there are documents in the "IN PROGRESS" container. What table in the SQL setup for Sentryfile should I check? I have version 5.19.
Thanks!
 
Reply
   
Quote
   
Top
   
Bottom
     



hellason

Posts: 189
Joined: Mar 2006

Tue March 25, 2014 2:59 PM
User is offline

Why have I not got a response to my question?
 
Reply
   
Quote
   
Top
   
Bottom
     



SupportRep

Posts: 6587
Joined: Feb 2004

Tue March 25, 2014 3:16 PM
User is offline

Oops! Sorry, we missed this one!

Two places you need to check:

1. The document_active = 0 records in all the Docucore_Repository_XXX tables
2. The DocuCore_JobValidation table for any processing documents

The query below might help. Replace "XXX" with the Repository_ID of the cabinet you're checking:

SELECT DocuCore_Repository_XXX.document_id, DocuCore_Repository_XXX.repository_id, DocuCore_Repositories.repository_name, DocuCore_Repository_XXX.document_createddt, DocuCore_Revisions.revision_originalfilename, DocuCore_Revisions.revision_storagefilename
FROM DocuCore_Repository_XXX
INNER JOIN DocuCore_Revisions ON DocuCore_Repository_XXX.document_id = DocuCore_Revisions.document_id AND DocuCore_Repository_XXX.repository_id = DocuCore_Revisions.repository_id
INNER JOIN DocuCore_Repositories ON DocuCore_Repository_XXX.repository_id = DocuCore_Repositories.repository_id
WHERE (DocuCore_Repository_XXX.document_active = 0) AND (DocuCore_Repository_XXX.document_id NOT IN (SELECT DocuCore_JobValidation.document_id as document_id FROM DocuCore_JobValidation WHERE (DocuCore_JobValidation.repository_id = 0) AND (DocuCore_JobValidation.jobvalidation_validated = 'PROCESSING' or DocuCore_JobValidation.jobvalidation_validated = 'FALSE'))) ORDER BY DocuCore_Repository_XXX.document_createddt

Let us know if this helps!

Cheers,

-------------------------
-SentryFile Support
 
Reply
   
Quote
   
Top
   
Bottom
     



SupportRep

Posts: 6587
Joined: Feb 2004

Tue March 25, 2014 3:17 PM
User is offline

BTW: I threw the query above together pretty quickly. Be sure to test it out to make sure it is working correctly!

-------------------------
-SentryFile Support
 
Reply
   
Quote
   
Top
   
Bottom
     



hellason

Posts: 189
Joined: Mar 2006

Mon March 31, 2014 2:18 PM
User is offline

Works!! Thanks for your help!
 
Reply
   
Quote
   
Top
   
Bottom
     

View thread in raw text format
FORUMS > SentryFile Version 5 Topics > SF5 - API Integration / Programming Assistance < refresh >

Navigation:

FuseTalk 4.0 © 1999-2003 FuseTalk Inc.