WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-190f1a-4f.MAI' (Errcode: 28 "No space left on device")]
SELECT p.*, o.option_value, GROUP_CONCAT(DISTINCT CONCAT(m.meta_key, "::", m.meta_value) separator "::::") as seo_meta, t.slug, tr.language_code as language FROM wp_posts p JOIN wp_postmeta m ON p.ID = m.post_id JOIN wp_options o ON o.option_name = "siteurl" JOIN wp_term_relationships r ON r.object_id = p.ID JOIN wp_term_taxonomy x ON x.term_taxonomy_id = r.term_taxonomy_id JOIN wp_terms t ON t.term_id = x.term_id JOIN wp_icl_translations tr ON p.ID = tr.element_id WHERE post_type = "page" AND post_status = "publish" AND tr.language_code = 'en' AND t.slug IN ('jquery') AND x.taxonomy = "page_cat" AND tr.element_type = "post_page" AND meta_key IN ("_yoast_wpseo_title", "_yoast_wpseo_metadesc") GROUP BY p.ID

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-190f1a-50.MAI' (Errcode: 28 "No space left on device")]
SHOW FULL COLUMNS FROM `wp_options`

datatable sorting improvements

WordPress database error: [Can't create/write to file '/tmp/#sql-temptable-4db-190f1a-51.MAI' (Errcode: 28 "No space left on device")]
SELECT p.* FROM wp_mdb_forum_posts AS p LEFT JOIN wp_mdb_forum_posts AS q ON( q.Id = p.ParentId AND p.Id = q.AcceptedAnswerId ) WHERE p.PostTypeId = 2 AND p.ParentId = 128363 GROUP BY p.Id ORDER BY CASE WHEN q.Id IS NOT NULL THEN 1 ELSE 0 END DESC, p.UpvoteCount DESC, p.CreationDate ASC

  1. MDB Home Page
  2. Support Main Page
  3. MDB Standard
Topic: datatable sorting improvements

CarrierLog pro premium priority asked 4 months ago

Expected behavior datatables need to be able to sort columns by values that are different than the formatted display values. For example, when displaying dates, I want to format them in standard "American" format - MM/DD/YYYY, but they need to sort by actual date value, or by an ISO string of the date. I found several old forum posts about this issue, but no satisfactory solutions.

This is not just an issue for dates. The basic datatable example at https://mdbootstrap.com/docs/standard/data/datatables/ actually has the same issue when sorting by Salary. The sorted (descending) values are $90,580 -> $86,000 -> $470,600 -> etc...

Actual behavior Dates formatted as MM/DD/YYYY sort as if they were strings. All columns sort based on their formatted values.

Resources (screenshots, code snippets etc.) I can suggest two approaches to solving this issue (maybe someone else has other suggestions): 1) An optional sort-value attribute for each "cell" in the datatable that the built-in sort function would use when sorting. 2) The ability to specify a custom sort function for a column

Write
Create snippet
Please insert min. 20 characters.

FREE CONSULTATION

Hire our experts to build a dedicated project. We'll analyze your business requirements, for free.
Status

Answered

Specification of the issue
  • User: Pro
  • Premium support: Yes
  • Technology: MDB Standard
  • MDB Version: -
  • Device:
  • Browser:
  • OS:
  • Provided sample code: No
  • Provided link: Yes
Tags
datatables sort
Related topics
0
DataTable Custom Orders
0
Datatable Case insensitive sort
0
Datatable custom sort
0
Datatable - sorting a link
0
Datatables sort behavior is buggy depending upon data attributes
About author
CarrierLog
Pro User Premium support
0Support score
3Questions 1Answers
0Snippets likes 2Snippets