Fuzzy search in HANA CDS

[former_member185171]

Hi,

we are new in using CDS and certainly directly on HANA.

Can anyone give us some help on how to make on to do a full text search (FUZZY)?

Up to now we use native SQL to do this, but we want to get rid of that.

So now we want: HANA-CDS to external view in ABAP and use this in Open SQL in ABAP.

I don't find any real hints in the documentation, that is why I ask it here.

Thanks for helping.

Kris

[Former Member]

Hi,

What is the version of HANA that you are using?

The HANA CDS guide below explains well the CDS annotations and concepts supported

http://help.sap.com/hana/SAP_HANA_Core_Data_Services_CDS_Reference_en.pdf

Note: Features supported depends on which HANA version you are.

Thank you.

Anjali.

[former_member185171]

Hi.

We have the developer's guide, but there is nowhere any reference to the CONTAINS predicate in SQL. I was hoping someone might have some experience with it.

Thanks a lot.

Kris

[Former Member]

Hi Experts,

any solution for the above question ?

I am also looking for fuzzy search  with CONATINS predicate in CDS view .

Appreciate your reply.

thank you

Vinuta