Title: SQL data sort
Last modified: August 30, 2016

---

# SQL data sort

 *  Resolved [megadrive16](https://wordpress.org/support/users/megadrive16/)
 * (@megadrive16)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/)
 * Hi,
 * TableMaster is best plugin in particular for displaying database large raw data.
   
   Thank you for your excellent work.
 * SQL data sort doesn’t seem to work when “datatables” option is on.
    In command
   like “SELECT column1 FROM table1 ORDER BY column1”.
 * Data is sorted in a moment, and reset immediately.
 * [https://wordpress.org/plugins/tablemaster/](https://wordpress.org/plugins/tablemaster/)

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

 *  Plugin Author [vmallder](https://wordpress.org/support/users/vmallder/)
 * (@vmallder)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/#post-6842705)
 * Good Morning megadrive16,
 * Thank you for writing to me to tell me about this problem. I am very happy that
   you like the TableMaster plugin :), and I will look into this problem today and
   get back to you.
 * Valerie
 *  Plugin Author [vmallder](https://wordpress.org/support/users/vmallder/)
 * (@vmallder)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/#post-6842708)
 * Hello Again,
 * I believe I have found the fix for this problem. I will include this fix in the
   next release. But in the meantime, you can make the following change in the code
   and use the fix right away.
 * Edit the file “tablemaster.php” and go to line 716. Add a comma ‘,’ at the end
   of line 716. And insert a new line after line 716 that contains the following:
 *  ‘aaSorting’ => ‘”aaSorting”:[]’
 * So, your new lines 716 and 717 should look like this:
 *  ‘responsive’ => ‘”responsive”:true’,
    ‘aaSorting’ => ‘”aaSorting”:[]’
 * Please let me know if this works for you.
 * Valerie
 *  Thread Starter [megadrive16](https://wordpress.org/support/users/megadrive16/)
 * (@megadrive16)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/#post-6842778)
 * Hi Valerie,
 * Thank you very much for your nice support.
    It worked perfect certainly.
 * I’m very happy that I’ve arrived at your plugin finally.
 * And thanks for making me notice that Japanese is early rising for you.(^o^)
 *  Plugin Author [vmallder](https://wordpress.org/support/users/vmallder/)
 * (@vmallder)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/#post-6842812)
 * Hi Megadrive16,
 * I’m so glad you are happy with my plugin. TableMaster is my first plugin and 
   it’s nice to know that it is helpful to you. With the newest release 0.0.3, you
   should use the new keyword “default_sort” and set the value to “false” for any
   tables that you do not want to use the default sorting that the DataTables jQuery
   plugin uses. So, just add default_sort=”false” to your shortcode for those tables.
 * If you have any other suggestions for new features that would be nice to have
   in the plugin, please let me know. 🙂
 *  Thread Starter [megadrive16](https://wordpress.org/support/users/megadrive16/)
 * (@megadrive16)
 * [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/#post-6842838)
 * Hi Valerie,
 * It is wonderful that TableMaster is your first plugin. After serching for various
   plugins with table and database, I found your plugin is the best.
 * “default_sort” option willl be also useful. I’m looking forward to newer functions.＼(
   ^o^)／

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

The topic ‘SQL data sort’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/tablemaster_d1d7db.svg)
 * [TableMaster](https://wordpress.org/plugins/tablemaster/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablemaster/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablemaster/)
 * [Active Topics](https://wordpress.org/support/plugin/tablemaster/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablemaster/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablemaster/reviews/)

## Tags

 * [sort](https://wordpress.org/support/topic-tag/sort/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)

 * 5 replies
 * 2 participants
 * Last reply from: [megadrive16](https://wordpress.org/support/users/megadrive16/)
 * Last activity: [10 years, 3 months ago](https://wordpress.org/support/topic/sql-data-sort/#post-6842838)
 * Status: resolved