Sorting on an xdofx field?
I'm trying to use this:
<?sort:(xdofx:SUBSTR(Payee/Name,INSTR(Payee/Name,',',1,1)+1)||' '||SUBSTR(Payee/Name,1,INSTR(Payee/Name,',',1,1)-1))?>
but I keep getting the following error:
Caused by: oracle.xdo.parser.v2.XPathException: Unknown expression at EOF: xsl:sort select = "(SUBSTR(Payee/Name,INSTR(Payee/Name,',',1,1)+1)||' '||SUBSTR(Payee/Name,1,INSTR(Payee/Name,',',1,1)-1)))".
I've tried a variety of diffent methods but keep getting a similar PathException error. What is the correct syntax for sorting on a field like this?