Custom Function Example

SQL

SELECT REGEXP_REPLACE(CSUSER01.USERNAME,?,?) AS USERNAME01 
FROM CSUSER CSUSER01 
WHERE 1=1

XML query API

<query alias="testRegexpReplace" projectedClass="com.taleo.akirademo.entity.Candidate"> 
    <projections> 
        <projection> 
            <customFunction name="REGEXP_REPLACE"> 
                <field path="username"/> 
                <string>a</string> 
                <string>b</string> 
            </customFunction> 
        </projection> 
     </projections> 
</query>