Documentation Home

Workflow Sandbox Details

The diagram below explains the Update flow as an entity goes through through the worflow and approvals process provided by the Enterprise module. Each lane showcases how new entities are created/updated/archived in active entity alongside the supporting Sandbox Worklfow tables in the database.

Enterprise Sandboxing Diagram

Start

Update the name on Category Clearance, with an ID of 2004 to Going Fast

Start

After Save

Changes are contained in the User Sandbox, denoted by the Light Green color in the diagram

After Save

Category Changes

  • Category : BLC_CATEGORY
    • Clone 1 will be created for the changed entity, in this case, a Category
    • Clone 1 will have SNDBX_TIER = 1, SNDBX_ORIG_ITEM_ID = 2004, SNDBX_ORIG_RECORD_ID = 2004
    • Clone 1 will have SNDBX_ID pointing to the User Sandbox
    • There is no change to the original record as is it is the Production record
  • CloneLib : BLC_SNDBX_WRKFLW_CLONE_LIB
    • An entry will be created that will link Sanbox Workflow Clone Lib 1 to the original record. When the system needs to find a record by ID, it will check against the clone lib to check if there is a clone that it needs to retrieve instead.

Sandbox Workflow Changes

  • Sandbox Workflow Items : BLC_SNDBX_WRKFLW_ITEM
    • Sanbox Workflow Items 1 will be created
    • Drives the My Changes grid and is used to hold basic details about an individual change.
    • At least two records will be created
      • A container record that will that is used to contain all the changes that occurred, also referred to as the changeset.
      • The changes will be held in item records that will be linked to the container record. In this case, since we only made one change, we will only get one record. If multiple changes are made, each change will have an item record.
  • Sandbox Entity Items : BLC_SNDBX_ENTITY_ITEM
    • Sanbox Workflow Entity Items 1 will be created
    • Each Sandbox Workflow Item created will point to a Sandbox Entity Item
    • Holds information regarding the entity that had the change
    • Drives the colored carets displaying next to items within a grid in the admin
    • This is related to the sandbox item via the ENTITY_ITEM_ID column in each BLC_SNDBX_WRKFLW_ITEM record
  • Sandbox Entity : BLC_SNDBX_ENTITY
    • Sanbox Workflow Entity 1 will be created
    • Record used to house the class type of the entity changed

After Promotion

Changes are contained in the Default/Approver Sandbox, denoted by the Light Purple color in the diagram

After Promotion

Category Changes

  • Category : BLC_CATEGORY
    • Clone 1 will be be set to ARCHIVED = 'Y' and SNDBX_ARCHIVED_FLAG = 'Y'
    • Clone 2 will be created for the changed entity, in this case, a Category
      • Clone 2 will have SNDBX_TIER = 2, SNDBX_ORIG_ITEM_ID = 2004, SNDBX_ORIG_RECORD_ID = 2004
      • Clone 2 will have SNDBX_ID pointing to the Default/Approver Sandbox
  • CloneLib : BLC_SNDBX_WRKFLW_CLONE_LIB
    • Sanbox Workflow Clone Lib 1 will be deleted
    • Sanbox Workflow Clone Lib 2 will be created pointing to the original record

Sandbox Workflow Changes

  • Sandbox Workflow Items : BLC_SNDBX_WRKFLW_ITEM
    • Sanbox Workflow Items 1 will be archived by setting the ARCHIVED_FLAG='Y'and a SCHEDULED_DATE
    • Sanbox Workflow Items 2 will be created
  • Sandbox Entity Items : BLC_SNDBX_ENTITY_ITEM
    • Sanbox Workflow Entity Items 1 will be archived by setting the ARCHIVED_FLAG='Y'
    • Sanbox Workflow Entity Items 2 will be created
  • Sandbox Entity : BLC_SNDBX_ENTITY
    • Sanbox Workflow Entity 2 will be created
  • Sandbox Workflow Event : BLC_SNDBX_WRKFLW_EVENT
    • Sanbox Workflow Event 1 will be created with PROMOTION_TYPE = 'PROMOTION'
    • Links to a list of Sandbox Workflow Event Items
  • Sandbox Workflow Event Items : BLC_SNDBX_WRKFLW_EVENT_ITEM
    • Sanbox Workflow Event Items 1 will be created
    • One record will be created for each Sandbox Workflow Item container found in the changeset
  • Process Status : BLC_PROCESS_STATUS
    • Process Status 1 will be created
    • This record points to the Sanbox Workflow Event 1

After Approval

Changes will remain in the Default/Approver Sandbox until the deployment occurs. Deployments can be scheduled to deploy immediately or sometime in the future.

After Approval

Category Changes

  • Category : BLC_CATEGORY
    • No change
  • CloneLib : BLC_SNDBX_WRKFLW_CLONE_LIB
    • No change

Sandbox Workflow Changes

  • Sandbox Workflow Items : BLC_SNDBX_WRKFLW_ITEM
    • Sanbox Workflow Items 2 will be archived by setting the ARCHIVED_FLAG='Y'and a SCHEDULED_DATE
    • Sanbox Workflow Items 3 will be created
  • Sandbox Entity Items : BLC_SNDBX_ENTITY_ITEM
    • Sanbox Workflow Entity Items 2 will be archived by setting the ARCHIVED_FLAG='Y'
    • Sanbox Workflow Entity Items 3 will be created
  • Sandbox Entity : BLC_SNDBX_ENTITY
    • Sanbox Workflow Entity 3 will be created
  • Sandbox Workflow Event : BLC_SNDBX_WRKFLW_EVENT
    • Sanbox Workflow Event 1 will be updated with PROMOTION_TYPE = 'APPROVE'
    • Links to a list of Sandbox Workflow Event Items
  • Sandbox Workflow Event Items : BLC_SNDBX_WRKFLW_EVENT_ITEM
    • Sanbox Workflow Event Items 1 updated to point to the new Sandbox Workflow Items
  • Process Status : BLC_PROCESS_STATUS
    • Process Status 2 will be created
    • This record points to the Sanbox Workflow Event 1
  • Sandbox Workflow Deploy : BLC_SNDBX_WRKFLW_DEPLOY
    • Sandbox Workflow Deploy 1 will be created with the information for the upcoming deployment.

After Deployment

Changes will go into production.

After Deployment

Category Changes

  • Category : BLC_CATEGORY
    • Clone 2 will be be set to ARCHIVED = 'Y' and SNDBX_ARCHIVED_FLAG = 'Y'
  • CloneLib : BLC_SNDBX_WRKFLW_CLONE_LIB
    • Sanbox Workflow Clone Lib 2 will be deleted

Sandbox Workflow Changes

  • Sandbox Workflow Items : BLC_SNDBX_WRKFLW_ITEM
    • Sanbox Workflow Items 3 will be archived by setting the ARCHIVED_FLAG='Y'and a SCHEDULED_DATE
  • Sandbox Entity Items : BLC_SNDBX_ENTITY_ITEM
    • Sanbox Workflow Entity Items 3 will be archived by setting the ARCHIVED_FLAG='Y'
  • Sandbox Entity : BLC_SNDBX_ENTITY
    • No change
  • Sandbox Workflow Event : BLC_SNDBX_WRKFLW_EVENT
    • Sanbox Workflow Event 1 will be archived by setting the ARCHIVED_FLAG='Y'and a SCHEDULED_DATE
    • Links to a list of Sandbox Workflow Event Items
  • Sandbox Workflow Event Items : BLC_SNDBX_WRKFLW_EVENT_ITEM
    • Sanbox Workflow Event Items 1 updated to point to the new Sandbox Workflow Items
  • Process Status : BLC_PROCESS_STATUS
    • Process Status 2 will be archived by setting the ARCHIVED_FLAG='Y'
  • Sandbox Workflow Deploy : BLC_SNDBX_WRKFLW_DEPLOY
    • Sandbox Workflow Deploy 1 will be archived by setting the ARCHIVED_FLAG='Y'and a SCHEDULED_DATE