Show the highest number

Hi John,

Assuming you have a "Points" field in CMS Builder for each House, you can have the Houses sorted by the highest to lowest by using the the Sort order in the CMS Builder admin or add it directly into the frontend template.

Sort in CMS Builder:
Go to Admin > Section Editors > Houses.
Click on the Sorting tab and add points+0 DESC
This will sort the Houses by Points, highest to lowest in both the CMS Builder admin and the published frontend page.

You can also do a custom sort just on the publish page if you don't want the CMS Builder admin sorted in the same way. To do this, add the orderBy code to your page:

'orderBy' => 'points+0 DESC',

More details here:
http://www.interactivetools.com/docs/cmsbuilder/viewer_options.html

Hope this helps!

Try something like this if you want just the top leader:  (You will need to substitute your variables for table and field names)

<?php // load the top points records assuming you only want the top leader
  list($houseRecords, $houseMetaData) = getRecords(array(
    'tableName'   => 'house', // or whatever the table name is
        'orderBy' => 'points+0 DESC' // bring highest points to top   
        'limit'       => '1',
    'allowSearch' => false,
  ));
  $topRecord = @$houseRecords[0]; // get first record only
?>
<div class="some-wrapper">
  The leaders are <?php echo $topRecord['name'] ?> with <?php echo $topRecord['name'] ?> points.
</div>

Thank you for your help.

It works a treat.

Happy to help!