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
- Go to Customers work center.
- Go to Accounts view.
- Click on Advanced search icon.
- 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
- Enter Account ID 98765(where 98765 is the Account ID of an existing Account which does not have the above mentioned Marketing Attributes).
- Click on Go.
- 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.
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.
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
Attachments
AND.png |
OR.png |