SQL Select String Considerations - AutoFill Keyword Sets - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Essential - Premier - Standard - external - Standard - Premier - Essential

AutoFill Keyword Sets

Platform
OnBase
Product
AutoFill Keyword Sets
Release
Foundation 23.1
License
Standard
Premier
Essential
CAUTION:

SQL Select String functionality is being maintained for backwards compatibility, but it is no longer recommended and may be removed in a future release. Consider adopting Unity Scripts instead.

CAUTION:

Misconfiguration of SQL Select Strings may risk data exposure or loss of data integrity.

In all cases where SQL Select Strings are used until port to Unity Scripts is possible, the following considerations are strongly recommended:

  • A read-only user account with the most restrictive privileges must be used for access to an external database.

  • SQL Views should be created in the external database, if supported. SQL Select Strings should be executable against these SQL Views only.