JR53728: multiple selection of price facet not working with contract pric e index

APAR status

• Closed as program error.

Error description

• With contract price index enabled, when multiple price facets
  are selected, for example, selecting price facet 0-100 and
  100-200 to display the product which had 0-100 or 100-200 price
  range, the solr query would compose incorrect fq parameter,
  therefore, empty result will be returned and shopper will see no
   product.
  

Local fix

Problem summary

• USERS AFFECTED:
  wc.70fep7.apar wc.70fep8.apar wc.70fep.dev wc.bumblebee
  
  PROBLEM ABSTRACT:
  multiple selection of price facet not working with contract
  price index
  
  BUSINESS IMPACT:
  With multiple selection+contract price index, price facet do not
   work well, when one price section were selected, other price
  section show zero count.
  
  RECOMMENDATION:
  

Problem conclusion

• Query changes from
  
  fl=catentry_id&facet=true&facet.field={!ex=price_USD}price_USD&f
  acet.query=price_USD:({* 100} 100)&facet.query=price_USD:({100
  200} 200)&facet.query={!ex=price_USD}price_USD:({200 300}
  300)&facet.query={!ex=price_USD}price_USD:({300 400}
  400)&facet.query={!ex=price_USD}price_USD:({400 500}
  500)&facet.query={!ex=price_USD}price_USD:({500
  *})&wt=xml&q=*:*&fq=catalog_id:"10001"&fq=parentCatgroup_id_face
  t:(
  "10001_10006")&fq=storeent_id:("10001")&fq=published:1&fq=-(cate
  nttype_id_ntk_cs:ItemBean AND parentCatentry_id:[* TO
  *])&fq={!tag=price_USD}price_USD:(({* 100} 100))
  
  TO
  
  fl=catentry_id&facet=true&facet.field={!ex=price_USD}price_USD&f
  acet.query={!ex=price_USD}price_USD:({* 100}
  100)&facet.query={!ex=price_USD}price_USD:({100 200}
  200)&facet.query={!ex=price_USD}price_USD:({200 300}
  300)&facet.query={!ex=price_USD}price_USD:({300 400}
  400)&facet.query={!ex=price_USD}price_USD:({400 500}
  500)&facet.query={!ex=price_USD}price_USD:({500
  *})&wt=xml&q=*:*&fq=catalog_id:"10001"&fq=parentCatgroup_id_face
  t:(
  "10001_10006")&fq=storeent_id:("10001")&fq=published:1&fq=-(cate
  nttype_id_ntk_cs:ItemBean AND parentCatentry_id:[* TO
  *])&fq={!tag=price_USD}price_USD:(({* 100} 100))
  

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