Select the maximum variation including deleted records and archived records

The highest variation of a record is returned, even if the highest variation record status is deleted or archived.

An Infor table function can be used to select the maximum variation including deleted and archived records.

This table shows the results when selecting the maximum variation of each record and including records in which the maximum variation is deleted or archived:

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

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

The results include highest variation of each record, regardless of the deleted status or archived status. The results include variation 2 of the record for company 001, productID 991041, variation 2 of the record for company 002, productID 222333