This discussion is archived
0 Replies Latest reply: Oct 18, 2012 11:02 AM by user11177735 RSS

How to call a SQL function from an XSL expression

user11177735 Newbie
Currently Being Moderated
Hi

In R12, in Payroll Deposit adivce/Check writer, We need to sort the earnings tag <AC_Earnings> in to two different categories as regular and other earnings. In the DB and form level of element defintiion we have a DFF which differentiates between the two kinds of earnings. But the seeded XML that is gerneated by the check writer does not have this field.
The seeded template displays all the earnings in one column. How can we achieve this in the template without modifying the seeded XML.

The one approach i have is to write a function and based on the return value sort the data. For this I need to know :

1) How to call a SQL function from an XSL expression that is allowed in BI template.

If anyone ahs faced similar requirements please share your approach.

Thanks
Srimathi

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points