Select the maximum variation of only archived records

This logic returns the maximum variation of archived records. If the latest variation of a record is archived, the record is included in the results.

An Infor table function can be used to select the maximum variation of archived records.

This table shows the results when selecting maximum variations of archived records::

Company IdentifierPath ProductID IdentifierPath Description Price Variation VariationPath DeletedFlag DeleteIndicator ArchivedFlag ArchiveIndicator
002 222333 Scooter 132 2 false true

Notice that lower record variations are excluded from the query results.

The results include variation 2 of the record for company 002, productID 222333