Questions tagged [datatable]

Represents one table of in-memory data. This class stores rows and columns of data.

Filter by
Sorted by
Tagged with
0
votes
1answer
64 views

I want to do full CURD operation in JQuery Datatable for SharePoint List item

I want to have Add, Edit, Delete options of Jquery datatable for my SharePoint list item. Have anyone implemented this. I know how to show data in datatable using SharePoint REST, But facing ...
0
votes
0answers
48 views

Jquery Datatable Grouping 2 levels (Group and SubGroup)

I'm trying to group datatables using SharePoint List RESTAPI and I get to accomplish level grouping and I want to group level two as subgroup. Please let me know if that's possible. The picture below ...
0
votes
1answer
37 views

Can jQuery Datatables in a search results web part return more than 50 documents?

I've hit a wall on figuring out how to remedy this issue. Im currently developing a search center page with jQuery datatables and control and item display templates. The search results webpart is ...
0
votes
0answers
27 views

Jqeury datatable to retrieve SharePoint list items

I am trying to build Jquery datatable to retrieve the list items depending on two filer dropdown boxes and a button. I have a custom list with Title, District, Organization, Number of Tasks as columns....
0
votes
1answer
91 views

REST API append data to datatables

I have 2 lists, first list has the following columns: StaffName UnitName The second list has the following columns: UnitName Department Essentially, i want to pull all names from the first list ...
0
votes
1answer
40 views

Sharepoint HTML table with colors [closed]

I'm sure this is super simple, but I'm having a hard time wrapping my head around the logic of it. I have a SharePoint list of ~100 items, each item has an identifier A-C for example. I'd like to ...
0
votes
1answer
357 views

Is there a way you can fetch SharePoint's more than 5000 items using datatable?

Is there a way you can fetch SharePoint's more than 5000 items using datatable Jquery recursively in REST API? I also wanted to show the next set of data (next 1000 items) after clicking a button.
0
votes
1answer
908 views

Open Item in Modal/Dialog with Datatables

I am using a jQuery data table to display a Sharepoint list. I have the title column hyperlinked to each item's display form. But I would like for this to open in the modal. Below is my code for ...
0
votes
1answer
91 views

Datatables Rest filter count on Sharepoint

I've got a SharePoint site that I'm running some Rest API queries on and filtering results. I was just wondering if anyone had a quick tip on if its possible to pull a count from the following code ...
3
votes
1answer
110 views

Change image and send filter to datatable on click, via SharePoint jslink

I am using the DataTables jQuery plug-in to drive custom formatting, filtering, and searching on a SharePoint list. The list is an agenda for a conference, with dates, topics, rooms, session types, ...
1
vote
1answer
306 views

Datatable row color based on Rest API results

I have a Rest API call to pull data to create a Datatable. What I'm trying to figure out is how to dynamically color the rows based on information in one of the columns (example here is if the ...
0
votes
1answer
660 views

REST - filter dates in between

If the current request is for 04/02/2018 - 04/06/2018, I need to display in a datatable any other requests that include 04/02 - 04/06. For example, the datatable should display the following requests ...
0
votes
0answers
28 views

Custom Webpart to set the filters and display SharePoint list items?

I have a requirement where list items are stored in multiple folders. Now users should be able to apply the filters as they would do if they do not have folders. It looks like I have a build a custom ...
0
votes
2answers
790 views

Datatables plugin, print multiple tables on one page

I distributed the data across multiple tables (code posted here) using data table plugin, which works wonderfully. Now, I would like to print the data on one page. Is there a way to print or export ...
1
vote
2answers
148 views

Datatables - equally split data between multiple datatables

Edit: final code: var requestIOBInfo1 = siteUrl + "/_api/web/Lists/getByTitle('IOBoard')/Items?$\ filter=((Division eq '" + iDivision + "') and (AccountStatus eq 'Active'))&$\ select=Id, Title, ...
0
votes
2answers
36 views

Work with SQL table in SharePoint environment

I have to create a simple custom list with half a dozen of columns, but due to number of items it will create (there will be more then 5000), OOTB SP custom list will bread after 5000 items threshold ...
0
votes
1answer
76 views

Datatables calling another

I'm trying to launch or populate another datatable based on values from another table. For example, I'm using below code to get all "pending" items for the current user: $(document).ready(function()...
0
votes
1answer
53 views

Overriding text in datatable with icons

In reference to this page, I'm trying to replace the text with icons but not getting the desired results. function mySuccessHandler(data) { try { var dataTableExample = $('#table_id').DataTable();...
0
votes
1answer
231 views

Create DataTable from 2 SharePoint Online lists

Can I join two SharePoint Lists and display in one DataTable? I created my first dataTable but now trying to get data from another list. For example: I want the dataTable to display similar to a ...
1
vote
0answers
39 views

Update SP list with data from external DB

The requirements include quick edit, so BCS and OOTB external list are not an option here. The solution I'm looking for has to make these steps: foreach record in a datatable: if the record exists ...
0
votes
1answer
42 views

InsertCell not working in Sharepoint

var table = document.getElementById("WrksheetTable"); for(i=0;i<arrworksheets.length;i++){ var tr = document.createElement("tr"); tr.id = "tr" + i; var td = document.createElement("td");...
0
votes
1answer
118 views

How to show link columns with datatables?

Is there a way to display link columns in a database table. I was following this but turns out link fields aren't display with a link. Instead the entire hyperlink is displayed which messes up the ...
1
vote
2answers
84 views

Creating a search box for a list (BasicTable View) - Only search that partilcar list

How do you create a search box for a list in Basic Table view style? Preferably using the content editor web part or script editor.
2
votes
0answers
414 views

Performance issues when using Jquery Datatable in Sharepoint

I am currently using Jquery Datatable in Sharepoint, where I am not using ajax in datatable as I am fetching data from multiple tables and after doing than I am joining the list and converting it to ...
0
votes
2answers
1k views

How to reduce width of data table columns

I have a sharepoint 2013 list. Using data tables am retrieving the list data into a data table. How to reduce the width of particular columns in data table? Thanks in advance.
0
votes
3answers
3k views

Add HyperLink Column to Datatable

I am trying to add a hyperlink to the Fac_x0020_ID column in the datatable below. How is this done with datatables? call.done(function (data,textStatus, jqXHR){ $('#FacilitiesTable').dataTable({ "...
0
votes
1answer
488 views

How to merge and bind the results of two different “listdata.svc” calls to a jquery Datatable (datatable.js)

I have to query two different document libraries with some metadata columns and show the results in single grid. Both the document libraries have identical columns. I am using Datatable.js for ...
0
votes
1answer
118 views

How to disable the table header sorting for a data table [closed]

I am using the following code to generate a datatable... var dataTable = $('#projectDashboard').DataTable( { dom: 'T<"clear">lfrtip', "bDestroy" : true, ...
0
votes
1answer
17k views

Unable to set property '_DT_CellIndex' of undefined or null reference

I am working on datatables, I am getting the following error: Unable to set property '_DT_CellIndex' of undefined or null reference Does anybody encountered the same erro? Thanks
1
vote
0answers
452 views

Add colored border to some elements of table

I would like to know if it is possible to add a border of a specific color in a table. The preset styles do not work as I keep some of the table boxes clear, and some colored and only want the border ...
0
votes
1answer
152 views

Cascading dropdown with repeating table for SharePoint lists

I want Cascading dropdown with repeating table for SharePoint lists only by using SharePoint 2013 not with InfoPath. I have attached image what I require with only SharePoint 2013 not with InfoPath.
1
vote
1answer
199 views

How to Compare Datatable values with SharePoint List Items?

I have one SharePoint List. From Excel I will store the values in Data-table and fetch the values to List.If new values are adding to list is no problem. If item is already there i want to update the ...
0
votes
1answer
83 views

Datatable doesn't bring all columns from SharePoint list

I programmatically created a library "DropDownLibrary" with some field "ReviewType"(text), "SubmittedDate"(datetime), "Created"(the sharepoint field)... and it works in the browser, I can insert new ...
0
votes
2answers
311 views

jQuery CAML results into jQuery DATATABLES plugin

Using the following code to extract items for a SharePoint list and display in HTML. Works great thank to all you folks here. Now I want to inject the output into the jQuery DataTables plugin but not ...
1
vote
2answers
2k views

Merging the results of 2 REST calls in a dataTable

I am trying to add results from two REST calls, into one Data Tables view. I am getting just one of the Rest calls results shown. //'use strict'; var appweburl; var hostweburl; var results; var ...
0
votes
1answer
61 views

using Jquery in a Async functions

Hi I want to update/create a datatable from results of a function. I have the following code and I now need to output the results into a datatable. At the top of the page I have : <script type="...
0
votes
1answer
253 views

SPListItemCollection.GetDataTable() , For choice fields its adding extra string “;#” in the datatable

SPListItemCollection collListItems = list.GetItems(query); dataTable = collListItems.GetDataTable(); I am using above for getting listitemcollection into datatable. In the list I have choice column ...
0
votes
1answer
570 views

Run CAML Query on DataTable SharePoint

I have a DataTable having Some rows. Is there any way to execute CAML Query on it. Or Alternatively, How can I convert this DataTable into a SPList so tha CAML can be executed on SPList. private ...
0
votes
3answers
19k views

How to add link in jquery DataTables column?

I have succeeded adding the link in the column but I can't seem to add the url/path in the href attribute. How can I add the path/url and the title in the function below so that the link will be ...
1
vote
2answers
4k views

How to create editable table in Sharepoint

I want to use Sharepoint to host a table that multiple people can edit (like an online spreadsheet, for example). I have tried various things which have not worked: I tried downloading a plugin for ...
2
votes
1answer
4k views

Creating table on ascx file with <% %> in foreach loop

I am trying to print out the elements from an arraylist in a table. But they don't show up in tags. But they appear right up on the webpart title with a single line text. <table class="table ...
2
votes
2answers
5k views

How to use jQuery and OData to expand multi user field in SharePoint 2013?

I am using jQuery to query a Sharepoint 2013 list and expanding the AssignedTo field (which is a Person or Group field type) in order to get the user id. I was able to get the code working when the ...
1
vote
2answers
5k views

Retrieve SharePoint list in DataTable with Condition

** I have a Sharepoint List called "Resources" and have various Fields as shown below and same returns as DataTable: ID Title Role LoginName Enable[Yes/No] 1 Pranav Developer ...
1
vote
1answer
798 views

Create a SharePoint List from Datatable

How we can create a SharePoint List from Data-table.
0
votes
1answer
104 views

Data Table distinct value

dtnew1.DefaultView.Sort = "Modified DESC"; DataTable unique = dtnew1.DefaultView.ToTable(); In this code's "unique" table I'm getting all values but post title value is getting repeated. I need a ...
1
vote
1answer
1k views

How can I display user picture from sharepoint in datatables

Sorry if this is stupid easy but I'm trying to display user pictures from sharepoint in datatables. I can see the link in JSON data coming back from the ajax query in the "Picture" field so I added: ...
0
votes
2answers
339 views

How retrieve custom fields only when using SPListItemCollection?

Hi with following code I am retrieving a DataTable from a List: using (SPSite site = new SPSite("http:...")) { using(SPWeb web = site.OpenWeb()) { ...
3
votes
2answers
11k views

SharePoint list as data source for jQuery DataTables plugin

I trying to create a table using a SharePoint list as source. I followed this tutorial and it worked perfectly. But this method would not work if you need to reload the data using, let's say a drop ...
0
votes
1answer
318 views

What's wrong with my Datatable with SharePoint 2010

I would like to display the first line in the custom list as an image below to textbox and gridview. However, the textbox got the last value, while the gridview got the first one. Summary: The frist ...
0
votes
2answers
675 views

Use Google Visualization with Datatables plugin and which get data from REST

I have this code that get the data from SharePoint using ajax, and the datatable plugin creates the table. function LoadAIP(state){ var call = $.ajax({ url:"https://xxxx/xxxx//_api/web/lists/...