Skip to Content
-1
Jun 16, 2022 at 04:41 PM

CAP JAVA: Query with booleanFunc("LIKE_REGEXPR") is not working in SAP HANA

274 Views Last edit Jan 18, 2023 at 06:35 PM 2 rev

Hi colleagues

I found an example in documentation https://cap.cloud.sap/docs/java/query-api#using-functions-and-arithmetic-expressions

of using the following query

Select.from("bookshop.Books").where(booleanFunc("LIKE_REGEXPR", singletonList(val("Raven|Eleonora"))));

I have a CAP java app and tried to use booleanFunc("LIKE_REGEXPR") but it does not work in SAP HANA db.

Example of my query

Select.from("bookshop.Books").where(i -> booleanFunc("LIKE_REGEXPR", Arrays.asList(i.get("title"), val("item")))

Does anyone know about this issue ?

Thanks in advance