07-08-2024 05:18 AM
I have a document in the Workflow that was signed using stored signatures and it records the user, time & date the user signed the document in the Document History.
I would like to use Workflow to pull the user(s) that has signed the document to create a reminder notification for the user(s) who have not signed yet.
But I cant seem to find this info in the database.
Is this even possible to pull the User, Time & Date and Action?
Or is there another way to get this information?
OnBase 22.1
07-08-2024 06:44 AM
select tx.itemnum as 'DocHandle', tx.tmessage as 'Message', u.username as 'Username', tx.logdate as 'LogDate'
from transactionxlog tx
Join useraccount u on u.usernum = tx.usernum
where tx.actionnum = 5
and tx.subactionnum = 6
and tx.itemnum = 1654
I believe this will get you started - you should go into your Database and look into the Transactionxlog - you will be able to find the actionnum and subactionnum you are looking for - You can remove the itemnum if you are not looking for a specific Document
You will need to find the specific actionnum and subactionnum for the message that you are looking to define the query by
This will show you how the tables join
07-08-2024 06:44 AM
select tx.itemnum as 'DocHandle', tx.tmessage as 'Message', u.username as 'Username', tx.logdate as 'LogDate'
from transactionxlog tx
Join useraccount u on u.usernum = tx.usernum
where tx.actionnum = 5
and tx.subactionnum = 6
and tx.itemnum = 1654
I believe this will get you started - you should go into your Database and look into the Transactionxlog - you will be able to find the actionnum and subactionnum you are looking for - You can remove the itemnum if you are not looking for a specific Document
You will need to find the specific actionnum and subactionnum for the message that you are looking to define the query by
This will show you how the tables join
07-08-2024 07:54 AM
Thanks
I was close, I was in the transactionlog table, I was missing the x.
This is the information I was looking for.
Thanks again
07-08-2024 06:49 AM
Transactionxlog is a massive table, and hitting it without enough constraints could result in very long query times. Like Brent said above you can definitely query it with a single doc ID, but I wouldn't ever remove the doc ID. With your specific scenario you might be better off storing the data you want in a keyword, then use the keyword to populate the notification.
07-08-2024 07:56 AM
Thanks
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.