I’ve written an extension inspired by Derek Jones’ Simplify Edit Table extension. It also uses the wonderful jQuery tablesorter plugin, found here.

Features:

- Add dynamic table sorting to the table by clicking on the column heading
- Hold shift and select multiple column headings to do perform multiple sorts
- Hide the search form above the entries table
- Create a custom “results per page” select in the search form above the entries table

Important Notes:

The only data sorted is what is actually on the page. If there is any pagination of entries, not all of the entries will be included in the sort. To mitigate this problem, select 150 results in the search form and hit search.

Features to come:

- Javascript based pagination that will allow for results to be sorted across multiple pages.
- Live text search

Releases:

1.2.0
  - Removed feature to hide columns in edit table. The Seesaw extension does an exceptional job of performing this task and can be used in tandom with Edit table Plus. http://ellislab.com/forums/viewthread/139168/
  - Added new settings form with better group of settings
  - Added the ability to hide the search form
  - Added the ability to hide only the results select within the search form
  - Added the ability to set all of the options to appear in the results select. An additional option of “Show All” is automatically added as an option.
  - Added the ability to set a default number of entries to be shown per page. If you want to set a fixed number of entries per page that cannot be changed,
    set your number here and hide the results select.
  - Add-on is now multi-language friendly

1.1.1 -
  - Fixed bug that rendered a rogue new line break on the edit page

1.1.0 -
  - Added the ability to hide the entry id column
  - Added the ability to set the default column to sort by
  - Added the ability to define how to sort the default column
  - Added the ability to choose whether the edit table is alter server side via php or client side via javascript

1.0.0 -
  -Inititial Release

Let me know if you have any problems or suggestions.

Absolutely fantastic!!

This is something that should be installed as default I believe. Will definitely put this one into my default set from now on.

Thanks for sharing this with us all.

Best wishes,

Mark

Very nice. Just a few days ago, I was hacking away at the cp.publish file to get rid of that stupid trackbacks column.

2.0. 2.0. 2.0. Please.

With all the praise Edit Tab Ajax gets, I’m surprised this isn’t WAY more popular.

Nice extension !

I did however find some issues when you have the Restricted entries extension enabled (http://www.purple-dogfish.co.uk/free-stuff/restrict-entries). The table header does not match the columns anymore. As a result the sorting is not matching the header.

- Ruud -

Thanks Ruud. I’m not familiar with the restricted entries extension, but I’ll look into it.

Hi,

Just did a quick test, as I know there are several other extensions out there which modify the edit table as wel. Webee Quick (http://onnogroen.nl/webee/ee/) has the same problem sorting the table when enabled.

- R -

I’m thinking it has to do with a the way I remove some of the columns with regular expressions. I don’t think their criteria are greedy enough. I’ll be able to look into this more this week, but thanks for pointing it out.

Just wanted to point out that this is not compatible with Seesaw, which actually makes absolute sense considering they both can hide columns.

Feature Request
Can we have an option to choose a default sort column (ascending or descending) inside the panel for Edit Table Plus?

Bugs
The checkbox/select column doesn’t allow bulk deselection.

I was not aware of Seesaw and its functionality. I’m seriously considering taking the column hiding out and leaving that to Seesaw, and only focus on the sorting.

Seesaw is a bit more advanced with its column hiding and also allows custom field to be displayed in columns and per-weblog specific display settings. Thanks for the feature suggestion considerations! =)

lockwesmonster - 10 March 2010 03:23 PM

I was not aware of Seesaw and its functionality. I’m seriously considering taking the column hiding out and leaving that to Seesaw, and only focus on the sorting.

Hi lockwesmonster,

Nice addon you have here, well done!  I’m the developer for Seesaw, and obviously it’d be great if these could play nice together.

I’ve downloaded your files and had a quick play.  We approach column hiding/revealing in different ways (I’m not proud to admit that I forego clever regexp in lieu of near-blind assumptions as to what’s there).  Though the real conflict appears to lie in the table and thead HTML elements that you need there, and which my addon isn’t aware of.

Perhaps we can take this convo offline, see what we can do.  I’ll PM you in a bit…

Cheers

Would love to see this work with: http://nicolasbottari.com/index.php/expressionengine/nb_show_custom_field_data/ and similar extensions.

Nice one. I like that they’re larger too. A bit of Fitt’s Law there.

Really nice! Just this morning I was thinking how nice it would be to have an add-on that did exactly this. My clients will be thrilled to have this addition to their sites.

Thank you.