[Guide Tip] Add sorting to your tables in Guide

Amy Gracer

• 10. Januar 2020 18:53

Community Moderator

You can add sorting to your HTML tables in guide using the Jquery TableSorter plug-in. Although this script includes many options and customizations, only basic sorting is described below for simplicity. 

 

I used the download and documentation provided on the following site: Sorting Tables with Tablesorter. There are many other resources as well. Review the documentation and download the tablesorter-master.zip. 

 

Now you can modify your Help Center.

1. First, edit your theme and add the following plug-in assets:
   • jquery.tablesorter.js
   • theme.blue.css (or whatever theme you choose)

   To learn how to add assets, see Using your own theme assets. 

2. Next you need to instruct Zendesk to use the tablesorter plug-in for all of your tables.
   1. Edit your theme. 
   2. Open the template document_head.hbs.
   3. Under your stylesheet links, add the following lines, and save. 

      <script src="{{asset 'jquery.tablesorter.js'}}"></script>
      
      <link rel="stylesheet" href="{{asset 'theme.blue.css'}}">

      

3. Now under assets, open your Script.js file, and add the following:

   //table sort
   $(function(){ $('table').tablesorter();
   theme: 'blue' });

   This will apply sorting to all tables.

4. At this point, tables will sortable, but there will be no visual indication that the sorting is available. To add these visual cues, you must apply the tablesorter class your table as follows:

   <table class="tablesorter tablesorter-blue">

   Notice the sorting arrows in the column headers. 

    

 

 

• Jennifer Rowe

  • 10. Januar 2020 22:10

  Zendesk Documentation Team

  That is a really great tip, Amy! Thanks for sharing it!

• Lawrence Lane

  • 27. Mai 2020 15:55

  I'm trying to reproduce table sorting in Guide and can only get the CSS stylings/ highlight-on-hover to render. The sort buttons and actions won't render. I've enabled display unsafe content, uploaded assets, and added the scripts to document_head.hbs. Does this still work today? Any advice? Thanks

• Amy Gracer

  • 27. Mai 2020 19:19

  Community Moderator

  Hi Lawrence,

  I think the problem is the Table class. Make sure that in your HTML source, you have set 

  <table class="tablesorter tablesorter-blue">

  If you do not, your table will look like this:

  

   

  After adding the class, it looks like this:

  

  The HTML of the table above is

  <table class="tablesorter tablesorter-blue">
  <thead>
  <tr>
  <th>Alph</th>
  <th>Numeric</th>
  <th>Date</th>
  <th>&nbsp;</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>b</td>
  <td>2</td>
  <td>5/12/2020</td>
  <td>&nbsp;</td>
  </tr>
  <tr>
  <td>d</td>
  <td>1</td>
  <td>1/12/2019</td>
  <td>&nbsp;</td>
  </tr>
  </tbody>
  </table>

   

• Thom Scholten

  • 2. September 2020 07:10

  Dear Amy,

  I have a question regarding step 3:

  Don't you mean the already implemented script.js file? I believe it isn't located in the asset folder.

  Thanks.

• Thom Scholten

  • 2. September 2020 08:15

  The reason for the question is the fact that I don't seem to get the sorting function after having implemented all the abovementioned steps, see below image.

  

• Amy Gracer

  • 2. September 2020 11:12
  • Bearbeitet

  Community Moderator

  Thom Scholten

  Yes, you are correct. The script.js file is the default one that is not located in the assets folder.

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.