• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

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.

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

Here's my site

What would you suggest on how to update the 'Priority Number' column if the values were changed?
1 Solution
Walter CurtisSharePoint AEDCommented:
Have you considered using a calculated column to do what you want to do?
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.)
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 ...."
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

IsaacSharePoint Client Side DeveloperAuthor Commented:
I don't think it is possible to filter on column that have input field,
even on their site it is not possible
The filter is only on the first column because it's not using the input field
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
I have altered your js fiddle here
IsaacSharePoint Client Side DeveloperAuthor Commented:
Awesome!  Thanks!

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now