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