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