DataTables-Form Input column not sorting

Hi All,

I implemented a datatable on my sharepoint 2013 site and I have an issue and a question.

Issue:
The first column does not sort like it should. Any ideas?  Here's an example of how it should work.

Here's my site

Question:
What would you suggest on how to update the 'Priority Number' column if the values were changed?
LVL 5
IsaacSharePoint Client Side DeveloperAsked:
Who is Participating?
 
KarenAnalyst programmerCommented:
You can add a data-order attribute to the CELL of the column you wish to sort on, containing the value you wish it to sort by.
The datatables documentation about using "data-order" to sort columns can be found here
https://datatables.net/examples/advanced_init/html5-data-attributes.html
I have altered your js fiddle here
https://jsfiddle.net/sb4ohdkj/11/
0
 
Walter CurtisSharePoint AEDCommented:
Have you considered using a calculated column to do what you want to do?
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
No, I need to use the datatable b/c of the other features it has (fast and responsive search, item shown selection, etc.)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
KarenAnalyst programmerCommented:
Cannot go to your site, it gives a "permission denied" error
"The method "GetItems" of the type "List" ... is blocked by the administrator ...."
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
0
 
lenamtlCommented:
I don't think it is possible to filter on column that have input field,
even on their site it is not possible
https://datatables.net/examples/api/form.html
The filter is only on the first column because it's not using the input field
0
 
IsaacSharePoint Client Side DeveloperAuthor Commented:
Awesome!  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.