08-22-2019 06:09 AM
There is an action type in workflow titled Export to Network Location
One of the fields under that action is Specify Network Location.
Is this field in the database?
08-22-2019 07:32 AM
Hi George,
Try this, I think it might be what you are looking for:
select A.ACTIONNUM, A.ACTIONNAME, L.LIFECYCLENAME,
rtrim(P.PROPERTYVALUE)
from ACTION A, ACTIONPROPS P, LIFECYCLE L
where A.ACTIONNUM = P.ACTIONNUM and A.SCOPE = L.LCNUM
and P.PROPERTYNAME = 'DefaultDirectory'
order by L.LIFECYCLENAME
;
08-22-2019 07:11 AM
Hi George!
No, the Specify Network Location field is not in the database. The Network Location is a UNC path where you want your documents and/or index file to be exported out of OnBase.
For example, we have a group of users that batch scan in Unity and nightly we produce an index file, with specific values from the documents committed that day, that is used by our EHR to link those documents in that system. We place the file on a network share that is picked up by our EHR and processed.
And from experience, make sure the account running your Application Server has rights to the UNC path you specify. If the account does not have rights, the documents and/or index file will not be exported.
Hope that helps! 🙂
Corinthia
08-22-2019 07:32 AM
Hi George,
Try this, I think it might be what you are looking for:
select A.ACTIONNUM, A.ACTIONNAME, L.LIFECYCLENAME,
rtrim(P.PROPERTYVALUE)
from ACTION A, ACTIONPROPS P, LIFECYCLE L
where A.ACTIONNUM = P.ACTIONNUM and A.SCOPE = L.LCNUM
and P.PROPERTYNAME = 'DefaultDirectory'
order by L.LIFECYCLENAME
;
08-22-2019 08:00 AM
Hi George,
Try this, I think it might be what you are looking for:
select A.ACTIONNUM, A.ACTIONNAME, L.LIFECYCLENAME,
rtrim(P.PROPERTYVALUE)
from ACTION A, ACTIONPROPS P, LIFECYCLE L
where A.ACTIONNUM = P.ACTIONNUM and A.SCOPE = L.LCNUM
and P.PROPERTYNAME = 'DefaultDirectory'
order by L.LIFECYCLENAME
;
05-24-2021 04:10 PM
One other thing, I noticed some of the Actions produced by this query no longer exist in the Life Cycle Queue, IE they were deleted. I couldn't find a flag or status that would indicate which Actions had been deleted. Do you know where it is?
/* WFActionExportToNetworkLocation.sql
*
* Roger D. Linhart 05/24/2021 OnBase EP3 20.3.5.1000 Microsoft SQL Server 2012
*
* Show Workflow Action 'Export to Network Location' properties in Life Cycles.
*
* To list all Life Cycles:
* --SET @myLifeCycleName = 'OIT';
*
* To list a specific UserGroup:
* SET @myLifeCycleName = 'OIT';
*
* IMPORTANT: Remember to select the target database instance.
*
*/
DECLARE @myLifeCycleName NVARCHAR(128) = '';
-- SET @myLifeCycleName = 'OIT';
SET @myLifeCycleName += '%';
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT
RTRIM(l.lifecyclename) AS [Life Cycle]
,RTRIM(q.statename) AS [Queue]
,RTRIM(a.actionname) AS [Action Name]
,RTRIM(p.propertyname) AS [Property Name]
,RTRIM(p.propertyvalue) AS [Property Value]
FROM
hsi.lifecycle AS l WITH (NOLOCK)
INNER JOIN hsi.lcstate AS q WITH (NOLOCK)
ON l.lcnum = q.scope
INNER JOIN hsi.action AS a WITH (NOLOCK)
ON a.scope = l.lcnum
INNER JOIN hsi.actionprops AS p WITH (NOLOCK)
ON a.actionnum = p.actionnum
WHERE
(l.lifecyclename LIKE @myLifeCycleName)
AND ((p.propertyname = 'DefaultDirectory') OR (p.propertyname = 'DefaultFileName'))
ORDER BY
[Life Cycle]
,[Queue]
/* How I figured out the propertyname for the Filename.
--select propertyname, propertyvalue from hsi.actionprops where propertyvalue = 'TA_STAGE.txt'
*/
/* Source from Larissa Armand @ Hyland Community.
select A.ACTIONNUM, A.ACTIONNAME, L.LIFECYCLENAME,
rtrim(P.PROPERTYVALUE)
from hsi.ACTION A, hsi.ACTIONPROPS P, hsi.LIFECYCLE L
where A.ACTIONNUM = P.ACTIONNUM and A.SCOPE = L.LCNUM
and P.PROPERTYNAME = 'DefaultDirectory'
order by L.LIFECYCLENAME
*/
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.