SAP Knowledge Base Article - Public

2615986 - Filtering of Document does not Yeild Expected Results

Symptom

Filtering of any Document that has symbol "-" in its ID is not giving you expected results.

Environment

SAP Business ByDesign

Reproducing the Issue

The below steps are just an example of one of the cases

  1. Go to Cost and Revenue work center
  2. Click on Projects view
  3. Search for project A-XYZ
  4. Select it and click on Project Plan values button
  5. Then click on filter button and enter project task A-XYZ:P
  6. And click on enter button


You expect only task A-XYZ:P to appear
however ,you will see many tasks that start with A.

Cause

This is the desired behavior as per the development done currently. That is "-" is used as a delimiter.

It is expected that column filter with value containing "-" will be split based on "-".
So system will consider it as "A*" and gives you the results.

Also, any change to the existing behavior of system will break the existing use cases and hence developers are not going to make changes to this behavior.

Resolution

Please  replace "-" with "*"

In this example "A*XYZ:P" has to be used to get the exact filter result.

This is applicable for all document ID's where symbol "-" is apppearing.

Keywords

Filtering is not working, filtering is not proper,filtering is giving wrong results,filtering isgiving many unneccessary results , KBA , AP-PRO , Project Processing , How To

Product

SAP Business ByDesign all versions