Answers

• colin Posts: 15,177Questions: 1Answers: 2,590

  April 2021

  It's not designed to do that, but something like this may give you a start - it's moving the component to the table header - it needs some styling but that may be something that's possible to do.

  Colin
• colin Posts: 15,177Questions: 1Answers: 2,590

  April 2021

  As an update, this is something we'll be implementing this summer, so if you can wait until September time, this will be fully integrated into SearchPanes

  Colin
• ada_lovelace Posts: 3Questions: 1Answers: 0

  April 2021

  Great to hear Colin! Would it be an option to do the summation of the columns on mouseover or click of the column? My datasets are large enough that the SearchPanes loads, even on a subset of columns, is markedly slower than loads without SearchPanes enabled.

  My compliments on the SearchPanes UX for the order, search, clear, and select. It's much better than the Microsoft (Excel) and Google (Sheets) implementations.

  Somewhat relatedly, I have build a small feature to sort multiple hidden columns on mouseover of a merged column, as my users cognate an item in the table as an '1.2oz foo bar thing' (they cognate and collaborate with their peers using the full string to describe the item),

  IE the table has a 'description' column with rows such as:

  • size12 red unworn nikes
  • size10 blue excellent nikes
  • size 8 red very good addidas
  • size 7 blue unworn reeboks

  (notional example, we aren't working with shoes)

  My feature enables the user to order the table by size, color, condition, or brand, even though those columns are hidden.

  I have added one column for description and 4 hidden columns for size, color, condition, and brand. On mouseover of the 'description' table head it shows size, color, condition, and brand and a click on one of the buttons orders the table by the hidden column:

  Brand is selected, so Addidas comes first:
  

  User mouses over the head, and all 4 sorting options appear under their mouse:
  

  They click size and the table orders by size (a hidden column):
  

  User mouses over again and clicks color:
  

  the table orders by color (a hidden column):
  

  It's not a lot of code, but may be useful to others. What's the best way to share it with the community? A post here?
• ada_lovelace Posts: 3Questions: 1Answers: 0

  April 2021

  Also, here is an implementation I found that may be helpful when developing this feature: https://www.codeproject.com/Tips/1137325/Jquery-DataTable-with-Custom-Filter-with-Materiali
• allan Posts: 61,972Questions: 1Answers: 10,160 Site admin

  April 2021

  Hi,

  Would it be an option to do the summation of the columns on mouseover or click of the column?

  Yes .

  It's not a lot of code, but may be useful to others. What's the best way to share it with the

  Yes please! It might be worth using live.datatables.net or JSFiddle to show the code running?

  Allan