| selection criteria | Index Level | seqlist |
| Syntax | |
| Category | Access |
| Type | Definition |
| Description |
represents the set of selection criteria clauses that determine which items should be selected for processing by Access.
See the "with" modifier for additional information on selection criteria clauses. |
| Options | |
| See Also | select without t-dump selection processor sselect sortc sreformat sort t-load with s-dump sum nselect wildcards sort-label stat ld list-label count list-item list Access verbs collation order logical connectives or and |
| Example |
list entity with name "ar]" name
In this example, only those items whose "name" field begins with "ar" are selected. (See "selection criteria" for more information). list entity with name "mi]" and with phone "804]" This example shows two selection clauses connected with an "and", which means that both conditions must be evaluated as true for items to be selected for processing. list entity with name "re]" or with city "irv]" name city This example shows a mutually exclusive set of selection crtieria connected with an "or". Either condition evaluating to true accepts the item for processing, that is, if the "name" attribute begins with "ar", or the "city" attribute begins with "irv", the item is selected for output. list entity with name "ar]" and with city "irv]" or with city "san]" and with contact "[joe]" This example lists those items which meet one of two criteria: a name starting with "ar" and with a city starting with "irv", or, a city starting with "san" and a contact containing the string "joe". |
| Warnings | |
| Compatibility | D3 7.0 AP R83 |
| selection criteria | Index Level | seqlist |