IV91760: RETIRED HIERARCHY CODES ARE NOT BEING HIDDEN WHEN SELECTING HIDE STATE IN HIERARCHY

3.5.2-TIV-TAP-FP002-WIN
3.5.2-TIV-TAP-FP002-README
3.5.2-TIV-TAP-FP002-LIN
3.5.2-TIV-TAP-FP002-AIX

APAR status

• Closed as fixed if next.

Error description

• You want to hide records in a hierarchy of a certain state.
  For example, you want to hide locations that are in a Retired
  State.  When you go to the Data Modeler and for triLocation, go
  to State Transitions and for triRetired, select Hide state  in
  hierarchy.   Then Publish the BO.
  
  If you have the following hierarchy
  Bldg1
  bldg1-Flr1
  bldg1-Flr1-space1
  bldg1-Flr1-space2
  
  and you retire space1, it is still visible in the hierarchy and
  it should not be visible.
  
  When that checkbox for Hide State in Hierarchy in the Data
  Modeler is used, that should hide those states from being seen
  in the hierarchy.
  

Local fix

Problem summary

• Issue only happens on MSSQL and DB2 because they have different
  sql (Union All) vs oracle sql to get all the children in
  hierarchy.
  

Problem conclusion

• Records with hidden states are no longer  displayed in
  hierarchy if they are more than 1 level deep.
  This is targeted to the 1h2017 release.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• 999
  

Fix information

Applicable component levels

• R352 PSY

     UP