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.
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 ?
read here
with list=”10″ i can read only 10 raws, but i have 187 raws to read and view
[cfdb-datatable] has a dt_options where datatable 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.
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
and the “10” in the View would be the default value, nor “All“.
[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>
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
dt_options="'iDisplayLength':10"
