BI Publisher (MOSC)

MOSC Banner

Sorting on an xdofx field?

edited Jun 26, 2018 2:11PM in BI Publisher (MOSC) 4 commentsAnswered
In my .rft template I'm having to parse a field to have the format of Firstname Lastname and I want to sort on it in the format. 

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center