How to sort data in an etext outbound template.
I created a etext outbound template to print a separate remittance.Here is the part of the rtf file I modified.
|
<LEVEL>
|
DATA_PSL
|
||||
|
<SORT ASCENDING>
|
Col6, col7, col8
|
||||
|
<POSITION>
|
<LENGTH>
|
<FORMAT>
|
<PAD>
|
<DATA>
|
<COMMENTS>
|
|
<NEW RECORD>
|
Ligne_30
|
||||
|
1
|
11
|
Date,
DD-MM-YYYY
|
R, ’ ‘
|
Col1
|
|
|
12
|
12
|
Alpha
|
R, ’ ‘
|
Col3
|
|
|
24
|
5
|
Alpha
|
R, ’ ‘
|
Col4
|
|
|
29
|
6
|
Alpha
|
R, ’ ‘
|
Col5
|
|
|
35
|
23
|
Alpha
|
R, ’ ‘
|
Col6
|
|
|
58
|
5
|
Alpha
|
|
Col7
|
|
|
63
|
10
|
Date,
DD-MM-YYYY
|
R, ’ ‘
|
Col8
|
|
|
73
|
10
|
Number,
######0.00
|
L,’ ‘
|
Col9
|
|
Then, I modified IBY_FD_EXTRACT_EXT_PUB.get_doc_ext_agg function
to add a new level detail within DocumentPayable level.
SELECT XMLCONCAT (XMLAGG (XMLELEMENT ("DATA_PSL",
XMLELEMENT ("col1", IBY.DOCUMENT_DATE),
XMLELEMENT ("col2", PV