infor.includearchivedanddeleted() table function
The
infor.includearchivedanddeleted() table function is used in the from clause
of a query. The function parameter is the object for which to select the maximum variation,
even if the highest variation is deleted or archived.The infor.includearchivedanddeleted() table function requires a parameter.
The parameter is the object name, and the object name must be enclosed within single quotes.
The infor.includearchivedanddeleted function and the object name are
case-insensitive.
Query
select * from infor.includearchivedanddeleted ('Products')