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.