Master variation handling table function

This table function can be used as a Compass query. It returns the ‘Highest’ OR ‘All Variations’ of any combination of ACTIVE, DELETED or ARCHIVED records. This can be used instead of the individual variation function listed earlier.

Template:

infor.include(‘<tableName>‘, ‘ACTIVE, DELETED, ARCHIVED’, ‘AllVariations|HighestVariation’)

Required Attributes:

• Attribute 1:

  ‘tableName’ - Case insensitive

• Attribute 2:

  Any one, two, or all three of ‘ACTIVE, DELETED, ARCHIVED’ - Case insensitive and order is not relevant.

  • Active - Records that are not deleted or archived.
  • Deleted - Records that are deleted.
  • Archived - Records that are archived.
• Attribute 3:

  ‘AllVariations’ or ‘HighestVariation’ - Case insensitive

  • AllVariations – All historical and current variations of a record. HighestVariation – The highest variation of the record.

This table shows the variation table function and their corresponding master variation table function:

Variation Function	Corresponding Master Variation function
Default Query (For example,Select * from…)	infor.include(‘<tableName>‘, ‘ACTIVE’, ‘HighestVariation’)
Infor.IncludeDeleted	infor.include(‘<tableName>‘, ‘ACTIVE, DELETED’, ‘HighestVariation’)
Infor.AllVariations	infor.include(‘<tableName>‘, 'ACTIVE, DELETED’, ‘AllVariations’)
infor.AllVariationsIncludeArchived()	infor.include(‘<tableName>‘, ‘ACTIVE, DELETED, ARCHIVED’,‘AllVariations’)
IncludeArchivedAndDeleted	infor.include(‘<tableName>‘, ‘ACTIVE, DELETED, ARCHIVED’,‘HighestVariation’)
Infor.ShowAllArchived	infor.include(‘<tableName>‘, ‘ARCHIVED’, ‘AllVariations’)
Infor.ShowArchived	infor.include(‘<tableName>‘, ‘ARCHIVED’, ‘HighestVariation’)