Title: Default #rows displayed
Last modified: August 22, 2016

---

# Default #rows displayed

 *  [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * (@goldenhawk2011)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/)
 * This plugin I was fully satisfied and he solved a problem I had displaying old
   archives.
    It works perfectly, just i wish that the display of data in the table
   did not show “All” records but only “10” or “25”. How should I act? thanks
 * [https://wordpress.org/plugins/contact-form-7-to-database-extension/](https://wordpress.org/plugins/contact-form-7-to-database-extension/)

Viewing 9 replies - 1 through 9 (of 9 total)

 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462302)
 * You can control the number of records shown on the administration page by setting
   an option in the plugin’s Options page.
 * In short codes, you can use limit=”10″ to limit the number of rows shown.
 *  Thread Starter [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * (@goldenhawk2011)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462305)
 * Thanks Michael.
 * [added]
    excuse me, Michael, I’ve tried to insert limit=10, but i can read only
   10 rows of all rows. I would have “10” or “25” (in “View ‘All’ elements”) as 
   default visualisation but ALL the rows have to remain readables paginated (scollables).
   I bag your pardon for my wrong english language.
 * [added]
    I think i’have to set DataTable parameter. If so, how ?
 *  Thread Starter [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * (@goldenhawk2011)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462306)
 * [read here](http://www.comprensivoleopardi.gov.it/archivio-storico)
 * with list=”10″ i can read only 10 raws, but i have 187 raws to read and view
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462308)
 * [cfdb-datatable] has a [dt_options](http://cfdbplugin.com/?page_id=91#dt_options)
   where [datatable](http://datatables.net/) options can be added in JSON.
 * To set the datatable length choices, you would add:
    “aLengthMenu”: [[10,25,-
   1], [10,25,”All”]]
 * But this will not work in the short code because the extra “[]” characters will
   confuse WordPress.
 * To make the datatable as you like, you would need to use [cfdb-table id=”yourtable”]
   and manually add Javascript in the page to make #yourtable into a datatable with
   the options you like. If you look at the HTML source of the administration page
   you can see what this looks like.
 *  Thread Starter [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * (@goldenhawk2011)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462320)
 * Hi Michael,
    I’ve generated shot-code as:
 *     ```
       [cfdb-datatable form="Upload vecchi documenti" show="text-584,text-224,text-231,file-575" hide="Submitted,text-662,Submitted Login,Submitted From,submit_time" headers="text-584=Area,text-224=Data pubblicazione,text-231=Descrizione,file-575=link download" dt_options="[cfdb-datatable id=page_custom_view]"][/cfdb-datatable]
       ```
   
 * but i’ve not understood where i’ve to insert my own code:
 *     ```
       #page_custom_view
       "aLengthMenu": [[10,25,-1], [10,25,"All"]]
       ```
   
 * can you help me?
 * [added]
    definetively, i’d like to show the table as shown below: [read here](http://www.comprensivoleopardi.gov.it/wp-content/uploads/2014/11/default_view.png)
   and the “**10**” in the **View** would be the default value, nor “**All**“.
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462326)
 *     ```
       [cfdb-table form="Upload vecchi documenti" show="text-584,text-224,text-231,file-575" hide="Submitted,text-662,Submitted Login,Submitted From,submit_time" headers="text-584=Area,text-224=Data pubblicazione,text-231=Descrizione,file-575=link download" id=page_custom_view"][/cfdb-table]
   
       	<script type='text/javascript' src='http://YOUR-SITE/wp-content/plugins/contact-form-7-to-database-extension/DataTables/media/js/jquery.dataTables.min.js?ver=4.0'></script>
   
       <script type="text/javascript" language="Javascript">
                       jQuery(document).ready(function() {
                           jQuery('#page_custom_view').dataTable({
                               "bJQueryUI": true, "aaSorting": [], "iDisplayLength": 10, "aLengthMenu": [[10,25,-1], [10,25,"All"]] })
                       });
                   </script>
       ```
   
 *  Thread Starter [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * (@goldenhawk2011)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462334)
 * does not work … maybe I expressed myself badly because I do not put you in a 
   position to understand what really I wanted.
    I think it was much simpler than
   it has been interpreted. I just wanted that at page opened first time, in the“
   VIEW” did not appear “ALL” but “10”, with 10 rows shown on total of 178, and 
   with the possibility, after, to select “25”, “50,” 100 “or” All “… that’s all!
   Bye
 *  Plugin Author [Michael Simpson](https://wordpress.org/support/users/msimpson/)
 * (@msimpson)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462340)
 * `dt_options="'iDisplayLength':10"`
 *  Thread Starter [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * (@goldenhawk2011)
 * [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462343)
 * ok, thanks.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Default #rows displayed’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-7-to-database-extension_ffffff.
   svg)
 * [Contact Form DB](https://wordpress.org/plugins/contact-form-7-to-database-extension/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-7-to-database-extension/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-7-to-database-extension/reviews/)

 * 9 replies
 * 2 participants
 * Last reply from: [goldenhawk2011](https://wordpress.org/support/users/goldenhawk2011/)
 * Last activity: [11 years, 7 months ago](https://wordpress.org/support/topic/default-rows-displayed/#post-5462343)
 * Status: not resolved