Accessing data from Existing Domino Applications

Data from existing Domino Databases, that are co-located with Volt, may be accessed by your Volt application. A Service Configuration is used to interact with an existing Domino Database. The operations are: List View Entries, Find View Entries, List View Categories, and Read a single Document.

List View Entries returns all the entries in the specified View.

Find View Entries returns all the entries where the value of the “Sort By” column equals the “Search Value”. This service is for filtering down the View entries to those that match a specific value.

The following apply for both List View Entries and Find View Entries:

  • The Views in the selected database will be populated into the “Select View” field. Choose the View.
  • If the View is sorted, then the “Select Column to sort by” and “Sort direction” will be available. You may choose to sort the results by a specific column.
    Note: If you want to map the sorted column dynamically to a field in your form, leave the “Select Column to sort by” empty. If you set the “Select Column to sort by” on the “1. Select Service” tab, then the “Sort By” parameter will not be available on the “2. Inputs” tab. If you set the “Sort Direction” on the “1. Select Service” tab, then the “Sort Direction” parameter will not be available on the “2. Inputs” tab.
  • The columns of the selected view will appear in a table. Each column will default to a datatype based on the corresponding field in the first document in the view. Ensure the datatype matches the actual datatype that is in the Domino application. For example, if it is a date only field in Domino then select “Date” as the data type when configuring the service.
    Note: This is an important step - Volt does not allow mixing datatypes. If you want to map a date column from the service to a date field in your form, you must set the data type to “Date”. Volt will not convert or transform the data being returned from the service.
  • The results of this service are paginated and the default page size is 50. You may change the page size, up to a maximum of 1000, by mapping a value to the “Page Size” input parameter. You may change the results page by mapping a value to the “Page” input parameter.

List View Categories returns all the categories in a View at the specified level.

  • If you call this service and leave the “Category Name” empty it will return the list of first-level categories.
  • If you call this service and map the “Category Name” to a category, it will return all the next-level categories. If you specify a sub-category the “Category Name” must be the full path to the sub-category. For example: “Education\Online” or “Education\Online\Programming\JavaScript”.
  • The results of this service are paginated - the default page is 1 - and the default page size is 50
  • The service returns the category name, count of immediate sub-categories, the parent category and the category path as output parameters.

Read a single Document returns the values of all the items in the specified document. The document is identified by providing the Universal ID (UNID).

  • The Forms in the selected database will be populated into the “Select Form” field. Choose the Form.
  • The fields in that form appear in a table. Each column will default to a datatype based on the form field in Domino. Change the datatype of each column to match the data you expect to return or how it is to be mapped within the form.
    Note: This is an important step - Volt does not allow mixing datataypes. If you want to map a date column from the service to a date field in your form, then you must set the data type to “Date”. Volt will not convert or transform the data being returned from the service.
  • You may add additional fields that may be in your document but not part of the selected form. Click + Add Field and enter the field name and datatype and click OK.
    Note: You may add any field from the document, including “$...” fields.
  • This service automatically includes the UNID, when the document was last updated, the Notes URL, and the document’s size as output parameters.