Export to network location workflow action

[George_Tarasi]

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?

[Corinthia_Lill1]

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

[Larissa_Armand · Accepted solution]

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
;

[George_Tarasi]

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
;

[Roger_Linhart]

@Larissa Armand You seem to know your way around SQL and the OnBase Database. I used your example as the source for the following. I couldn't figure out how to make DefaulDirectory and DefaultFileName their own columns. If this is easy and you wouldn't mind showing me how you'd do it I'd appreciate it. I can work with it as so don't go out of your way.

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
*/