blocks|key|480704|text|以下是完成此操作的实际代码...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480705|$(document).ready(function()
{
++var+oTable+=+$('#myTable').dataTable();

++//+Sort+immediately+with+column+2+(at+position+1+in+the+array+(base+0).+More+could+be+sorted+with+additional+array+elements
++oTable.fnSort(+[+[1,'asc']+]+);

++//+And+to+sort+another+column+descending+(at+position+2+in+the+array+(base+0).
++oTable.fnSort(+[+[2,'desc']+]+);
}+);|code-block|syntax|javascript|480706|要不突出显示该列，请按如下方式修改CSS：|480707|table.dataTable+tr.odd+td.sorting_1+{+background-color:+transparent;+}
table.dataTable+tr.even+td.sorting_1+{+background-color:+transparent;+}|480708|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Here is the actual code that does it...

<pre><code>$(document).ready(function()
{
 var oTable = $('#myTable').dataTable();

 // Sort immediately with column 2 (at position 1 in the array (base 0). More could be sorted with additional array elements
 oTable.fnSort( [ [1,'asc'] ] );

 // And to sort another column descending (at position 2 in the array (base 0).
 oTable.fnSort( [ [2,'desc'] ] );
} );
</code></pre>

To not have the column highlighted, modify the CSS like so:

<pre><code>table.dataTable tr.odd td.sorting_1 { background-color: transparent; }
table.dataTable tr.even td.sorting_1 { background-color: transparent; }
</code></pre>

blocks|key|480648|text|您可以使用fnSort函数，详情请参见此处：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480649|http://datatables.net/api#fnSort|offset|length|480650|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|W|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

You can use the fnSort function, see the details here:

<a href="http://datatables.net/api#fnSort" rel="noreferrer">http://datatables.net/api#fnSort</a>

blocks|key|696682|text|最好的选择是禁用排序，只按所需的排序顺序(从数据库或其他源)馈送数据。尝试将以下内容添加到您的'datatable'："bSort"：false|type|unstyled|depth|inlineStyleRanges|entityRanges|data|696683|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Best option is to disable sorting and just feed data with desired sort order (from database or other source). Try to add this to your 'datatable': 
 "bSort": false

blocks|key|696723|text|Datatables支持此功能的HTML5+data-*属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|696724|它支持排序顺序中的多个列(从0开始)|696725|<table+data-order="[[+1,+'desc'+],+[2,+'asc'+]]">
++++<thead>
++++++++<tr>
++++++++++++<td>First</td>
++++++++++++<td>Another+column</td>
++++++++++++<td>A+third</td>
++++++++</tr>
++++</thead>
++++<tbody>
++++++++<tr>
++++++++++++<td>z</td>
++++++++++++<td>1</td>
++++++++++++<td>$%25%5E&*</td>
++++++++</tr>
++++++++<tr>
++++++++++++<td>y</td>
++++++++++++<td>2</td>
++++++++++++<td>*$%25%5E&</td>
++++++++</tr>
++++</tbody>
</table>|code-block|syntax|javascript|696726|现在我的jQuery是简单的$('table').DataTables();，第二列和第三列按照desc+/+asc的顺序排序。|offset|length|style|CODE|696727|下面是我发现自己重用的<table>的其他一些很好的属性：|696728|data-page-length="-1"会将页面长度设置为All+(Pass25表示页面长度为25)...|696729|data-fixed-header="true"+...猜猜看|696730|entityMap^0|0|0|0|E|O|0|B|7|0|0|L|0|0|O|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|Z|8|@$K|10|L|11|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@$K|13|L|14|M|N]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@$K|16|L|17|M|N]]|9|@]|A|$]]|$1|S|3|T|5|6|7|18|8|@$K|19|L|1A|M|N]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|V|$]]

Datatables supports HTML5 data-* attributes for this functionality.

It supports multiple columns in the sort order (it's 0-based)

<pre><code>&lt;table data-order="[[ 1, 'desc' ], [2, 'asc' ]]"&gt;
 &lt;thead&gt;
 &lt;tr&gt;
 &lt;td&gt;First&lt;/td&gt;
 &lt;td&gt;Another column&lt;/td&gt;
 &lt;td&gt;A third&lt;/td&gt;
 &lt;/tr&gt;
 &lt;/thead&gt;
 &lt;tbody&gt;
 &lt;tr&gt;
 &lt;td&gt;z&lt;/td&gt;
 &lt;td&gt;1&lt;/td&gt;
 &lt;td&gt;$%^&amp;*&lt;/td&gt;
 &lt;/tr&gt;
 &lt;tr&gt;
 &lt;td&gt;y&lt;/td&gt;
 &lt;td&gt;2&lt;/td&gt;
 &lt;td&gt;*$%^&amp;&lt;/td&gt;
 &lt;/tr&gt;
 &lt;/tbody&gt;
&lt;/table&gt;
</code></pre>

Now my jQuery is simply <code>$('table').DataTables();</code> and I get my second and third columns sorted in desc / asc order.

Here's some other nice attributes for the <code>&lt;table&gt;</code> that I find myself reusing:

<code>data-page-length="-1"</code> will set the page length to All (pass 25 for page length 25)...

<code>data-fixed-header="true"</code> ... Make a guess

blocks|key|480972|text|只需包含以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480973|++++$(document).ready(function()+{
++++++++$('#tableID').DataTable(+{
++++++++++++"order":+[[+3,+"desc"+]]
++++++++}+);
++++}+
);|code-block|syntax|javascript|480974|完整的参考文章和示例：|480975|https://datatables.net/examples/basic_init/table_sorting.html|offset|length|480976|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|1P|0|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|U|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|W|8|@]|9|@$K|X|L|Y|1|Z]]|A|$]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|J]]]]

Just Include the following code:

<pre><code> $(document).ready(function() {
 $('#tableID').DataTable( {
 "order": [[ 3, "desc" ]]
 } );
 } 
);
</code></pre>

Full reference article with the example: 

<a href="https://datatables.net/examples/basic_init/table_sorting.html" rel="nofollow noreferrer">https://datatables.net/examples/basic_init/table_sorting.html</a>

blocks|key|480866|text|我也有这个问题。我使用了stateSave选项，这就造成了这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|480867|删除此选项即可解决问题。|480868|entityMap^0|C|9|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@]|D|@]|E|$]]|$1|H|3|-4|5|6|7|N|8|@]|D|@]|E|$]]]|I|$]]

I had this problem too. I had used <code>stateSave</code> option and that made this problem. 
Remove this option and problem is solved.

blocks|key|696819|text|使用此命令："order"：[+1，"ASC“]，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|696820|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

use this it works for me:
"order": [[ 1, "ASC" ]],

blocks|key|480932|text|这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480933|+++++++jQuery('#tblPaging').dataTable({
++++++++++++"sort":+true,
++++++++++++"pageLength":+20
++++++++});|code-block|syntax|javascript|480934|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This worked for me:

<pre><code> jQuery('#tblPaging').dataTable({
 "sort": true,
 "pageLength": 20
 });
</code></pre>

I am trying to set the default sort to the second column in my jquery datatable. It by default sorts by index 0. I am using the <code>"aaSorting": [[ 1, "asc" ]]</code> syntax but it highlights the column which I don't want on initial load. How can I set the default sort of a specific column without it highlighting the column as if no sorting was involved and the 0 index column was being used.

jquery datatables default sort

数据库

jQuery

HTML5

我正在尝试将缺省排序设置为jquery datatable中的第二列。默认情况下，它按索引0排序。我使用的是"aaSorting": [[ 1, "asc" ]]语法，但它突出显示了我在初始加载时不想要的列。如何设置特定列的默认排序，而不突出显示该列，就好像不涉及排序并且正在使用0索引列一样。

问jquery数据表缺省排序
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问jquery数据表缺省排序EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问jquery数据表缺省排序
EN