SUBSTR_REGEXPR is not supported in SAP CAP

[pepl]

Hi! If I have a following construction , it cannot compile in CAP

Could you please check on your side if this framework can work with this function?

Thanks!

[steffen_weinstock · Accepted solution]

CAP CDS currently doesn't support the SUBSTR_REGEXPR(...) function. The same holds true for the other ..._REGEXPR functions. We plan to add support for them somewhen later this year.

UPDATE: HANA Regex functions are supported starting with cds-compiler 3.1.

[pepl · Accepted solution]

Thank you for confirming this Steffen. It would be really nice. Like with window functions - bringing them to CDS directly made our code more stable and consistent. We'll keep using then hdbview + synonym + @cds.persistence.exists workaround for regexp functions and checking for release udpates from time to time. Best regards. Petr