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...") |
Jkuehlthau (talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
==Connection String== | ==Connection String== | ||
This example will let you read from Lee Hogan's database: SOLN01/TAI;Mail\lhogan.nsf | 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== | ==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: | 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: | ||
| Line 16: | Line 19: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
''''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/ | ''''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 | ||
Latest revision as of 20:33, 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
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