Lotus Notes/Domino Connector

Lotus Notes/Domino Connector



Lotus Origin

Sample Origin Filters

Important Note

Creatio Connect 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.

Creatio Connect 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. ...

    • Gainsight Connector

      Gainsight's Customer Success Software empowers companies to increase revenue, decrease customer churn, and drive advocacy.  Gainsight is a cloud-based application and available for your migrations and integrations through the Creatio Connect Cloud ...

    • SugarCRM SOAP Connector

      SugarCRM SOAP Origin Note that the tab in Creatio Connect is labelled simply "SugarCRM". Sample Origin Filters Mapping Attachments In Sugar, Attachments are stored as Notes. To attach a file to a Note, simply run and Insert, Update or Update/Insert ...