with

with

Access verbs Index Level within
Syntax with {not} {each} attr.name {operator} {"value"}  
Category Access
Type Modifier
Description marks the beginning of a selection processor conditional, which is processed against the associated file to select items to pass on to the LIST processor.

The "not" (or "no") modifier negates the normal effect of selection -- only those item that do NOT meet the criteria are selected.

"value" is a specific value to match, enclosed in double quotes (") or backslashes (\). If a selection criterion does not include a value, all items that have at least one value for the specified attribute name are selected.

"every" (or "each") specifies that in a multi-valued attribute, every value for the attribute must meet the specified condition.

"attr.name" is the name of an attribute as specified by the attribute-defining item in the dictionary.

"operator" is any legal relational operator, such as "=".
Options
See Also quotes if logical connectives each seqlist list processor sellist without modifiers list processor attr.name not selection criteria any
Example list entity with contact

list entity with no contact and with phone

list invoices if amount.due > "100"

list entity if no phone.number

list entity with no contact and no phone.number

list orders if every quantity.ordered > "10"
Warnings When using the "with" clause, the functionality for mask and date conversions is a bit obscure. If a mask or date conversion exists in the output-conversion, that conversion is applied to the selection criteria in the Access statement. For instance, in the sentence "select filename with attr "90]", where the data contains such values as 9000, 9010, 9020, etc., the "90]" gets converted by an MR2 to "9000]". The logic is to convert the selection criteria once, rather than to convert each value that is processed by the SELECT.  Moving the MR2 to the correlative attribute bypasses the conversion to the selection criteria.
Compatibility D3 7.0 AP R83
Access verbs Index Level within