HCL Domino

Overview

The HCL Domino Connector is a custom written connector.

Origin

Connection String

This example will let you read from Lee Hogan's database: SOLN01/TAI;Mail\lhogan.nsf

Please note that if you change from Mail\lhogan.nsf to Mail\orders.nsf the Origin tab's Test Connection and Execute Query buttons will NOT respect this change. Do not get confused if you are looking for records in Notes.

Table

If you click the dropdown, you will see many "tables" available in the database you have selected. I have never used any of these tables. You can override the Table dropdown and write your own query by starting the table field with an exclamation point, !. For example, if I wanted to see all records where the Form is Memo or Reply, I would put this in the Table dropdown field:

!((Form = "Memo") | (Form = "Reply" ))

You can then get more creative by adding more fields and operators:

!((Form = "Memo") | (Form = "Reply" )) & Classification != 'starfish' & PostedDate > [6-4-2024 7:00:00 PM] & Subject = 'Looking for payment status - MPL invoice 68372'

'Note that the ! at the beginning is not saying "not", it is telling Starfish that we are passing it a custom query.' You can see more about the Domino Query Language here: https://help.hcltechsw.com/notes/9.0.1/sch_refine_query_r.html