PDF Template Sorting of child records

[rinorway]

How do you sort child records in a PDF template?

Eg : I want to order the items of default sales order on the name.

<!-- {{#each itemList}} --> <tr>
<td>{{order}}</td>
<td>{{name}}</td>
<td>{{quantity}}</td>
</tr>
<!-- {{/each}} -->

doc : https://docs.espocrm.com/user-guide/printing-to-pdf/
possibly you can use the index helper of handlebars

https://handlebarsjs.com/guide/builtin-helpers.html#each

but it is not clear how that would work in this context.

Thank you,

[item]

Hello,

for me, in entityManager.. you have orderBy field .. and i think pdf template take this parameter for order.

Regards

[rinorway]

Yes, I can confirm that is correct indeed. Thank you.

[rinorway]

In addition you might use custom template helpers as described in

https://docs.espocrm.com/development/template-custom-helper/

Eg : From a contact, give a list of meetings ordered by startdate

public static function dumpMeetingItems()
{
$args = func_get_args();
$context = $args[count($args) - 1];
$hash = $context['hash'];
$data = $context['data']['root']['meetings'];

// sort the meetings on date
$key='dateStart';
usort($data, function ($a, $b) use ($key) :int {
return $a[$key] <=> $b[$key];
});

$html = "<ul>";
foreach($data AS $key => $value) {
   $html.="<li>".$value['dateStart']."-".$value['name']</li>";
}
$html.= "</ul>";
return new LightnCandy\SafeString($html);
}