Chapter 5. PLDBDEMO examples
5.7. User "release"
Prev  Next

5.7. User "release"

Example for the visualization of workflows: Part applied? Released by whom?

With the user selection "release ", there are 4 roles (and corresponding columns) for marking processes:

  • Applied for by engineer [Requested by Engineer]

  • Released by Standardization

  • Released by Material Check

  • Released by Purchasing Department

Export condition: 

((ERP_PDM_NUMBER.NE.'').AND.(WORKFLOW_USER.EQ.'xxxxx')
.AND.(WORKFLOW_STD.EQ.'xxxxx').AND.(WORKFLOW_MATQA.EQ.'xxxxx')
.AND.(WORKFLOW_PD.EQ.'xxxxx'))

All 4 columns can contain the marking 'xxxxx'.

Status lights:

Display tab page -> Status bitmaps for table [Status indicating bitmaps for table view]:

The traffic light colors are controlled according to the following logic:

  • Green: All 4 columns contain the identifier 'xxxxx'

  • Yellow: Column for engineer, standardization and material testing contain the identifier 'xxxxx'

    Exemplary condition:

    (WORKFLOW_USER.EQ.'xxxxx').AND.(WORKFLOW_STD.EQ.'xxxxx').AND.
(WORKFLOW_MATQA.EQ.'xxxxx').AND.(WORKFLOW_PD.NE.'xxxxx')

  • Orange: Column for engineer and standardization contain the identifier 'xxxxx'

  • Red: Requested by an engineer, but not yet approved. Only his column contains the identifier 'xxxxx'.

  • White: No ERP_PDM_NUMBER

Display tab page -> Status bitmaps for table [Status indicating bitmaps for table view]:

Display tab page -> Status bitmaps for table [Status indicating bitmaps for table view]:

User: release - Role: Released by standardization [Released by Standardization]

User: release - Role: Released by standardization [Released by Standardization]

Prev Up Next
5.6. User "quality" Home Chapter 6. Database administration