Search

For complex queries that looks about as good as it gets :-) Allan

Problem solved. Sorry, plz close.

That is something that should be resolved with the Buttons 1.2.2 release. My guess is that you are using 1.2.0 or 1.2.1. Allan

Thank u allan.. You are Just amazing..

Thanks.. This is what i want

It turns out, it's quite easy to do. I associated a render function with the column (see the columns.render property). When the function is called I do something similar to this: function(data, type, row, meta) { var cusip = row["CUSIP"]; var generatedNodeText = "<a data-toggle='collapse' data-target='#" + cusip + "'>" + data.length + " Documents</a>"; generatedNodeText += "<div id='" + cusip + "' class='collapse'>"; // Generate the anchors in the accordion. // You will generate whatever content is specific to your situation. for (var i in data) { // iterate over the objects in the XBRL array generatedNodeText += "<a href='" + data[i].URL + "'>" + data[i].Text + "</a><br />"; } generatedNodeText += "</div>"; return generatedNodeText; }

Fantastic ... thank you Allan.

is there a way to destroy/empty all of the old tables with a wildcard? You can use jQuery selectors to select multiple tables (just comma separate them, like you do in CSS). Or use the $.fn.dataTable.tables() method to get the existing DataTables in a single API instance. Allan

Adding the following columnDef and defining a function to recreate the table with a new data property for the ajax option worked. "columnDefs": [{ "targets": [4], "mData": null, "mRender": function(data, type, full) { return '<a href="" onclick="event.preventDefault(); searchSponsor(' + data[15] + ');">' + data[6] + '</a>'; }]

Sorry msb72, I can't help you but I'm just at the stage of seeing if it is possible to bring in data into my personal GoDaddy page from my O365 site. Were you able to perform this with a REST call? Tx