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.