cellInfoByElement
Returns an information about for a specific data cell element
Parameters
cell String|Element|jQuery
A string, DOM element or jQuery object which represents the data table cell. A string is treated as a jQuery selector.
Returns
Object
the data cell information.
The fields of the result object:
- columnTuple - the tuple of the corresponding column header cell
- rowTuple - the tuple of the corresponding row header cell
- measure - the measure value of the data cell
- dataItem - the data item itself
Example - get information on element hover
<div id="pivotgrid"></div>
<script>
$(function() {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
height: 550,
dataSource: {
type: "xmla",
columns: [{ name: "[Date].[Calendar]", expand: true } ],
rows: [{ name: "[Product].[Category]", expand: true }],
measures: ["[Measures].[Internet Sales Amount]"],
transport: {
connection: {
catalog: "Adventure Works DW 2008R2",
cube: "Adventure Works"
},
read: {
url: "https://demos.telerik.com/olap/msmdpump.dll",
dataType: "text",
contentType: "text/xml",
type: "POST"
}
},
schema: {
type: "xmla"
}
}
}).data("kendoPivotGrid");
pivotgrid.wrapper.on("mouseenter", ".k-grid-content td", function(e){
var info = pivotgrid.cellInfoByElement(e.currentTarget);
/* The result can be observed in the DevTools(F12) console of the browser. */
console.log(info);
});
});
</script>