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

Questions tagged [datatable]

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

0
votes
0answers
15 views

Populating Datatable text field filter with value selected from HTML Form WP drop-down onkeyup in SPO

QUESTION Is it possible to populate a datatable's text field with the value selected in an HTML From WP using onkeyup? DESIRED OUTCOME Upon selecting a value from the dropdown menu in an HTML Form WP ...
0
votes
1answer
64 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
173 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
26 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
50 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
59 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
108 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
226 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
215 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
177 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
472 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
104 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
64 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
47 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
166 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
34 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
36 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
94 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
70 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
305 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
617 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
1k 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
282 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
78 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
11k 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
20 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
316 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
126 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
179 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
69 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
245 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
60 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
215 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
512 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
15k 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
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
3k 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
682 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
307 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
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
656 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 ...