'Why fn:substring-after Xquery function could not be used inside ML TDE

In my ML db, we have documents with distributor code like 'DIST:5012' (DIST:XXXX) XXXX is a four-digit number.

currently, in my TDE, the below code works well.

enter image description here

However instead of concat all the raw distributor codes, I want to simply concat the number part only. I used the fn:substring-after XQuery function. However, it won't work. It won't show that distributorCode column in the SQL View anymore. (Below code does not work.)

![enter image description here

What is wrong? How to fix that?

Both fn:substring-after and fn:string-join is in TDE Dialect page. https://docs.marklogic.com/9.0/guide/app-dev/TDE#id_99178

xquerymarklogictdemarklogic-10


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions