Skip to main content

Use TIER Givens

  1. Last updated
  2. Save as PDF

Overview

In TIER, there are controls (or 'givens') that can be called on any form without having to add the tables and fields.

Details

The controls that can be called on any form are listed below.

  • Tier_UserID - The user ID of the person currently logged in.
  • Tier_DocID - The document ID of the current document from the T4W_Documents table.
  • Tier_ParentID - The parent ID of the current document from the T4W_Documents table.
  • Tier_FolderID - The folder ID of the current document from the T4W_Documents table.
  • Tier_FormID - Returns the ID of the current form.
  • Tier_StatusID - Returns the OP__StatusOrd of the current document.
  • Tier_SystemName - Returns the value of the TIER Registered System Name.
  • Tier_FormName - Returns the name of the form being accessed.
  • Tier_ExeVersion - Returns the exe version launched by the user.

These controls can be used in the simplest way in a calculation on an edit for a field (for example: Calculation =:Tier_DocID) or in more complex ways when they are added as part of a filter to an initialization (for example: Filter :Tier_FolderID = :OP__FolderID).