• SubRevisions

Sub-Revisions

Features

• See SXS-T-000336 in SoftXS Tracking System

Properties

New BusinessTransactions

Permissions

Revision Code Configuration

       'revisionCode' => array( // NOK New revision code 'v99' 
         'firstRevisionNo'        => 1, 
         'gapsAllowed'            => true, 
         'revisionNoComponent'    => 1, 
         'sourceFilenameName'     => 'code', 
         'sourceFilenameFile'     => 'system', 
         'publishFilenameName'    => 'code', 
         'publishFilenameFile'    => 'system', 
         'components' => array( 
           array( // 'v' 
             'type'               => 'manual', 
             'readonly'           => true, 
             'length'             => 1, 
             'value'              => 'v', 
             'parse'              => 'v', 
           ), 
           array( // Revision 00..99, "__", "_A01", "_A02", "_A" ... "_Z" 
             'name'               => 'Revision Number', 
             'type'               => 'select', 
             'readonly'           => false, 
             'length'             => 4, 
             'rmTable'            => 'RevisionNoMapCodes', 
             'rmCode'             => 'code', 
             'rmName'             => 'code', 
             'rmField'            => 'valueId', 
             'rmFilter'           => 'revisionNoMapId', 
             'rmFilterValue'      => 4, 
             'pattern'            => '/^[_0-9A-Z]{0,4}$/', 
             'fieldIn'            => 'revisionNo', 
             'formatCode'         => '%s', 
             'fieldOut'           => 'revisionNo', 
             'parse'              => '/^[_0-9A-Z]{1,4}$/', 
           ), 
           array( // Sub-revision "a"-"z" 
             'name'               => 'Sub-revision Number', 
             'type'               => 'select', 
             'readonly'           => false, 
             'length'             => 1,
             'required'           => false,  // optional
             'rmTable'            => 'RevisionNoMapCodes', 
             'rmCode'             => 'code', 
             'rmName'             => 'code', 
             'rmField'            => 'valueId', 
             'rmFilter'           => 'revisionNoMapId', 
             'rmFilterValue'      => 5, 
             'pattern'            => '/^[a-z]{0,1}$/', 
             'fieldIn'            => 'subRevisionNo', 
             'formatCode'         => '%s', 
             'fieldOut'           => 'subRevisionNo', 
             'parse'              => '/^[a-z]$/', 
           ), 
         ), 
       ),

Database Model

create table Revisions                                           
(
    ...
    subRevisionFlag           INTEGER               not null default 0,
    subRevisionNo             INTEGER                       ,
    ...
);

System Changes

• Restricted view must be updated
• Checking of revision dates must be updated
• Automatic setting of supersededFlag must be updated

Open Points

1. How we handle available and next revision code ?
2. SXS-T-000336 5.2.3: subRevisionNo is set even if there is no sub-revision. Why?
   • Sorting can be made by "revisionNo, subRevisionFlag desc, subRevisionNo".