JR50398: Correct faceting sort by attrvaldesc.sequence when attribute values contain trailing white spaces

APAR status

• Closed as program error.

Error description

• Sorting facets by attrvaldesc.sequence will not result in the
  expected order when attribute values contains trailing white
  spaces. If you are sorting facet values by the
  attrvaldesc.sequence column(ie: facet.sort_order=2) and you
  notice the facet values are not in the order you expect,  check
  the attrval.identifier column for the pertinent attribute values
   and see if they have trailing white spaces.
  

Local fix

• You can remove the trailing white spaces from the
  attrval.identifier column.
  

Problem summary

• USERS AFFECTED:
   WebSphere Commerce V7 users with  facet.sort_order=2 attribute
  values with trailing white spaces
  
   PROBLEM ABSTRACT:
   Correct faceting sort by attrvaldesc.sequence when attribute
  values contain trailing white spaces
  
   BUSINESS IMPACT:
   Factes may not be sorted as expected on the store front.
  
   RECOMMENDATION:
  

Problem conclusion

• Updated the code to trim the trailing white spaces which will
  allow the merged sort to function as expected.
  
  
   -------------------------------------------------------------
   The latest available maintenance information can be obtained
  from the Recommended Fixes for WebSphere Commerce technote:
   http://www.ibm.com/support/docview.wss?rs=3046&uid=swg21261296
  

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:

Fix information

• Fixed component name

  WC BUS EDITION

• Fixed component ID

  5724I3800

Applicable component levels

• R700 PSY

     UP