Search

How do I include a contact's middle name in the Contact Search in OSvC?

For Contact objects within Oracle Service Cloud, there are 2 fields for contact names by default – ‘First Name’ and ‘Last Name’. If your implementation requires use of a middle name, you can customize the contact search using below steps:

1. Create a custom attribute for Contact object from Object Designer for the middle name field, save & deploy the changes.
   
   Eg: CO$MiddleName
   
   
   
    
2. Add this contacts.CO$MiddleName field to your contact workspaces, so that middle name can be added when contacts are created

3. Find the search report that you use for the Contact field from the workspace. To get this, open the workspace which you are using for the profile from the workspace designer. Select the contact field à Click on ‘Search Report’ from Options in the ribbon. This will open a ‘Select Report’ dialog where the search report will be selected.
   

4. From Reports Explorer, take a copy of the Contact Search report identified in step 2 and edit the report definition for the same as explained in below steps.
5. Add a new column as the first column in the report. This column will be a concatenated value of the First Name and Middle Name fields. Use below expression as the Expression for this column:

concat(concat(contacts.first_name,’ ‘),nvl(contacts.CO$MiddleName,’ ‘))

6. Make the 1st column created in above step as hidden
7. Modify the expression for the current 2nd Column: Last Name as below
   contacts.last_name || ‘ ‘
   
   
   
    
8. You could optionally have the middle name column anywhere in the search report
   
   
   
    
9. You could optionally keep the first name column anywhere in the search report, but the expression should be modified as below
   contacts.first_name || ‘’
   
   
    
10. Make sure none of the columns in the search report has an expression that is the exact First Name(contacts.first_name) or Last Name(contacts.last_name). This could interfere with the expected behavior for the search report.
11. The first filter for this report should remain as Contact Last Name itself
12. Save the report definition
13. Assign this report as the contact Search Report for Contact field from the workspace designer

Now when you search for a contact with last name from Browser UI, the search results will display all contacts that match with the last name, along with their middle names. An example is given below:

The 1^st column here can be hidden, since this it is added only for the search purpose

Please note that the ‘intl_nameorder’ config will be honored here. If disabled, the first name is displayed first, followed by the last name. If enabled, the last name is displayed first, followed by the first name. In above example, it is disabled.