Wheremembers

Owned by Former user (Deleted)
Last updated: Oct 10, 2016 by Former user (Deleted)
1 min read

Wheremembers are the members that are used in a wheregroup.

Attributes

NameDescriptionValue
lparenthIndicates if a left parenthesis will be used in the where clause.0, 1
lfieldThe name of the left field.Any fieldname or constant
expressionThe comparison operator.=, <, >, <=, >=, <>
rfieldThe name of the right field.Any fieldname or constant
rparenthIndicates if a right parenthesis will be used in the where clause.0, 1
andor Defines how the current condition is connected with the next condition, if it exists.

AND or OR

Example

 Wheremembers
Wheremembers
<wheremembers>
	<wheremember>
		<lparenth>0</lparenth>
		<lfield>ACCOUNTSRECEIVABLE.ACCRECDELETED</lfield>
		<expression>=</expression>
		<rfield>0</rfield>
		<rparenth>0</rparenth>
		<andor>AND</andor>
	</wheremember>
	<wheremember>
		<lparenth>0</lparenth>
		<lfield>ACCOUNTSRECEIVABLE.LIFECYCLESTATE</lfield>
		<expression>&lt;&gt;</expression>
		<rfield>'TERMINATED'</rfield>
		<rparenth>0</rparenth>
		<andor>AND</andor>
	</wheremember>
</wheremembers>