05-01-2014 11:25 AM
Is there a table I can join to in the OnBase db that will give me the description for a status code like Itemdata's Status 0= Indexed or Status 16=deleted. I'm looking for what the number (value) of the status means. I looked in the MRG, and found descriptions, but can I get that directly from the db?
IS there such a table for action codes as well
07-01-2014 06:21 AM
Hi Jose,
You can find this information in the Database Report Guide (see above link from Nick's post) under the Appendix A: Log Table Actions - TRANSACTIONXLOG.
Take care.
07-01-2014 08:38 AM
I apologize for not making my question clear, but what I am looking for is not an answer about the information in the DB Reporting MRG. My question was answered (by Ansley) regarding the status codes - not in the DB.
Are the descriptions for the actions and subactions (found in the MRG) stored in the db where I can do a join to them? I'm talking about the text strings that establish that in the txlogs, action 3 was "Created a Note"... or whatever. Is that text string description for the code in a table somewhere in the db?
Again, sorry if I wasn't clear, and thank you for the info about the MRG.
Is there an SCR to add these code and status text descriptions strings to a db table where they can queried and returned in a result set?
07-01-2014 08:42 AM
Hi Jose,
The enumerations for the hsi.transactionxlog table are not stored in the database but they can be found in the Database Reporting Guide for use in your queries.
The majority of enumerations in the schema and application work in this manner - i.e. there isn't a table in the database that stores them - with the exception of user created objects such as Document Types, Keyword Types, User Accounts, etc.
Hope that helps.
Ansley
05-08-2018 09:08 AM
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.