XML Publisher Tags
We can use below XML tags as per the requirement.
1. Greatest : <?xdofx:greatest ( expr [, expr]… )?>
2. Length : <?xdofx:length(char)?>
3. Least : <?xdofx:least ( expr [, expr]… )?>
4. Upper : <?xdofx:upper(char)?>
5. Lower : <?xdofx:lower (char)?>
6. Ceil : <?xdofx:ceil(n)?>
7. Round : <?xdofx:round ( number [, integer ])?>
8. Mininum : <?xdoxslt:minimum(COLUMN_NAME)?>
9. Max : <?xdoxslt:maximum(COLUMN_NAME)?>
10. Sysdate : <?xdofx:sysdate()?>
11. To Date : <?xdofx:to_date ( char [, fmt [,'FORMAT']] )
12. To Num : <?xdofx:to_number('12345')?>
13. To Char : <?xdofx:to_char('12345')?>
14. Replace : <?xdofx:replace(name,'Dinesh','Dinu')?>
15. Substring : <?xdofx:substr('abcdefg',2,3)?>
16. Instring : <?xdofx:Instr('abcabcabc','a',2)?>
17. Decode : <?xdofx:decode('YYY','AAA','BBB','xxx','ddd')?>
18. RPad : <?xdofx:rpad(‘aaa’,10,’.’)?>
19. LPad : <?xdofx:lpad(‘aaa’,10,’.’)?>
20. Calculations
Addition : <?xdofx:1+3?>
Subtraction : <?xdofx:1-3?>
Multiplication : <?xdofx:1*3?>
Division : <?xdofx:1/3?>
Concatenation : <?xdofx:1||2?>
21. URL : XSL Syntax: <xsl:import href="url">
BI Publisher Tag: <?import:url?>
22. Variable Declaration : XSL Syntax: <xsl:variable name="name">
BI Publisher Tag: <?variable:name?>
<xsl:variable name="color" select="'red'"/>
23. Date Formatting:
<?format-date:date_string;'ABSTRACT_FORMAT_MASK';'TIMEZONE'?>
or
<?format-date-and-calendar:date_string;
'ABSTRACT_FORMAT_MASK';'CALENDAR_NAME';'TIMEZONE'?>
or
<?format-date:hiredate;'YYYY-MM-DD'?>
24. Number Formatting:
<?format-number:fieldname;'999G999D99'?>
25. Columns to Repeat Across Pages
<?horizontal-break-table:number?>
26. Dynamic Data Columns
Dynamic Column Header
<?split-column-header:group element name?>
Dynamic Column
<?split-column-data:group element name?>
Dynamic Column Width
<?split-column-width:name?> or
<?split-column-width:@width?>
Dynamic Column Width’s unit value (in points)
<?split-column-width-unit: value?>
27. Page Totals
<?add-page-total:TotalFieldName;'element'?>
<?show-page-total:TotalFieldName;'Oracle-number-format'?>
28. Page Breaks
<?split-by-page-break:?>
29. To display Images
url:{concat(‘${OA_MEDIA}’,’/’,IMAGE_FILE)}
or
url:{concat(SERVER,’/’,IMAGE_DIR,’/’,IMAGE_FILE)}
or
<?shape-size-x:RATIO?>
<?shape-size-y:RATIO?>
30. Grouping
<?for-each:XML group element tag name?>
<?end for-each?>
31. For Loop
<?for-each:XML group element tag name?>
<?end for-each?>
32. If Statement
<?if:LINE_TYPE=’LINE’ ?>
<?end if?>
33. Custom Message
<?if:CS_CNT_ORD =0?>*****NO DATA FOUND****<?end if?>
34. Conditional Block highlight
<?if:XML_ELEMENT>Value?>
<xsl:attribute xdofo:ctx=”block” name=”background-color”>COLOR
</xsl:attribute>
<?end-if?>
0 Comments