Textual search not working in CDS

[anthonysc]

Hello,

In one of our CDS, we use a field "Fund" with an attribute "Responsible". We use this CDS in a SAC live connection. The idea of the attribute "Responsible" is to be able to search a list of Fund by searching through a name. Unfortunately, the search doesn't work : lets say we have a "responsible" call Tony Montana. If we search with Tony or any other kind of textual search, no funds are listed. If we search with the exact name, funds are listed with responsible Tony Montana. We would like to be able to search with any textual typing like any other fields.

We did several tests without success :

First test :

Making the field searchable :

Second test :

Creating a cds ZI_fundresp and doing the association in ZI_Fund

Third test :

Creating ValueHelp Cds and doing the association in ZI_Fund

If you have any idea of what we did wrong, please advice us.

Thanks in advance

Best regards

[listat · Accepted solution]

Hello Anthony,

In your first and third examples threshold value is commented. As SAP documentation suggests:

Possible values are: 0..1 The default value is 1. The fuzzy search algorithm calculates a fuzzy score for each string comparison. The higher the score, the more similar the strings are. A score of 1.0 means the strings are identical. A score of 0.0 means the strings have nothing in common.

Maybe also your annotations applied not in correct place. Not sure if you need fuzzy search to be implemented in main filters on ListReport level or inside Value Help.

You can have a look at standard CDS, for example I_Plant, and test if it works for you.

Lastly, did you clean cache and check SAP Notes?

2319491 - How to clean up the cache after applying changes that affect SAP Fiori apps

3112759 - Fuzzy search not working in the whole system

Kind regards,

Tatjana

[anthonysc · Accepted solution]

Hello Tatjana,

thanks for your answer. It helps a lot and point out on missing annotations.Now it works.

best regards