Example of a SQL Select String Used to Enable External Keyword Data Sets - System Administration - Cloud - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - Essential - Premier - Standard - external - Essential - Standard - Premier

Cloud System Administration

Platform
OnBase
Product
System Administration - Cloud
Release
Foundation 24.1
License
Essential
Standard
Premier
  • SELECT EmployeeID- calls the column in the external database that provides the Keyword Value.

  • FROM Employees- retrieves the name of the database table that stores the values retrieved by the Keyword Data Set.

  • WHERE EmployeeID LIKE ‘_filter_%'- provides filtering for returned values.

Note:

If you attempt to concatenate (combine) Keyword Values from multiple columns for a Keyword Type with the Keyword Type Must Exist option selected, the query does not return any results. For example, the Keyword Type Must Exist option is selected for the Employee ID Keyword Type. If the first line of your query is SELECT EmployeeID + EmployeeNumber, and the last line of your query is WHERE EmployeeID LIKE '_filter_%', the query is searching for a combined value from the EmployeeID and EmployeeNumber columns and attempting to match it with a value in the EmployeeID column. Because the resulting value does not exist in the EmployeeID column, no results can be returned.

  1. In the DSN field, type the name of the ODBC connection.
    Note:

    Every workstation that will be accessing External Keyword Data Sets (users who will be indexing or re-indexing) must have an ODBC connection that has the same name as the one configured in the Configuration module. In the case of Web Server, only the Web Server itself must have the ODBC connection, not the client workstations.

  2. In the User ID field, type the User ID for the ODBC connection.
  3. In the Password field, type the Password for the ODBC connection.