Symptom
Filter by multiple values in data import & export tool does not work.
Environment
- SAP Service Cloud v2
- SAP Sales Cloud v2
Reproducing the Issue
- Go to Data Import & Export view.
- Click on export.
- Select an Entity.
- Select file type.
- Click on Filter button.
- Click on Define conditions.
- Set Condition type and select the field name.
- Set condition to 'Is any of'.
- Paste the multiple values. Make sure to set the values are between commas, without space. Example: 12345,54321,12121
- Click on Done.
- Click on Apply filter.
- Notice it shows the total number of records and filter was not applied.
Cause
In Network trace (developer tools) it will show HTTP Status 400. Browsers have a maximum URL length they can handle.
Resolution
If the URL exceeds the browser limit, the browser will fail to process it correctly. Please adjust the number of values to be filtered accordingly.
Keywords
Filter, Data Import, Export, Multiple, Inline, Comma , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To
Product
SAP Sales Cloud and SAP Service Cloud Version 2 1.0