Select all variations of archived records

This logic returns the all variations of archived records. If the latest variation of a record is archived, that record, along with all the lower variations of the record, are returned.

An Infor table function can be used to select the all variations of archived records.

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

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

All variations of archived records are returned in query results.

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