any Modifier

The any modifier searches an entire item for a match, all attributes and all values. Each value is compared to the selection criteria and if the value passes the criteria, then the item is selected for further processing. This feature is useful for searching nonattribute-oriented files for specific words or phrases, such as word processor documents, source programs, and so on.

The word any may be used to mean any attribute, value, or subvalue in the item. any may be used in selection criteria (with, if), or specified for output. If any is specified for output, it must also be specified in selection criteria. The output of the any attribute definition is any subvalue, value or attribute that passes the selection criteria.

Syntax

with {not} any {operator} {"value"}

if {not} any {operator} {"value"}

Example(s)

This selects all entity items that contain the name john doe.

select entity with any "[john doe]"

This indicates that any found two items that had an attribute, value, or subvalue that exactly matched the string sally. The output of the second any displays the attribute, value, or subvalue number on which the match was found as well as the actual data in that field.

list entity with any "sally" any

Page 1

entity

 

entity..................................

332

004

sally

1234

001

sally

See Also

Access Query Language, with Modifier