Select all variations of each record

Select all variations of records, regardless of the deleted indicator status.

This logic is used to return historic and current records. It may be used for auditing purposes and viewing the results of incremental data loads. The logic is useful to find a specific variation of a record, such as the version of the record when the record was created or updated to a specific status.

There are two methods to select all variations of records for an object. You can use an Infor table function or a query hint.

The query results are the same if you use a variation handling hint or an Infor variation handling table function.

The results of selecting all variations of an object return all variations of records, including the highest variation, lower variations, and records marked as deleted.

Selecting all variations returns the results as shown in this table.

Company IdentifierPath	ProductID IdentifierPath	Description	Price	Variation VariationPath	DeletedFlag DeleteIndicator
001	991041	Bike	300	1	false
001	991041	Bike	350	2	true
002	222333	Scooter	129	1	false
002	222333	Scooter	132	2	false
003	12345	Skateboard	175	1	false
003	12345	Skateboard	195	2	true
003	12345	Skateboard	205	3	false

The results include all variations of all records, regardless of status.