How to group and sort items in advanced pdf template

Group items by club type and sort  club subtype. like,

My current items be like,

Club Type       Club Sub Type

Wood                  wood5

Wood                   wood2

Wedge                 wedge3

Wedge                 wedge7

Putter                   putter6

Putter                    putter4

Iron                        iron8

Iron                         iron1

 

I want like,

Wood   wood2, wood5

Wedge wedge3, wedge7

Putter putter4, putter 6

Iron      iron1, iron8

 

Plese help!

Below is item table

<table style=”width: 100%; margin-top: 10px;”><!– start items –><#list record.item as item><#if item_index==0>
<thead>
<tr>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>${item.quantity@label}</span></th>
<th align=”center” colspan=”3″><span style=”font-size:8px;”>BUILD</span></th>
<th align=”center” colspan=”4″><span style=”font-size:8px;”>ITEM</span></th>
<th align=”center” colspan=”5″><span style=”font-size:8px;”>CLUB<br/>TYPE</span></th>
<th align=”center” colspan=”5″><span style=”font-size:8px;”>CLUB<br/>SUB<br/>TYPE</span></th>
<th align=”center” colspan=”10″><span style=”font-size:8px;”>HEAD</span></th>
<th align=”center” colspan=”10″><span style=”font-size:8px;”>SHAFT</span></th>
<th align=”center” colspan=”10″><span style=”font-size:8px;”>GRIP</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>GRIP SIZE</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>${item.custcol_pure@label}</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>LEN</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>${item.custcol_bpm_cwo_lie@label}</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>${item.custcol_bpm_cwo_loft@label}</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>TIP</span></th>
<th align=”center” colspan=”2″><span style=”font-size:8px;”>SW</span></th>
<th align=”center” colspan=”8″><span style=”font-size:8px;”>${item.custcol5@label}</span></th>
</tr>
</thead>
</#if><tr style=”background-color: ${((item_index % 2)==0)?string(‘#ffffff’, ‘#e3e3e3’)};”>
<td align=”center” colspan=”2″ line-height=”150%” style=”height: 25px;”><span style=”font-size:8px;”><b>${record.item.quantity}</b></span></td>
<td align=”center” colspan=”3″ line-height=”150%” style=”height: 25px;”><span style=”font-size:8px;”><b>${item.quantitycommitted}</b></span></td>
<td colspan=”4″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.item}</b></span></td>
<td align=”center” colspan=”5″ line-height=”150%” style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_cc_clubtype_so}</b></span></td>
<td align=”center” colspan=”5″ line-height=”150%” style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_cc_club_subtype_so}</b></span></td>
<td align=”center” colspan=”10″ style=”height: 25px;”><span style=”font-size:9px;”><b>${item.custcol_cc_head_description_so}</b></span></td>
<td align=”center” colspan=”10″ style=”height: 25px;”><span style=”font-size:9px;”><b>${item.custcol_cc_shaft_description_so}</b></span></td>
<td align=”center” colspan=”10″ style=”height: 25px;”><span style=”font-size:9px;”><b>${item.custcol_cc_grip_description_so}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_bpm_cwo_grip_size}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_pure}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_bpm_cwo_length}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_bpm_cwo_lie}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_bpm_cwo_loft}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_bpm_cwo_trim}</b></span></td>
<td align=”center” colspan=”2″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol_bpm_cwo_swing}</b></span></td>
<td align=”center” colspan=”8″ style=”height: 25px;”><span style=”font-size:8px;”><b>${item.custcol5}</b></span></td>
</tr>
</#list><!– end items –></table>

 

 

Beginner Asked on November 24, 2023 in SuiteBuilder.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor