This hint is used to return the maximum, or highest, variations of a record from the Data Lake, regardless of the deletion indicator status.

For details and examples, see Variation handling.

The hint may be used to specify one or more data objects used in the query. Alternatively, you may use object aliases if the object is referenced more than once in a query.


--*includeDeletionsWithMaxVariations=<<data object or alias>>/<<data object  or alias>>

Add the hint before the first line of the query.

The syntax is --*includeDeletionsWithMaxVariation and is case-insensitive. Do not use spaces or other characters in a hint. After the = , specify one or more data objects or aliases used in the query. Separate each value with a forward slash /. A data object reference applies to all data object references in the query, regardless of aliases. An alias reference applies the hint logic to the specific data object alias references only. Any data objects or alias that are not referenced in a hint, by default, return the maximum variation of each record, excluding records in which the maximum variation is deleted.

You can use the infor.includedeleted() table function as an alternative to the includeDeletionsWithMaxVariations query hint.