Skip to main content
Skip table of contents

AO Max ID

Overview

AO Max ID accepts a single stream with a numeric ID field as input. It scans that field to find the maximum ID value and appends the maximum value to all records for use in AO Constant Key and AO Constant Key Advanced.

Note that this macro requires the processing and temporary storage of every record in the stream. If you have records in a database, it is better to query the database for the maximum ID using an SQL statement like SELECT COALESCE(MAX(ID),0).

AO Max ID configuration parameters

AO Max ID has a single set of configuration parameters:

Input

Parameter

Definition

ID

Required. The ID field to scan. Default: Blank

Output

Parameter

Definition

Maximum ID

Required. The field to receive the computed maximum ID value. Default: MAX_ID

Configure AO Max ID

To configure AO Max ID:

  1. Select the AO Max ID icon, and then go to the Configuration tab on the Properties pane.

  2. Select ID and select the field containing the numeric ID field.

  3. Optionally, select Maximum ID and edit the field name for the output ID.

  4. Optionally, go to the Execution tab, and then set Web service options.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.