Lotus: Difference between revisions

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

Revision as of 04:36, 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='Technology Advisors, Inc.' | (CompanyName='OraSure Technologies, Inc.' & OfficeStreet = '150 Webster Street')