IBM Support

Search using custom fields are not working on Customer Search

Troubleshooting


Problem

Attempts to use City Attribute in customer search window does not return correct results in IBM Sterling Call Center for Commerce

Symptom

The getCompleteCustomerList input does not pass city attribute at <PersonInfo/> level.
========================
<Customer CallingOrganizationCode="Matrix-R" CustomerType="02"
    DisplayLocalizedFieldInLocale="en_US_EST" IgnoreOrdering="N"
MaximumRecords="5000">
    <OrderBy>
        <Attribute Desc="N" Name="CustomerID"/>
    </OrderBy>
    <CustomerContactList>
        <CustomerContact>
            <CustomerAdditionalAddressList>
                <CustomerAdditionalAddress>
                    <PersonInfo/>
                </CustomerAdditionalAddress>
            </CustomerAdditionalAddressList>
        </CustomerContact>
    </CustomerContactList>
    <Paginate IgnoreOrdering="Y" PageNumber="1" PageSize="10"
PaginationStrategy="NEXTPAGE">
        <PreviousPage/>
    </Paginate>
</Customer>
========================

Cause

The mashup configuration is incorrect.

Environment

Ensure the xpath are as follows for City attribute in the mashup id:

  • Customer.CustomerContactList.CustomerContact.CustomerAdditionalAddress
    List.CustomerAdditionalAddress.PersonInfo.City

  • Customer.CustomerAdditionalAddressList.CustomerAdditionalAddress.PersonInfo.City

Resolving The Problem

Steps to resolve:

  1. Go to business customer search window and add City filed under search criteria.

  2. Refer Pincode implementation and replicate the same for City.

    Set the following for City Attribute:
    Source binding:
    Namespace: screenInput
    Path: Customer.CustomerAdditionalAddressList.CustomerAdditionalAddress.PersonInfo.City

    Target binding:
    Namespace: getBusinessCustomerList_input
    Path: Customer.CustomerAdditionalAddressList.CustomerAdditionalAddress.PersonInfo.City

    Namespace: getConsumerCustomerList_input
    Path: Customer.CustomerContactList.CustomerContact.CustomerAdditionalAddressList.CustomerAdditionalAddress.PersonInfo.City


  3. Add the attribute City to the mashup id getBusinessCustomerList.

[{"Product":{"code":"SS6PEW","label":"Sterling Order Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Documentation","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
11 February 2020

UID

swg22014271