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 08:00 AM
Thank you
05-25-2021 01:21 PM
Roger, try a case statement up in the select statement to add those as their own columns.
e.g. case
when <whatever condition evaluates to true> then <return this>
end as [whatever you want to name the column]
As for a workflow log that logs structure changes, I would be shocked. That is the equivalent of asking to see the structure changes in a log for the doc type. Not that these couldn't change, but I thought that currently all the logs, just log data changes, not structure changes. If this has changed, someone please point me in the right direction?
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.