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')