Lotus Notes/Domino Connector

Lotus Notes/Domino Connector



Lotus Origin

Sample Origin Filters

Important Note

Connect Creatio generates the query sent to Lotus as: (Form = '*Table Selected*' AND *Criteria*). If you select Accounts as the table and your Criteria is: CompanyName='Abbott' | CompanyName='Hogan' the final query would look like: (Form = 'Accounts' AND CompanyName='Abbott' | CompanyName='Hogan'). This will not work correctly because you have a & b | c. You need a & (b | c). So in some cases, you must put parenthesis around your Criteria so the final result would be: (Form = 'Accounts' AND (CompanyName='Abbott' | CompanyName='Hogan')).

Basic Queries

Field Equals Value:

CompanyName='Abbott, Ltd.'

Field Does NOT Equal Value:

CompanyName!='Abbott, Ltd.'

Lotus Origin using AND:

CompanyName='Abbott, Ltd.' & IENCLIENTSTATUS='Vendor'

Lotus Origin using OR:

CompanyName='Abbott, Ltd.' | CompanyName='Hogan Industries'

Lotus Origin using parenthesis ():

CompanyName='Abbott, Ltd.' | (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')

Full-text Queries

Full text Queries allow for much more complex queries such as Contains. See: http://publib.boulder.ibm.com/infocenter/lqkrhelp/v8r0/index.jsp?topic=/com.ibm.lotus.quickr.admin.dom.doc/dev/qp_dev_api_fulltext_r.html.

Connect Creatio will automatically detect if you use a question mark, ?, or an asterisk, *, in your Origin query. If you use one of those characters, Full-text querying will be enabled. Note the square brackets, [], around field names and the use of double quotes around values. Parenthesis and &/| use is still the same.

In this query, we are looking for the values anywhere in the field.

([CompanyName]="*Abbot*" | [CompanyName]="*Hogan*") & [CATEGORIES]="*Customer*"

Parameter
Description
Connection String

Lotus Domino Connection Edit Screen

    • Related Articles

    • Hubspot Connector

      Additional Documentation This Connector is based on the Hubspot ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/DHG/ado/ Hubspot Connector Note: As of September 8, 2020 ...

    • File System Connector

      File System Origin The File System Connector reads all files from a folder specified in the Directory field. The Username and Password fields are not used. Filter can be used to filter for certain file names/extensions. To search for all files with ...

    • SugarCRM REST Connector

      SugarCRM REST Origin Use JSONLint to validate JSON: https://jsonlint.com/. Sample Origin Filters See the GET /<module> filterList in the SugarCRM REST Help: https://SERVER/rest/v10/help/ Note the [{...}] surrounding the filter. This is required. ...

    • Act! Connector

      ACT! Premium Cloud: StarfishETL supports two-way integration. ACT! On-Prem: StarfishETL does not have a native Act! connector for versions less than Act v18 so we read directly from the database. Configuration Options Connect Act Premium (v18+) using ...

    • Sharepoint Connector

      Additional Documentation This Connector is based on the Sharepoint ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RSG/ado/ If connecting to Sharepoint using Single ...