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
05-01-2014 12:25 PM
Jose,
I don't know that there's a table that actually stores the description, but you can get this information from the OnBase Database Reporting Guide:
https://www.onbase.com/community/onbase_product_communities/m/technicalinformation/10361.aspx
The itemdata section will cover the various status values and all of the scanning/transactionlog actions are documented in the appendices.
I hope this helps.
Nick McElheny | Trover Solutions, Inc.
Lead Systems Engineer - Document Imaging
05-14-2014 04:37 PM
Thanks Nick. Yes, I'm aware of the section your refer to in the MRG, but what I was hoping is a table I can link to in a sql statement that will have those descriptions without me having to write 'if... then' or Case statements to "translate" the numeric code into a text description for the customer when they need an ad-hoc sql query.
05-14-2014 04:44 PM
Hi Jose,
The enumerations for the status columns of his.itemdata are not stored in a table in the database. There are three possible values/meanings:
Hope that helps.
Ansley
06-30-2014 02:59 PM
Thanks Ansley. What about for action or subactions codes like the ones found in the transaction log. Like in the Transactionxlog, 'Created a Note' is action 3, subaction 1.
Is that stored in the db somewhere?
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.