AX2239

How the multipass list of items is determined

When you use multipass processing, the file is processed multiple times, using a different item for each pass. This topic explains how the multipass list of items is generated based on the multipass settings.

Behind the scenes, a system-controlled Axiom query is used to generate the multipass list of items. When you click Preview Multipass List, you are viewing the rows returned by this Axiom query.

When using the multipass "basic mode" settings, you specify a single source column from a reference table, such as DEPT.DEPT. This setting creates an Axiom query as follows:

By default this data is sorted by the key column of the primary table, so no sort level is explicitly set. This basic setting would return the full list of departments in the DEPT table, and therefore the multipass process would result in one pass per department.

When using advanced mode, you can define more of the system-controlled Axiom query settings, to explicitly control how the multipass list is generated.

The multipass advanced mode settings correspond to Axiom query settings as follows:

Advanced Mode Multipass Setting	Corresponding Axiom Query Setting
Source Table	Primary Table
Source Columns	Entries in the Field Definition Row
Group By	Sum data by these columns Entries in the Field Definition Row
Sort By	Sort by database columns Entries in the Field Definition Row
Source Filter	Data Filter

You can adjust these settings as needed to result in the desired multipass list of items to process. Whatever results would be returned by an equivalent Axiom query will be returned by the multipass query. For example, if you want to process by department, and the source table is DEPT, then you will get one pass for each department defined in the DEPT table. On the other hand, if the source table is GL2019, then you will get one pass for each department that has data in the GL2019 table.