SAP Knowledge Base Article - Public

2698542 - Incorrect Results Are Displayed When Searching Accounts with Marketing Attributes

Symptom

When searching for an Account using advanced search fields 'Marketing Attributes' and 'Account ID' , results are displayed based on OR condition instead of AND.

Environment

SAP Cloud for Customer.

Reproducing the Issue

  1. Go to Customers work center.
  2. Go to Accounts view.
  3. Click on Advanced search icon.
  4. Enter the Marketing Attributes you want to search Accounts with, for example:

         Attribute set - XYZ(XYZ is an Attribute set)
         Attribute - 123(123 is an Attribute)
         Operator - Equal(this is an existing operator, you can use any other operator as well)
         Value - 100

  1. Enter Account ID 98765(where 98765 is the Account ID of an existing Account which does not have the above mentioned Marketing Attributes).
  2. Click on Go.
  3. The results shows all the Account ID's with Marketing Attributes:

        Attribute set - XYZ
        Attribute - 123
        Operator - Equal
        Value - 100

       OR

       Account ID - 98765

Though Account 98765 does not have the Marketing Attributes you are searching with still it is displayed in the results.

The expectation is that if Account ID you are searching with , in this case 98765 has the required Marketing Attributes than only the Account should be displayed in the result.AND condition should be implemented instead of OR , which means if:

        Attribute set - XYZ
        Attribute - 123
        Operator - Equal
        Value - 100

        AND

        Account ID - 98765

Cause

For cases where "AND search is enabled for Marketing Attributes" - you can add AND groups in Marketing Attributes Conditions pop-up.

 AND.png

Once you maintain your Marketing Attribute conditions and click on Go, system evaluates those AND Marketing Attribute conditions and comes out with the Account Id's which match those Marketing Attribute conditions.

These Account Id's are used as selection conditions -just like you provide Account ID selections in advanced search.

Since you are adding a manual Account Id 98765 as selection parameter and then there are some Account Id's coming from Marketing Attributes resolution. All selection parameters for the same field are considered as "OR" conditions and thus you see the Account Id 98765 in the search result.

If you give the Account name as selection parameter instead of Account Id, it will work, as 2 different field conditions are used as "AND" conditions.

OR.png

Resolution

This is the current system behavior since AND search is enabled for Marketing Attributes.

Keywords

AND , OR , marketing attributes, search , KBA , marketing attributes , account , search , and , or , LOD-CRM-BF-BA , Business Attributes , LOD-CRM-ACC , Account , Problem

Product

SAP Cloud for Customer all versions

Attachments

AND.png
OR.png