Xfor Each command

Official Content
This documentation is valid for:

Scans records of an external file using a given index.


Xfor each <file_name> [Index <index_name>]
        [Where <condition1>]
        [Where <conditionN>]
        [option distinct]
        [When none]

View Syntax conventions


     Is the name of the Data View defined to access the external file.

     Defines the name of the index to be used.

     Is the name of the Data View Index.

     Clause that can be specified to establish a condition for data retrieval.

     Any valid logical expression.

option distinct
     Only returns records where the set of values of the attributes referred to is unique.

when none
     Specifies the code to be executed when the Xfor each does not filter any record.


Objects: Procedure, Web Panel


This command defines an iterative loop for an external file, using the specified index (if any) and filters data according to the Conditions declared in the Where statements.

When a Data View object without an associated table is defined, this command will obtain the required information to perform updates over an external file. If the Data View has an associated table, the For Each command may be used instead of the Xfor Each command.

GeneXus will try to optimize the search in an intelligent way, taking into account the index specified in the Xfor Each statement and the conditions defined in the Where of the Xfor Each group. Xfor Each groups can be combined by nesting them or by defining them as parallel groups.

The differences between the For Each and the Xfor Each commands are:

For Each Xfor Each
Several tables may be associated with the Group. Only one table can be referenced.
The base table is inferred by GeneXus. The base table must be declared by the user.
The index is inferred by GeneXus according to the specified order. The index must be declared by the user.
Relationships between nested For Each groups are done by GeneXus No relationship is detected between nested Xfor each groups.

 See Also

For Each command
Xfor First Command
Data View object