Archive options

By default, archived data is not retrieved for general SELECT statements. You can query for archived data stored in Data Lake with these archive options:

• Include Archived Records:

  infor.ShowArchived()

  Retrieve a result set exclusive to archive records reflecting the maximum variation of a given identifier.

• Return All Variations Of Archived Records:

  infor.ShowAllArchived()

  Retrieve a result set exclusive to archived records that reflects all variations of a given identifier.

• Include Both Archived & Deleted Records:

  infor.IncludeArchivedAndDeleted()

  Retrieve a result set where the maximum variation of an identifier may reflect an active, archived, or deleted record.

• Return All Variations Including Archived Records:

  infor.AllVariationsIncludeArchived()

  Retrieve a result set of all variations of an identifier including archived and deleted records.

For more information on querying archived data, see Variation handling.