06-09-2015 02:37 PM
I would like to get the SQL that would be generated when you right click a document in Unity or thick client and click View Keywords. In other words, I need the SQL that will list the keywords and their values for a specified document.
Thank you,
David
06-09-2015 04:52 PM
Hi David,
First, thank you for using Community! I see that you've posted several questions about the OnBase schema recently and want to make sure that you have the best information available to answer your questions.
The majority of commonly used tables and columns for reporting - including information about how Keywords and their various configurations relate to documents - can be found in the Database Reporting Guide posted here on Community. I encourage you to read through the document and save it as reference any time you are needing to write a query to select data from the OnBase database.
An additional suggestion - especially if the information you are looking for is not in the guide or if some of the table relationships in the guide aren't clear to you - is to use either Verbose from the OnBase Client/Configuration or Diagnostics Console with the database tab enabled from the Core to see what queries the software is generating when you perform a specific task.
Although this particular question is fairly well documented in the aforementioned guide, a good example would be your question here. Enable verbose in the Client (through the Help > About menu) and then retreive a document's keyword panel. Open up the verbose log, scroll to the bottom and you'll see the query/queries that OnBase issued to populate the keyword panel.
The guide also contains some important information and recommendations on querying the OnBase database to protect against introducing performance issues when reporting - some specific to indexes and some to isolation levels. It's a fairly thorough read over the most common things people need to query for.
Hope that helps.
Ansley
06-09-2015 04:35 PM
06-09-2015 04:52 PM
Hi David,
First, thank you for using Community! I see that you've posted several questions about the OnBase schema recently and want to make sure that you have the best information available to answer your questions.
The majority of commonly used tables and columns for reporting - including information about how Keywords and their various configurations relate to documents - can be found in the Database Reporting Guide posted here on Community. I encourage you to read through the document and save it as reference any time you are needing to write a query to select data from the OnBase database.
An additional suggestion - especially if the information you are looking for is not in the guide or if some of the table relationships in the guide aren't clear to you - is to use either Verbose from the OnBase Client/Configuration or Diagnostics Console with the database tab enabled from the Core to see what queries the software is generating when you perform a specific task.
Although this particular question is fairly well documented in the aforementioned guide, a good example would be your question here. Enable verbose in the Client (through the Help > About menu) and then retreive a document's keyword panel. Open up the verbose log, scroll to the bottom and you'll see the query/queries that OnBase issued to populate the keyword panel.
The guide also contains some important information and recommendations on querying the OnBase database to protect against introducing performance issues when reporting - some specific to indexes and some to isolation levels. It's a fairly thorough read over the most common things people need to query for.
Hope that helps.
Ansley
06-10-2015 07:50 AM
Ansley, this is awesome! I turned on verbose and it provided exactly what I was looking for.
Thakn you!
David
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.