Select to view content in your preferred language

Sorting Fields in a repeat Report Template

555
2
06-05-2024 03:35 PM
DeborahDennison
Emerging Contributor

Hello S123 team mates, I can use some guidance on how to sort fields within a Repeat Section in a Report Template (Word Document). 

Is it possible to use the 'orderByFields' in a repeat section?

Here is the syntax that does not work for sorting:

${#repeat_tree_survey | orderByFields:"tree_tag_id ASC"}

Survey Site:             South Watershed Monitoring

Tree Tag ID:            ${tree_tag_id}

Survey Date:            ${Tree_Survey.survey_date}

Tree Species:           ${tree_species}

${/}

 

Your thoughts and tips are greatly appreciated! 

Debbie

Tags (1)
0 Kudos
2 Replies
abureaux
MVP Frequent Contributor

You can use sorting in the Feature Report just fine for a repeat. See Report templates

${#defects | orderByFields:"state_name ASC, pop2000 DESC"}...${/}

EDIT: forgot to mention, but please ensure that your field (tree_tag_id) is a number and not a number stored as text.

TrafficOpsGIS
Occasional Contributor

Please see screen shot of how to format table in word doc in order to accomplish.

0 Kudos