Lotus - Revision history

Jkuehlthau: /* Basic Queries */

2024-05-31T21:42:40Z

Basic Queries

← Older revision		Revision as of 21:42, 31 May 2024
Line 25:		Line 25:
	CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')		CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')
	</syntaxhighlight>		</syntaxhighlight>
			Lotus Origin using a date:
			<syntaxhighlight lang="c">
			PostedDate >= [5-30-2024]
			</syntaxhighlight>

	===Full-text Queries===		===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.		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.

Jkuehlthau: /* Important Note */

2014-10-24T19:59:22Z

Important Note

← Older revision		Revision as of 19:59, 24 October 2014
Line 2:		Line 2:
	==Sample Origin Filters==		==Sample Origin Filters==
	===Important Note===		===Important Note===
	Starfish ETL generates the query sent to Lotus as: (Form = 'Table Selected' AND Criteria). If 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')).		Starfish ETL 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===		===Basic Queries===

Jkuehlthau: /* Sample Origin Filters */

2014-10-24T19:58:44Z

Sample Origin Filters

← Older revision		Revision as of 19:58, 24 October 2014
Line 1:		Line 1:
	=Lotus Origin=		=Lotus Origin=
	==Sample Origin Filters==		==Sample Origin Filters==
			===Important Note===
			Starfish ETL generates the query sent to Lotus as: (Form = 'Table Selected' AND Criteria). If 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===		===Basic Queries===
	Field Equals Value:		Field Equals Value:

Jkuehlthau: /* Full-text Queries */

2014-10-21T20:09:58Z

Full-text Queries

← Older revision		Revision as of 20:09, 21 October 2014
Line 25:		Line 25:
	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.		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.

	Starfish 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.		Starfish 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.		In this query, we are looking for the values anywhere in the field.

Jkuehlthau: /* Lotus Origin */

2014-10-21T20:09:24Z

Lotus Origin

← Older revision		Revision as of 20:09, 21 October 2014
Line 1:		Line 1:
	=Lotus Origin=		=Lotus Origin=
	==Sample Origin Filters==		==Sample Origin Filters==
	==Basic Queries==		===Basic Queries===
	Field Equals Value:		Field Equals Value:
	<syntaxhighlight lang="c">		<syntaxhighlight lang="c">
Line 22:		Line 22:
	CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')		CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')
	</syntaxhighlight>		</syntaxhighlight>
	==Full-text Queries==		===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.		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.

Jkuehlthau: /* Full-text query */

2014-10-21T20:09:06Z

Full-text query

← Older revision		Revision as of 20:09, 21 October 2014
Line 22:		Line 22:
	CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')		CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')
	</syntaxhighlight>		</syntaxhighlight>
	==Full-text ~~query~~==		==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.		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.

Jkuehlthau: /* Sample Origin Filters */

2014-10-21T20:08:55Z

Sample Origin Filters

← Older revision		Revision as of 20:08, 21 October 2014
Line 1:		Line 1:
	=Lotus Origin=		=Lotus Origin=
	==Sample Origin Filters==		==Sample Origin Filters==
			==Basic Queries==
	Field Equals Value:		Field Equals Value:
	<syntaxhighlight lang="c">		<syntaxhighlight lang="c">
Line 20:		Line 21:
	<syntaxhighlight lang="c">		<syntaxhighlight lang="c">
	CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')		CompanyName='Abbott, Ltd.' \| (CompanyName='Hogan Industries' & OfficeStreet = '150 Webster Street')
			</syntaxhighlight>
			==Full-text query==
			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.

			Starfish 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.

			In this query, we are looking for the values anywhere in the field.
			<syntaxhighlight lang="c">
			([CompanyName]="Abbot" \| [CompanyName]="Hogan") & [CATEGORIES]="Customer"
	</syntaxhighlight>		</syntaxhighlight>

Jkuehlthau: /* Sample Origin Filters */

2014-10-21T05:03:55Z

Sample Origin Filters

← Older revision		Revision as of 05:03, 21 October 2014
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:

Jkuehlthau: /* Sample Origin Filters */

2014-10-21T04:37:18Z

Sample Origin Filters

← Older revision		Revision as of 04:37, 21 October 2014
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>

Jkuehlthau at 04:36, 21 October 2014

2014-10-21T04:36:07Z

← Older revision		Revision as of 04:36, 21 October 2014
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>