BI Publisher Function Listing v1
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABCDEF
1
FunctionDescriptionExampleResult
2
<?xdoxslt:abs(NUMBER)?>Return absolute value of number<?xdoxslt:abs(-123.45)?>123.45
3
<?xdoxslt:current_date('DD-MM-YYYY')+1?>Retrieve current date (YYYY-MM-DD)<?xdoxslt:current_date($_XDOLOCALE, $_XDOTIMEZONE)?>2011-11-11
4
<?xdoxslt:current_time($_XDOLOCALE, $_XDOTIMEZONE)?>Retrieve current time<?xdoxslt:current_time($_XDOLOCALE, $_XDOTIMEZONE)?>12:30:44 PM
5
<?xdoxslt:date_diff(RESULT, FROM_DATE, TO_DATE, $_XDOLOCALE, $_XDOTIMEZONE)?>Determine difference between dates<?xdoxslt:date_diff(‘m', ‘2010-07-30’, ‘2010-12-31’, $_XDOLOCALE, $_XDOTIMEZONE)?>5
6
<?xdoxslt:foreach_number($_XDOCTX, 1, ITERATIONS, 1)?>Used in conjunction with for-each loop<?for-each:xdoxslt:foreach_number($_XDOCTX, 1, $iterations, 1)?>-
7
<?xdoxslt:format_number(NUMBER, DEC_PLACES, $_XDOLOCALE)?>Format number<?xdoxslt:format_number(12345, 2, $_XDOLOCALE)?>12,456.00
8
Format number with custom separators<?xdoxslt:format_number(12345, 3, '.', 'x', $_XDOLOCALE)?>12.456x000
9
<?xdoxslt:get_array($_XDOCTX, TABLE_NAME, INDEX)?> Retrieve value from hash table<?xdoxslt:get_array($_XDOCTX, ‘MyTable’, 2)?> 'Test'
10
<?xdoxslt:get_day(DATE, LOCALITY)?>Get current day<?xdoxslt:get_day(‘2010-07-29’, 'Australia/Brisbane')?>29
11
<?xdoxslt:get_month(DATE, LOCALITY)?>Get current month<?xdoxslt:get_month(‘2010-07-29’, 'Australia/Brisbane')?>7
12
<?xdoxslt:get_variable($_XDOCTX, VAR_NAME)?>Get value<?xdoxslt:get_variable($_XDOCTX, 'test')?>'Hello'
13
<?xdoxslt:get_year(DATE, LOCALITY)?>Get current year<?xdoxslt:get_year(‘2010-07-29’, 'Australia/Brisbane')?>2010
14
<?xdoxslt:ifelse(EXPRESSION, TRUE, FALSE)?>Conditional Statement<?xdoxslt:ifelse(a = b, 'Equivalent', 'Mismatch')?>-
15
<?xdoxslt:init_cap(STRING)?>Convert initial characters to capitals<?xdoxslt:init_cap('this is a test')?>This Is A Test
16
<?xdoxslt:left(STRING, LENGTH)?>Extract beginning portion of string<?xdoxslt:left(‘abcdefg’, 3)?>'abc'
17
<?xdoxslt:ltrim(STRING)?>Removes leading white space in string<?xdoxslt:ltrim(‘ a ‘)?>'a '
18
<?xdoxslt:maximum(ELEMENT_NAME)?>Retrieve largest value from element<?xdoxslt:maximum(Gross_Claims_ID24)?>253456
19
<?xdoxslt:month_name(MONTH_NUM, ABBREVIATE, $_XDOLOCALE)?>Retrieves name of specified month<?xdoxslt:month_name(1, 0, $_XDOLOCALE)?>'January'
20
<?xdoxslt:minimum(ELEMENT_NAME)?>Retrieve smallest value from element<?xdoxslt:minimum(Gross_Claims_ID24)?>-
21
<?xdoxslt:next_element(GROUP, ., ELEMENT_NAME)?>Retrieves subsequent element in group<?xdoxslt:next_element(current-group(), ., Pay_ID21)?>
22
<?xdoxslt:pat_format_number(NUMBER, FORMAT, $_XDOLOCALE)?>Format number with pattern<?xdoxslt:pat_format_number(12345, ‘##,##0.00’, $_XDOLOCALE)?>12,345.00
23
<?xdoxslt:prev_element(GROUP, .., ELEMENT_NAME)?> Retrieves previous element in group<?xdoxslt:prev_element(current-group(), .., Pay_ID21)?>
24
<?xdoxslt:replace(STRING, OLD_CHAR, NEW_CHAR)?>Replace consecutive characters<?xdoxslt:replace(‘Mist’, ‘Mi’, ‘Te’)?>Test
25
<?xdoxslt:replicate(STRING, NUM_REPS)?>Replicate string<?xdoxslt:replicate(‘String’, 3)?>'StringStringString'
26
<?xdoxslt:right(STRING, LENGTH)?>Extract end portion of string<?xdoxslt:right(‘abcdefg’, 3)?>'efg'
27
<?xdoxslt:round(NUMBER [, DECIMALS])?>Round number<?xdoxslt:round(4.56 , 0)?>5
28
<?xdoxslt:rtrim(STRING)?>Removes trailing white space in string<?xdoxslt:rtrim(‘ a ‘)?>' a'
29
<?xdoxslt:sec_diff(FROM_TIME, TO_TIME, $_XDOLOCALE, $_XDOTIMEZONE)?>Determine difference between times<?xdoxslt:sec_diff(‘2000-04-08T20:00:00’, ‘2000-04-08T21:00:00’, $_XDOLOCALE, $_XDOTIMEZONE)?>3600
30
<?xdoxslt:set_array($_XDOCTX, TABLE_NAME, INDEX, STORE_VAL)?> Store value in hash table<?xdoxslt:set_array($_XDOCTX, ‘MyTable’, 2, ‘Test’)?> -
31
<?xdoxslt:set_variable($_XDOCTX, VAR_NAME, VALUE)?>Declare and assign value to variable<?xdoxslt:set_variable($_XDOCTX, 'test', "'Hello'")?>-
32
<?xdoxslt:truncate(NUMBER [, DEC_INT])?>Truncate number to specified decimals<?xdoxslt:truncate(2.6789, 2)?>2.67
33
<?xdoxslt:trim(STRING)?>Removes white space in string<?xdoxslt:trim(‘ A ‘)?>'A'
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
XDOXSLT
MAIN
XSL
DATE_MASK
XDOFX
Dynamic Image
XPATH Notations
FO