Lotus: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
Line 4: Line 4:
<syntaxhighlight lang="c">
<syntaxhighlight lang="c">
CompanyName='Abbott, Ltd.'
CompanyName='Abbott, Ltd.'
</syntaxhighlight>
Field Does NOT Equal Value:
<syntaxhighlight lang="c">
CompanyName!='Abbott, Ltd.'
</syntaxhighlight>
</syntaxhighlight>
Lotus Origin using AND:
Lotus Origin using AND:

Revision as of 05:03, 21 October 2014

Lotus Origin

Sample Origin Filters

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')