Creating Database Queries - Document Composition - Foundation 24.1 - Foundation 24.1 - Ready - OnBase - external - OnBase/Document-Composition/Foundation-24.1/Document-Composition/Configuration/Placeholders/Creating-Placeholders/Configuring-Database-Query-Placeholders/Creating-Database-Queries - 2024-03-25

Document Composition
Platform
OnBase
Product
Document Composition
Release
Foundation 24.1
License

To create a database query before you configure a Database Query Placeholder:

  1. Click Control Panel.
  2. Select the Queries tab:
  3. Click New Query:
  4. The New Database Query dialog box is displayed:
  5. Enter the appropriate information in the fields provided. The fields are detailed in the following table.

    Option

    Description

    Name

    Assign a name for the query.

    Note:

    This field is limited to 40 characters when using a database that supports ANSI characters. When using a database that supports Unicode characters, this field is limited to 20 characters.

    Text Box

    Type the SQL Query that will pull information from the database you are connecting to.

    Click Insert Placeholder to select an existing placeholder to add to the SQL Query.

    Datasource

    Type the data source name.

    Note:

    This field is limited to 100 characters when using a database that supports ANSI characters. When using a database that supports Unicode characters, this field is limited to 50 characters.

    Username

    Type the user name that will be used to access the datasource.

    Note:

    This field is limited to 75 characters when using a database that supports ANSI characters. When using a database that supports Unicode characters, this field is limited to 37 characters.

    Password

    Type the password, if applicable, that corresponds to the user name you specified.

    Note:

    This field is limited to 200 characters when using a database that supports ANSI characters. When using a database that supports Unicode characters, this field is limited to 100 characters.
  6. Click OK.
  7. The query you created is displayed:

    • To edit a query, select the query and click Edit Query:

      Enter the appropriate information into the fields provided. To update the password that corresponds to the user name you specified, click Reset Password and enter the new password into the Password field.

      Note:

      This field is limited to 200 characters when using a database that supports ANSI characters. When using a database that supports Unicode characters, this field is limited to 100 characters.

    • To delete a query, select the query and click Delete Query:

    • To show configured queries as a list, right-click and select Show as List. To show configured queries as a tree view, right-click and select Show as Tree.