HCL Domino: Difference between revisions
Jkuehlthau (talk | contribs) (Created page with "=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 ==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 wa...") |
(No difference)
|
Revision as of 19:53, 25 July 2024
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
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/dom_designer/10.0.1/basic/dql_overview.html (I think this is the right URL. It may not be.)