Writing Customized Custom Queries Within OnBase - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Database Reporting Guide
Foundation 23.1

A customized Custom Query provides the most control over the retrieval of documents within OnBase by allowing the user to code the actual SQL for a query. This option requires extensive knowledge of the system and must be configured correctly or the OnBase client will issue an ODBC error.

Note: Badly constructed Custom Queries can adversely affect system performance and may also result in data loss or data corruption. It is recommended that only a database administrator set up a customized query and only after first consulting OnBase technical support.