Using a SQL Select String - System Administration - Cloud - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

Cloud System Administration
Platform
OnBase
Product
System Administration - Cloud
Release
Foundation 23.1
License
Standard
Essential
Premier

You can use a SQL Select String query to communicate with the external database and identify the Keyword Values that display when users select the Keyword Type's drop-down list.

To create a SQL statement to enable External Keyword Data Sets:

  1. From the External Keyword Data Set Configuration dialog box, select SQL Select String.
  2. Type the contents of the SQL String in the available field. Required parameters include the following:

    • The SQL Select String must provide the following filtering command:

      LIKE ‘_filter_%'

      At runtime, OnBase populates the _filter_ string with characters the user types into the Keyword Type field, reducing the number of values that display in the Keyword Type's drop-down list.

    • The SQL Select String must programmatically provide a way to return all Keyword Values required by the External Keyword Data Set in the desired sort order from external database.

    Note:

    The maximum varchar character limit for Keyword Values in OnBase is 250 characters. This limit also applies to Keyword Values retrieved by External Keyword Data Sets.

See the following Example of a SQL Select String Used to Enable External Keyword Data Sets