Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
1answer
42 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
71 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
0answers
21 views

using datatable input fields for daily report

I'm using a datatable to pull results from a sharepoint list that I would like to then get daily updates submitted and pushed to another list. I've got the datatable working and the fields seem to be ...
0
votes
1answer
43 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
44 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
64 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
0answers
166 views

Inserting fillable table in a custom sharepoint list item

Is there a way through SharePoint 2013 out of the box or SharePoint Designer 2013 to add a table with headers so that when a person is completing a new custom list item, they are able to fill out each ...
0
votes
1answer
108 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
140 views

How to load all items(More than 20,000 items) return by Search API in a Datatable

I am using the below code to get all the records across the site collection based up on the content type. for example In my site collection i have 10 sub sites and in that i have 20 lists using the ...
0
votes
0answers
25 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
384 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
92 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
59 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
43 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
126 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
31 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
34 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
80 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
65 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
273 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
467 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
992 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
234 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
66 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
9k 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
0
votes
0answers
19 views

Want to create a table on a subpage that allows users to add entries to the table

I currently have a table (11x1) on a sharepoint subpage. This table will be for issue tracking purposes within an enterprise team. I want there to be an "add entry" button where the user can fill out ...
1
vote
0answers
251 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
120 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
172 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
63 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
222 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
59 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
202 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
496 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
14k 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 ...
0
votes
2answers
3k 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
2k 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
4k 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
4k 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 ...
0
votes
1answer
653 views

Create a SharePoint List from Datatable

How we can create a SharePoint List from Data-table.
0
votes
1answer
98 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
291 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
10k 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
317 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
643 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/...
2
votes
2answers
3k views

Convert DataTable to SPListItemCollection

Consider the following code:- SPListItemCollection collListItems = emp_info.GetItems(query); dt = collListItems.GetDataTable(); Now i want to convert the dt object back to SPListItemCollection ...
0
votes
0answers
84 views

Edit row information using BDC

I want to make simple database table insert/edit/delete using BDC. What I have tried: I have created External Content type mapped to database table and using external content type created list. But ...