access.relational.operators

Relational Operator/Access: Verbs, Releases: AP and R83

Relational operators used in selection clauses.

Syntax

with {not} attr.name operator 'valuestring'

Description

used in the selection criteria process.

Each operator (sometimes called 'logical') has an 'English' equivalent which may be used interchangeably with the 'symbol' form. When no operator is present, the default is an 'equal to' (=).

Symbol Meaning

= or eq Equal to
#, ne,no or not Not equal to
> or gt or after Greater than
< or lt or before Less than
>= or ge Greater than or equal to
<= or le Less than or equal to

Example

list entity with state eq 'ca'

list entity with amount.due not '0'

list entity with birthday before '1/2/62'

list entity with age gt '21'

list entity with no zip

list invoices with every amount > '0'

See Also

Command Name Type Description
access.not Modifier Negates selection criteria.
access.modifiers.modlist Definition Defines list of modifiers.
access.attr.name Attribute Defining Item Specifies item(s) from the dictionary of the file.
access.le Modifier 'less than or equal to' operator.
access.each Modifier Forces comparison on every value.
access.before Modifier 'less than' operator.
access.after Modifier 'greater than' operator.
access.ge Modifier 'greater than or equal to' operator.
access.and Modifier 'and' (Boolean) operator.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.