Example: Indexing list prices

In this example, WebSphere Commerce search is customized to index list prices.

Note: List prices are indexed in the Catalog Entry index by default.

Procedure

Configure the search preprocessor.

Go to the following directory:
- WCDE_installdir/search/pre-processConfig/MC_masterCatalogId/development_db
- WC_installdir/instances/instance_name/search/pre-processConfig/MC_masterCatalogId/target_db

Create a custom preprocess configuration file and call it wc-dataimport-preprocess-custom-listprice.xml.

Note:

Your table name must start with an XI prefix to avoid conflict with the default WebSphere Commerce tables.
Do not change existing preprocess configuration files. Newly created custom preprocess configuration files must start with wc-dataimport-preprocess and end in .xml.
For example, wc-dataimport-preprocess-XXXXX.xml, wc-dataimport-preprocess-custom-listprice.xml.
.

An example of the file that handles the USD and EUR currencies is as follows:

Note: You can change USD and EUR to another needed currency.


<?xml version="1.0" encoding="UTF-8"?>


<_config:DIHPreProcessConfig xmlns:_config="http://www.ibm.com/xmlns/prod/commerce/foundation/config" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.com/xmlns/prod/commerce/foundation/config ../../xsd/wc-dataimport-preprocess.xsd">
    <_config:data-processing-config processor="com.ibm.commerce.foundation.dataimport.preprocess.PriceDataPreProcessor" batchSize="500">
     <!-- 
    	To add a new currency, add a new column in the create statement, the column name has to LISTPRICE_XXX, XXX is the three letter
    	currency code from the ISO 4217.
    -->
    <_config:table definition="CREATE TABLE XI_LISTPRICE_0 (CATENTRY_ID BIGINT NOT NULL, LISTPRICE_USD DECIMAL(20,5) , LISTPRICE_EUR DECIMAL(20,5) , 
    							PRIMARY KEY (CATENTRY_ID))" name="XI_LISTPRICE_0"/>
    <_config:query sql="select lp.catentry_id catentry_id, lp.currency currency, lp.listprice listprice from listprice lp, TI_CATENTRY_0 CE 
 				where lp.catentry_id = ce.catentry_id AND lp.currency in (?currencyCode?) AND CE.CATENTTYPE_ID <> 'BundleBean' 
 				order by catentry_id, currency"/>
    <_config:mapping>
      <_config:key queryColumn="CATENTRY_ID" tableColumn="CATENTRY_ID"/>
      <_config:column-mapping>
      	<_config:column-column-mapping>
      		<!-- do not change this part -->
        	<_config:column-column queryColumn="LISTPRICE" tableColumn="LISTPRICE" />
        </_config:column-column-mapping>
      </_config:column-mapping>
    </_config:mapping>
    <_config:property name="currencyCode" value="USD, EUR"/>
  </_config:data-processing-config>
  <_config:data-processing-config processor="com.ibm.commerce.foundation.dataimport.preprocess.StaticDecimalDataPreProcessor" batchSize="500">
  	 <!-- 
    	For the newly added currency in the above table. Add the name column name in the create statement. and add a SUM(LISTPRICE_XXX) in the select
    	statement part. the LISTPRICE_XXX is the new column added the table above.
    -->
  	<_config:table definition="CREATE TABLE XI_LBUNDLEPRICE_0 (CATENTRY_ID BIGINT NOT NULL, LISTPRICE_USD DECIMAL(20,5) , LISTPRICE_EUR DECIMAL(20,5) , 
    							 PRIMARY KEY (CATENTRY_ID))" name="XI_LBUNDLEPRICE_0"/>
    <_config:query sql="SELECT CATENTREL.CATENTRY_ID_PARENT, SUM(LP.LISTPRICE_USD) LISTPRICE_USD, SUM(LP.LISTPRICE_EUR) LISTPRICE_EUR
    										FROM TI_CATENTRY_0 ITEM,  CATENTREL, XI_LISTPRICE_0 LP
												WHERE CATENTREL.CATENTRY_ID_CHILD=ITEM.CATENTRY_ID AND ITEM.CATENTRY_ID=LP.CATENTRY_ID AND
 												CATENTREL.CATRELTYPE_ID='BUNDLE_COMPONENT' AND			
												EXISTS(SELECT * FROM TI_CATENTRY_0 BUNDLE WHERE BUNDLE.CATENTRY_ID=CATENTREL.CATENTRY_ID_PARENT) 
												GROUP BY CATENTREL.CATENTRY_ID_PARENT
												ORDER BY CATENTREL.CATENTRY_ID_PARENT"/>
    <_config:mapping>
      <_config:key queryColumn="CATENTRY_ID_PARENT" tableColumn="CATENTRY_ID"/>
      <_config:column-mapping>
      	<_config:column-column-mapping>
      		<!-- To add a new currency, need to add the column mapping to the newly added currency column in the section.-->
        	<_config:column-column queryColumn="LISTPRICE_USD" tableColumn="LISTPRICE_USD" />
        	<_config:column-column queryColumn="LISTPRICE_EUR" tableColumn="LISTPRICE_EUR" />
        </_config:column-column-mapping>
      </_config:column-mapping>
    </_config:mapping>
  </_config:data-processing-config>
  
</_config:DIHPreProcessConfig>

Preprocess the search index data.
1. Query the XI_LISTPRICE_0 and XI_LBUNDLEPRICE_0 tables to confirm that the list prices are populated.

Configure the Data Import Handler mapping.

Go to the following directory:
- WCDE_installdir/search/solr/home
- WC_installdir/instances/instance_name/search/solr/home
This directory contains the Master Catalog folder, in which there are the configurations files for each language. If you have more than one language folders, perform this step for every language.
Open the MC_masterCatalogId/en_US/CatalogEntry/conf/schema.xml file.

Locate <dynamicField name="price_*" type="float" indexed="true" stored="true" multiValued="false"/> and add the following snippet in bold.


<!--
   Catentry's default offer price: map to table OFFERPRICE
   --> 
   <dynamicField name="price_*" type="float" indexed="true" stored="true" multiValued="false"/>

   <!--
   Catentry's default list price: map to table LISTPRICE
   -->
   <dynamicField name="xf_listprice_*" type="float" indexed="true" stored="true" multiValued="false"/>

Save your changes.
Open the MC_masterCatalogId/en_US/CatalogEntry/conf/wc-data-config.xml file.
Locate <document name="CatalogEntry"> for entity name="Product" and name ="Others", for both the query and deltaImportQuery sections.

Add the following columns and tables in bold to the select SQL:


SELECT CATENTRY.CATENTRY_ID,CATENTRY.MEMBER_ID,CATENTRY.CATENTTYPE_ID,CATENTRY.PARTNUMBER,CATENTRY.MFPARTNUMBER,CATENTRY.MFNAME, CATENTRY.BUYABLE,
	STORECENT.STOREENT_ID, 
	CATENTDESC.NAME,CATENTDESC.SHORTDESCRIPTION,CATENTDESC.THUMBNAIL,CATENTDESC.FULLIMAGE, CATENTDESC.KEYWORD, CATENTDESC.PUBLISHED,
	TI_DPGROUP.CATGROUP DPCATGROUP,
	TI_APGROUP.CATGROUPS APCATGROUP,
	TI_PRODUCTSET.PRODUCTSET,
	TI_OFFERPRICE.PRICE_USD, TI_OFFERPRICE.PRICE_EUR, TI_OFFERPRICE.PRICE_CAD, TI_OFFERPRICE.PRICE_CNY,
	TI_OFFERPRICE.PRICE_JPY, TI_OFFERPRICE.PRICE_KRW, TI_OFFERPRICE.PRICE_BRL, TI_OFFERPRICE.PRICE_TWD,
	TI_OFFERPRICE.PRICE_PLN, TI_OFFERPRICE.PRICE_PLN, TI_OFFERPRICE.PRICE_RON, TI_OFFERPRICE.PRICE_EGP,
	TI_OFFERPRICE.PRICE_GBP,
	TI_DPCATENTRY.CATENTRY_PARENT,
	TI_CATALOG.CATALOG PARENT_CATALOG_ID,
	
	XI_LISTPRICE.LISTPRICE_USD,	XI_LISTPRICE.LISTPRICE_EUR,
											
	TI_CASTB1.CAS_F1 CAS_F1ATTR, TI_CASTB1.CAS_F2 CAS_F2ATTR, TI_CASTB1.CAS_F3 CAS_F3ATTR,TI_CASTB1.CAS_F4 CAS_F4ATTR,TI_CASTB1.CAS_F5 CAS_F5ATTR,
	TI_CASTB1.CAS_F6 CAS_F6ATTR,TI_CASTB1.CAS_F7 CAS_F7ATTR,	TI_CASTB1.CAS_F8 CAS_F8ATTR,TI_CASTB1.CAS_F9 CAS_F9ATTR,TI_CASTB1.CAS_F10 CAS_F10ATTR,
	TI_CASTB1.CAS_F11 CAS_F11ATTR,TI_CASTB1.CAS_F12 CAS_F12ATTR,TI_CASTB1.CAS_F13 CAS_F13ATTR,TI_CASTB1.CAS_F14 CAS_F14ATTR,TI_CASTB1.CAS_F15 CAS_F15ATTR,
	TI_CASTB1.CAS_F16 CAS_F16ATTR,TI_CASTB1.CAS_F17 CAS_F17ATTR, TI_CASTB1.CAS_F18 CAS_F18ATTR,TI_CASTB1.CAS_F19 CAS_F19ATTR,TI_CASTB1.CAS_F20 CAS_F20ATTR,
	TI_CASTB1.CAS_F21 CAS_F21ATTR,TI_CASTB1.CAS_F22 CAS_F22ATTR,TI_CASTB1.CAS_F23 CAS_F23ATTR,TI_CASTB1.CAS_F24 CAS_F24ATTR,TI_CASTB1.CAS_F25  CAS_F21ATTR,
	TI_CASTB1.CAS_F26  CAS_F26ATTR,TI_CASTB1.CAS_F27  CAS_F27ATTR,TI_CASTB1.CAS_F28  CAS_F28ATTR,TI_CASTB1.CAS_F29  CAS_F29ATTR,TI_CASTB1.CAS_F30  CAS_F30ATTR,
	TI_CAITB1.CAI_F1,	TI_CAITB1.CAI_F2,	TI_CAITB1.CAI_F3,	TI_CAITB1.CAI_F4,	TI_CAITB1.CAI_F5,	TI_CAITB1.CAI_F6,	TI_CAITB1.CAI_F7,	TI_CAITB1.CAI_F8,	TI_CAITB1.CAI_F9,	TI_CAITB1.CAI_F10,
	TI_CAFTB1.CAF_F1, TI_CAFTB1.CAF_F2, TI_CAFTB1.CAF_F3, TI_CAFTB1.CAF_F4, TI_CAFTB1.CAF_F5, TI_CAFTB1.CAF_F6, TI_CAFTB1.CAF_F7, TI_CAFTB1.CAF_F8, TI_CAFTB1.CAF_F9, TI_CAFTB1.CAF_F10,
	
	TI_ADSTB1.ADS_F1 ADS_F1ATTR, TI_ADSTB1.ADS_F2 ADS_F2ATTR, TI_ADSTB1.ADS_F3 ADS_F3ATTR,TI_ADSTB1.ADS_F4 ADS_F4ATTR,TI_ADSTB1.ADS_F5 ADS_F5ATTR,
	TI_ADSTB1.ADS_F6 ADS_F6ATTR,TI_ADSTB1.ADS_F7 ADS_F7ATTR,	TI_ADSTB1.ADS_F8 ADS_F8ATTR,TI_ADSTB1.ADS_F9 ADS_F9ATTR,TI_ADSTB1.ADS_F10 ADS_F10ATTR,
	TI_ADSTB1.ADS_F11 ADS_F11ATTR,TI_ADSTB1.ADS_F12 ADS_F12ATTR,TI_ADSTB1.ADS_F13 ADS_F13ATTR,TI_ADSTB1.ADS_F14 ADS_F14ATTR,TI_ADSTB1.ADS_F15 ADS_F15ATTR,
	TI_ADSTB1.ADS_F16 ADS_F16ATTR,TI_ADSTB1.ADS_F17 ADS_F17ATTR, TI_ADSTB1.ADS_F18 ADS_F18ATTR,TI_ADSTB1.ADS_F19 ADS_F19ATTR,TI_ADSTB1.ADS_F20 ADS_F20ATTR,
	TI_ADSTB1.ADS_F21 ADS_F21ATTR,TI_ADSTB1.ADS_F22 ADS_F22ATTR,TI_ADSTB1.ADS_F23 ADS_F23ATTR,TI_ADSTB1.ADS_F24 ADS_F24ATTR,TI_ADSTB1.ADS_F25  ADS_F21ATTR,
	TI_ADSTB1.ADS_F26  ADS_F26ATTR,TI_ADSTB1.ADS_F27  ADS_F27ATTR,TI_ADSTB1.ADS_F28  ADS_F28ATTR,TI_ADSTB1.ADS_F29  ADS_F29ATTR,TI_ADSTB1.ADS_F30  ADS_F30ATTR,
	TI_ADITB1.ADI_F1,	TI_ADITB1.ADI_F2,	TI_ADITB1.ADI_F3,	TI_ADITB1.ADI_F4,	TI_ADITB1.ADI_F5,	TI_ADITB1.ADI_F6,	TI_ADITB1.ADI_F7,	TI_ADITB1.ADI_F8,	TI_ADITB1.ADI_F9,	TI_ADITB1.ADI_F10,
	TI_ADFTB1.ADF_F1, TI_ADFTB1.ADF_F2, TI_ADFTB1.ADF_F3, TI_ADFTB1.ADF_F4, TI_ADFTB1.ADF_F5, TI_ADFTB1.ADF_F6, TI_ADFTB1.ADF_F7, TI_ADFTB1.ADF_F8, TI_ADFTB1.ADF_F9, TI_ADFTB1.ADF_F10

Append the table join clause in bold:


FROM CATENTRY
	INNER JOIN TI_CATENTRY_0 TI_CATENTRY ON (CATENTRY.CATENTRY_ID=TI_CATENTRY.CATENTRY_ID)
	LEFT OUTER JOIN STORECENT ON (CATENTRY.CATENTRY_ID=STORECENT.CATENTRY_ID)
	LEFT OUTER JOIN CATENTDESC ON (CATENTDESC.CATENTRY_ID=CATENTRY.CATENTRY_ID AND CATENTDESC.LANGUAGE_ID=-1)
	LEFT OUTER JOIN TI_DPGROUP_0 TI_DPGROUP ON (CATENTRY.CATENTRY_ID=TI_DPGROUP.CATENTRY_ID)
	LEFT OUTER JOIN TI_APGROUP_0 TI_APGROUP ON (CATENTRY.CATENTRY_ID=TI_APGROUP.CATENTRY_ID)
	LEFT OUTER JOIN TI_PRODUCTSET_0 TI_PRODUCTSET ON (CATENTRY.CATENTRY_ID=TI_PRODUCTSET.CATENTRY_ID)
	LEFT OUTER JOIN TI_OFFERPRICE_0 TI_OFFERPRICE ON (CATENTRY.CATENTRY_ID=TI_OFFERPRICE.CATENTRY_ID)
	LEFT OUTER JOIN TI_DPCATENTRY_0 TI_DPCATENTRY ON (CATENTRY.CATENTRY_ID=TI_DPCATENTRY.CATENTRY_ID)
	LEFT OUTER JOIN TI_CATALOG_0 TI_CATALOG ON (CATENTRY.CATENTRY_ID=TI_CATALOG.CATENTRY_ID)
LEFT OUTER JOIN XI_LISTPRICE_0 XI_LISTPRICE ON (CATENTRY.CATENTRY_ID=XI_LISTPRICE.CATENTRY_ID)

		LEFT OUTER JOIN TI_CASTB1_0_1 TI_CASTB1 ON (CATENTRY.CATENTRY_ID=TI_CASTB1.CATENTRY_ID)
		LEFT OUTER JOIN TI_CAITB1_0_1 TI_CAITB1 ON (CATENTRY.CATENTRY_ID=TI_CAITB1.CATENTRY_ID)
		LEFT OUTER JOIN TI_CAFTB1_0_1 TI_CAFTB1 ON (CATENTRY.CATENTRY_ID=TI_CAFTB1.CATENTRY_ID)
		
		LEFT OUTER JOIN TI_ADSTB1_0_1 TI_ADSTB1 ON (CATENTRY.CATENTRY_ID=TI_ADSTB1.CATENTRY_ID)
		LEFT OUTER JOIN TI_ADITB1_0_1 TI_ADITB1 ON (CATENTRY.CATENTRY_ID=TI_ADITB1.CATENTRY_ID)
		LEFT OUTER JOIN TI_ADFTB1_0_1 TI_ADFTB1 ON (CATENTRY.CATENTRY_ID=TI_ADFTB1.CATENTRY_ID)

Add the field mapping before

<field column="CAS_F1ATTR"
								clob="true"/>


<field column="LISTPRICE_USD" name="xf_listprice_USD"/>
				<field column="LISTPRICE_EUR" name="xf_listprice_EUR"/>				
																
				<field column="CAS_F1ATTR"  clob="true"/>
				<field column="cas_f1" splitBy=";" sourceColName="CAS_F1ATTR"/>

Locate entity name="Bundle", for both the query and deltaImportQuery sections.

Add the following columns and tables in bold to the select SQL:

SELECT CATENTRY.CATENTRY_ID,CATENTRY.MEMBER_ID,CATENTRY.CATENTTYPE_ID,CATENTRY.PARTNUMBER,CATENTRY.MFPARTNUMBER,CATENTRY.MFNAME, CATENTRY.BUYABLE,
	STORECENT.STOREENT_ID, 
	CATENTDESC.NAME,CATENTDESC.SHORTDESCRIPTION,CATENTDESC.THUMBNAIL,CATENTDESC.FULLIMAGE, CATENTDESC.KEYWORD, CATENTDESC.PUBLISHED,
	TI_DPGROUP.CATGROUP DPCATGROUP,
	TI_APGROUP.CATGROUPS APCATGROUP,
	TI_PRODUCTSET.PRODUCTSET,
	TI_BUNDLEPRICE.PRICE_USD, TI_BUNDLEPRICE.PRICE_EUR, TI_BUNDLEPRICE.PRICE_CAD, TI_BUNDLEPRICE.PRICE_CNY,
	TI_BUNDLEPRICE.PRICE_JPY, TI_BUNDLEPRICE.PRICE_KRW, TI_BUNDLEPRICE.PRICE_BRL, TI_BUNDLEPRICE.PRICE_TWD,
	TI_BUNDLEPRICE.PRICE_PLN, TI_BUNDLEPRICE.PRICE_PLN, TI_BUNDLEPRICE.PRICE_RON, TI_BUNDLEPRICE.PRICE_EGP,
	TI_BUNDLEPRICE.PRICE_GBP,
	TI_DPCATENTRY.CATENTRY_PARENT,
	TI_CATALOG.CATALOG PARENT_CATALOG_ID,
	
	XI_LBUNDLEPRICE.LISTPRICE_USD, XI_LBUNDLEPRICE.LISTPRICE_EUR,

	TI_CASTB1.CAS_F1 CAS_F1ATTR, TI_CASTB1.CAS_F2 CAS_F2ATTR, TI_CASTB1.CAS_F3 CAS_F3ATTR,TI_CASTB1.CAS_F4 CAS_F4ATTR,TI_CASTB1.CAS_F5 CAS_F5ATTR,
	TI_CASTB1.CAS_F6 CAS_F6ATTR,TI_CASTB1.CAS_F7 CAS_F7ATTR,	TI_CASTB1.CAS_F8 CAS_F8ATTR,TI_CASTB1.CAS_F9 CAS_F9ATTR,TI_CASTB1.CAS_F10 CAS_F10ATTR,
	TI_CASTB1.CAS_F11 CAS_F11ATTR,TI_CASTB1.CAS_F12 CAS_F12ATTR,TI_CASTB1.CAS_F13 CAS_F13ATTR,TI_CASTB1.CAS_F14 CAS_F14ATTR,TI_CASTB1.CAS_F15 CAS_F15ATTR,
	TI_CASTB1.CAS_F16 CAS_F16ATTR,TI_CASTB1.CAS_F17 CAS_F17ATTR, TI_CASTB1.CAS_F18 CAS_F18ATTR,TI_CASTB1.CAS_F19 CAS_F19ATTR,TI_CASTB1.CAS_F20 CAS_F20ATTR,
	TI_CASTB1.CAS_F21 CAS_F21ATTR,TI_CASTB1.CAS_F22 CAS_F22ATTR,TI_CASTB1.CAS_F23 CAS_F23ATTR,TI_CASTB1.CAS_F24 CAS_F24ATTR,TI_CASTB1.CAS_F25  CAS_F21ATTR,
	TI_CASTB1.CAS_F26  CAS_F26ATTR,TI_CASTB1.CAS_F27  CAS_F27ATTR,TI_CASTB1.CAS_F28  CAS_F28ATTR,TI_CASTB1.CAS_F29  CAS_F29ATTR,TI_CASTB1.CAS_F30  CAS_F30ATTR,
	TI_CAITB1.CAI_F1,	TI_CAITB1.CAI_F2,	TI_CAITB1.CAI_F3,	TI_CAITB1.CAI_F4,	TI_CAITB1.CAI_F5,	TI_CAITB1.CAI_F6,	TI_CAITB1.CAI_F7,	TI_CAITB1.CAI_F8,	TI_CAITB1.CAI_F9,	TI_CAITB1.CAI_F10,
	TI_CAFTB1.CAF_F1, TI_CAFTB1.CAF_F2, TI_CAFTB1.CAF_F3, TI_CAFTB1.CAF_F4, TI_CAFTB1.CAF_F5, TI_CAFTB1.CAF_F6, TI_CAFTB1.CAF_F7, TI_CAFTB1.CAF_F8, TI_CAFTB1.CAF_F9, TI_CAFTB1.CAF_F10, 								
	
	TI_ADSTB1.ADS_F1 ADS_F1ATTR, TI_ADSTB1.ADS_F2 ADS_F2ATTR, TI_ADSTB1.ADS_F3 ADS_F3ATTR,TI_ADSTB1.ADS_F4 ADS_F4ATTR,TI_ADSTB1.ADS_F5 ADS_F5ATTR,
	TI_ADSTB1.ADS_F6 ADS_F6ATTR,TI_ADSTB1.ADS_F7 ADS_F7ATTR,	TI_ADSTB1.ADS_F8 ADS_F8ATTR,TI_ADSTB1.ADS_F9 ADS_F9ATTR,TI_ADSTB1.ADS_F10 ADS_F10ATTR,
	TI_ADSTB1.ADS_F11 ADS_F11ATTR,TI_ADSTB1.ADS_F12 ADS_F12ATTR,TI_ADSTB1.ADS_F13 ADS_F13ATTR,TI_ADSTB1.ADS_F14 ADS_F14ATTR,TI_ADSTB1.ADS_F15 ADS_F15ATTR,
	TI_ADSTB1.ADS_F16 ADS_F16ATTR,TI_ADSTB1.ADS_F17 ADS_F17ATTR, TI_ADSTB1.ADS_F18 ADS_F18ATTR,TI_ADSTB1.ADS_F19 ADS_F19ATTR,TI_ADSTB1.ADS_F20 ADS_F20ATTR,
	TI_ADSTB1.ADS_F21 ADS_F21ATTR,TI_ADSTB1.ADS_F22 ADS_F22ATTR,TI_ADSTB1.ADS_F23 ADS_F23ATTR,TI_ADSTB1.ADS_F24 ADS_F24ATTR,TI_ADSTB1.ADS_F25  ADS_F21ATTR,
	TI_ADSTB1.ADS_F26  ADS_F26ATTR,TI_ADSTB1.ADS_F27  ADS_F27ATTR,TI_ADSTB1.ADS_F28  ADS_F28ATTR,TI_ADSTB1.ADS_F29  ADS_F29ATTR,TI_ADSTB1.ADS_F30  ADS_F30ATTR,
	TI_ADITB1.ADI_F1,	TI_ADITB1.ADI_F2,	TI_ADITB1.ADI_F3,	TI_ADITB1.ADI_F4,	TI_ADITB1.ADI_F5,	TI_ADITB1.ADI_F6,	TI_ADITB1.ADI_F7,	TI_ADITB1.ADI_F8,	TI_ADITB1.ADI_F9,	TI_ADITB1.ADI_F10,
	TI_ADFTB1.ADF_F1, TI_ADFTB1.ADF_F2, TI_ADFTB1.ADF_F3, TI_ADFTB1.ADF_F4, TI_ADFTB1.ADF_F5, TI_ADFTB1.ADF_F6, TI_ADFTB1.ADF_F7, TI_ADFTB1.ADF_F8, TI_ADFTB1.ADF_F9, TI_ADFTB1.ADF_F10

Append the table join clause in bold:


FROM CATENTRY
	INNER JOIN TI_CATENTRY_0 TI_CATENTRY ON (CATENTRY.CATENTRY_ID=TI_CATENTRY.CATENTRY_ID)
	LEFT OUTER JOIN STORECENT ON (CATENTRY.CATENTRY_ID=STORECENT.CATENTRY_ID)
	LEFT OUTER JOIN CATENTDESC ON (CATENTDESC.CATENTRY_ID=CATENTRY.CATENTRY_ID AND CATENTDESC.LANGUAGE_ID=-1)
	LEFT OUTER JOIN TI_DPGROUP_0 TI_DPGROUP ON (CATENTRY.CATENTRY_ID=TI_DPGROUP.CATENTRY_ID)
	LEFT OUTER JOIN TI_APGROUP_0 TI_APGROUP ON (CATENTRY.CATENTRY_ID=TI_APGROUP.CATENTRY_ID)
	LEFT OUTER JOIN TI_PRODUCTSET_0 TI_PRODUCTSET ON (CATENTRY.CATENTRY_ID=TI_PRODUCTSET.CATENTRY_ID)
	LEFT OUTER JOIN TI_BUNDLEPRICE_0 TI_BUNDLEPRICE ON (CATENTRY.CATENTRY_ID=TI_BUNDLEPRICE.CATENTRY_ID)
	LEFT OUTER JOIN TI_DPCATENTRY_0 TI_DPCATENTRY ON (CATENTRY.CATENTRY_ID=TI_DPCATENTRY.CATENTRY_ID)
	LEFT OUTER JOIN TI_CATALOG_0 TI_CATALOG ON (CATENTRY.CATENTRY_ID=TI_CATALOG.CATENTRY_ID)
	LEFT OUTER JOIN XI_LBUNDLEPRICE_0 XI_LBUNDLEPRICE ON (CATENTRY.CATENTRY_ID=XI_LBUNDLEPRICE.CATENTRY_ID)

	LEFT OUTER JOIN TI_CASTB1_0_1 TI_CASTB1 ON (CATENTRY.CATENTRY_ID=TI_CASTB1.CATENTRY_ID)
	LEFT OUTER JOIN TI_CAITB1_0_1 TI_CAITB1 ON (CATENTRY.CATENTRY_ID=TI_CAITB1.CATENTRY_ID)
	LEFT OUTER JOIN TI_CAFTB1_0_1 TI_CAFTB1 ON (CATENTRY.CATENTRY_ID=TI_CAFTB1.CATENTRY_ID)
	
	LEFT OUTER JOIN TI_ADSTB1_0_1 TI_ADSTB1 ON (CATENTRY.CATENTRY_ID=TI_ADSTB1.CATENTRY_ID)
	LEFT OUTER JOIN TI_ADITB1_0_1 TI_ADITB1 ON (CATENTRY.CATENTRY_ID=TI_ADITB1.CATENTRY_ID)
	LEFT OUTER JOIN TI_ADFTB1_0_1 TI_ADFTB1 ON (CATENTRY.CATENTRY_ID=TI_ADFTB1.CATENTRY_ID)

Add the field mapping before

<field column="CAS_F1ATTR"
								clob="true"/>


<field column="LISTPRICE_USD" name="xf_listprice_USD"/>
				<field column="LISTPRICE_EUR" name="xf_listprice_EUR"/>
																

<field column="CAS_F1ATTR"  clob="true"/>
				<field column="cas_f1" splitBy=";" sourceColName="CAS_F1ATTR"/>

Save the changes and close the file.

Restart the WebSphere Commerce search server.
Run the di-buildindex utility.
Verify the data:
- http://localhost/solr/MC_10101_CatalogEntry_en_US/select?q=*:*
- http://yoursolrserverhost:3737/solr/MC_10101_CatalogEntry_en_US/select?q=*:*
A sample snippet that resembles the following snippet is displayed:
```
<float name="xf_listprice_USD">83.94</float>
```