Alphabetical Filter

  • Views Views: 25,155
  • Last updated Last updated:

Navigation

Lists
   Editing a list
      List Filters
      List Joins
      List Pre-filters
      List Related data
   How do I ... Lists
      Filtering lists/tables
   How do I ... Lists Advanced
      Adding a horizontal scrollbar
      Adding a show-hide column feature
      Alphabetical Filter
      Creating a custom list template
      Custom Styling a List
      Display List Filter Horizontally
      Export to CSV - Customizing
      Export to CSV without using dialog
      Override a Specific Field
      Remove a list column
      User ajax in list: Toggle Yes/No-Element
   List delete confirmation (+)
   List Plugins
      Article list plugin (+)
      Can Edit Row list plugin
      Can Select Row list plugin
      Copy list plugin
      Download list plugin
      Email/SMS list plugin
      Filter View list plugin (+)
      Inline Edit list plugin
      Javascript list plugin (+)
      Javascript table plugin
      Link list plugin
      List CSV list plugin
      Lockrow List Plugin
      Order list plugin
      PHP Events list plugin
      PHP list plugin
      Pivot list plugin
      Radius Search list plugin
      SQL Cache list plugin
      Update Columns list plugin
      Webservice list plugin
   pre-filters
   Sorting data

Wiki index

Page

  • Contents

    Fabrik 3.1​

    list-tabs.png

    Edit your list and under the layout tab you will see a Tabs section.
    Select a field you wish to use as the tab filter, and enter the maximum number of tabs to show. Then press save.

    For Fabrik 3.0 or less​

    Follow the instructions below to create an alphabetical list of links that filter a table's data by a column first letter.

    Make a custom table template: Copy the folder components/com_fabrik/views/tmpl/default and rename it to default_alphafilter.

    Then edit default_alphafilter/default.php and after:
    PHP: 
    if ($this->showFilters) {
    
    echo $this->loadTemplate('filter');
    
}?>
    add (Actually, you may add this before or after.. Pretty Much anywhere!!!)
    PHP: 
    <?php
    
    $element = 'element_test___test';
    
    $url = 'http://'.$_SERVER['HTTP_HOST'].'/FULL/PATH';
    
    $letters = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
    
    foreach($letters as $l){
    
        echo "<a href='{$url}?resetfilters=1&".$element."[value]=$l%25&".$element."[condition]=LIKE'>$l</a>";
    
    }
    
?>
    This will print out a row of links filtering on each letter. The only thing you will need to change is
    PHP: 
    $element = 'element_test___test';
    Replace 'element_test' with your table name and 'test' with the element name.

    Also.. to make this work, you will need to replace FULLPATH. This works best with SEF. Then use the url generated for this value.

    In case you would like to use this template for more than one list.. The following might help you out. The following assumes the field you are filtering is the same for all Lists you will use. To make this work, you have to use Menu items that have an alias as the name of your list. SEF is required for this to work.
    PHP: 
    <ul class="alphafilter">
    
<?php
    
    // strip out all stuff and get only the part we need
    
    $uri_parts = explode('?', $_SERVER['REQUEST_URI'], 2);
    
    $url = $uri_parts[0];
    
    $pathparts = explode('/',$url);
    
    $this_list = array_pop($pathparts);
    
    //if popped value is null, there was a trailing slash.. so pop again.
    
    if($this_list == NULL || $this_list == ''){
    
        $this_list = array_pop($pathparts);          
    
    }
    
    $element = 'fab_'.$this_list.'___name';
    
    $letters = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
    
    foreach($letters as $l){
    
        echo "<li><a href='{$url}?resetfilters=1&".$element."[value]=$l%25&".$element."[condition]=LIKE'>$l</a></li>";
    
    }
    
?>
    
    <li><a href="<?php echo ($url); ?>">Show ALL</a></li>
    
</ul>

    If you have the field in the filter, that you are using for the index, LastName for instance, you will see, after clicking on a letter that the filter for the LastName field will have that letter plus the % char. the % in sql is for WILDCARD.

    You can remove the % buy doing a substr on the $filter. On the alpha index, you probably will only have this one filter. The following will not work if you are using more than one filter. It will remove the last char from every filter. This would probably be undesirable. This change is made in the default_filter.php template file.
    PHP: 
    <?php echo substr($filter->element,0,1);?>

    Note: If you would like to still FILTER the results, then you must set resetfilters=1 to 0 or just take it out.

    ----------------------------------------

    An alternative to this is to create a calculated field with the first character of the field you want to select by putting the following in the Calculation box:
    PHP: 
    return substr("{placeholder}",0,1);

    You can then set this as a default group-by box for your list and you will then get the ability to open or close each group.

    Note: This needs to load all rows in your table, so you will need to set the number of rows displayed to >= number of rows in the table, and it is not really scalable for more than several hundred rows.
Back
Top