Lotus: Difference between revisions

From Starfish ETL
Jump to navigation Jump to search
No edit summary
Line 15: Line 15:
Lotus Origin using parenthesis ():
Lotus Origin using parenthesis ():
<syntaxhighlight lang="c">
<syntaxhighlight lang="c">
CompanyName='Technology Advisors, Inc.' | (CompanyName='OraSure Technologies, Inc.' & OfficeStreet = '150 Webster Street')
CompanyName='Abbott, Ltd.' | (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')
</syntaxhighlight>
</syntaxhighlight>

Revision as of 04:37, 21 October 2014

Lotus Origin

Sample Origin Filters

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