XSL Template

How To Group data in XSL

Requirement is to list employee's birthday per below 
Date Of Birth|<List of all employee number in seperated by comma>
<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:exsl="http://exslt.org/comon" xmlns:xs="http://www.w3.org/2001/XMLSchema" extension-element-prefixes="exsl xs"> <xsl:output omit-xml-declaration="yes" indent="yes" method="text"/> <xsl:strip-space elements="*"/> <xsl:variable name ="newline" select = "'&#10;'"/> <xsl:template match="/"> <xsl:apply-templates select="DATA_DS"/> </xsl:template> <xsl:template match="DATA_DS"> <xsl:text>DOB,PERSON NUMBER</xsl:text> <xsl:value-of select="$newline"/> <xsl:for-each-group select="//G_1" group-by="LF_EVT_OCRD_DT"> <xsl:variable name="LINE"> <xsl:value-of select="current-grouping-key()"/> <xsl:text>|</xsl:text> <xsl:for-each select="current-group()"> <xsl:value-of select="PERSON_NUMBER"></xsl:value-of> <xsl:if test="not(position() = last())">,</xsl:if> </xsl:for-each> </xsl:variable> <xsl:value-of select="$LINE"/> <xsl:value-of select="$newline"/>






</xsl:for-each-group> </xsl:template> </xsl:stylesheet>













Comments

Post a Comment

Popular posts from this blog

Payroll

  To Get Tax Calculation card effective date   select rgi.effective_start_date   from pay_dir_cards_f dc ,fsion.pay_value_definitions_vl dcd , pay_dir_card_components_f dcomp , pay_dir_card_definitions_vl pdccdt , pay_value_definitions_f pvd , pay_range_items_f rgi where 1=1 and dcomp.dir_card_comp_id = :{PARAMETER.FED_CMP_ID} AND dcd.dir_card_definition_id = dc.dir_card_definition_id and dcd.base_display_name = 'US_EMPLOYEE_WITHHOLDING_CERTIFICATE' and dcd.legislation_code = 'US' and dcomp.dir_card_id = dc.dir_card_id and sysdate between dcomp.effective_start_date and dcomp.effective_end_date and pdccdt.dir_card_comp_def_id = dcomp.dir_card_comp_def_id and pdccdt.base_component_name = 'ORA_HRX_WTH_FEDERAL' and pdccdt.legislation_code = 'US' and pvd.source_id = dcomp.dir_card_comp_id and pvd.source_type = 'PDCC' and sysdate between pvd.effective_start_date and pvd.effective_end_date and rgi.value_defn_id = pvd.value_defn_id and rgi.calc_type_id =...
Read more

Extract/BIP Query

To Schedule HCM Extract  to run Sysdate+1 Log in to the application as an HCM Administrator.   Navigator > Data Exchange > Refine HCM Extracts.   Select the Payroll Flow. On the Manage Payroll Flow Patterns page, go to the Tasks tab, highlight the       appropriate task, and click Edit.  Click the pencil icon below the tabs (Tasks, Task Sequence, Parameters).  Click the Edit pencil icon next to the task that you want to edit.  On the Edit Task Details: Basic Information flow, locate the Effective Date parameter and click on that row.  The Effect Date: Parameter Details region will now show at the bottom of the screen.  In the Effect Date: Parameter Details region, set these parameter values:           Parameter Basis = Post SQL           Use Below query  SELECT NVL((SELECT flow_param_value               FROM ...
Read more