infor.allvariations() table function

The infor.allvariations() table function is used in the from clause of a query. The function parameter is the object for which to select all variations, including lower variations and variations marked as deleted. Archived records and their variations are not returned by this function.

The infor.allvariations() table function requires a parameter. The parameter is the object name, and the object name must be enclosed within single quotes. The infor.allvariations function and the object name are case-insensitive.

Query

select * from infor.allvariations('Products')