Open In App

jQWidgets jqxPivotGrid getPivotRows() Method

Improve
Improve
Like Article
Like
Save
Share
Report

jQWidgets is a JavaScript framework for making web-based applications for PC and mobile devices. It is a very powerful, optimized, platform-independent, and widely supported framework. The jqxPivotGrid is a powerful and lightweight data visualization widget that is entirely written in JavaScript language. This widget is offering many advanced features and is highly customizable for different needs.

The getPivotRows() method is used for getting the pivot rows of the specified jqxPivotGrid widget.

Syntax:

var a = $('#myPivotGrid').jqxPivotGrid('getPivotRows');

Parameters: This method does not accept any parameters.

Return values: This method returns the pivot rows.

Linked Files: Download jQWidgets from the given link. In the HTML file, locate the script files in the downloaded folder.

<link rel=”stylesheet” href=”jqwidgets/styles/jqx.base.css” type=”text/css” />
<script type=”text/javascript” src=”scripts/jquery.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxcore.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdata.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxbuttons.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxsortable.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxmenu.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxpivot.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxpivotgrid.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqx-all.js”></script>

Example: The below example illustrates the jQWidgets jqxPivotGrid getPivotRows() method.

HTML




<!DOCTYPE html>
<html lang="en">
  
<head>
    <link rel="stylesheet" 
          href="jqwidgets/styles/jqx.base.css" 
          type="text/css" />
    <script type="text/javascript" 
            src="scripts/jquery-1.11.1.min.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxcore.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxdata.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxbuttons.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxscrollbar.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxmenu.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxpivot.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqxpivotgrid.js">
    </script>
    <script type="text/javascript" 
            src="jqwidgets/jqx-all.js">
    </script>
</head>
  
<body>
    <center>
        <h1 style="color:green;">
            GeeksforGeeks
        </h1>
        <h3>jQWidgets jqxPivotGrid getPivotRows() Method</h3>
        <div id="jqx_Pivot_Grid" style="height:160px;width:270px;">
        </div>
        <input type="button" style="margin:10px;" 
               id="button_for_getPivotRows" 
               value="Get the Pivot rows" />
        <div id="log"></div>
        <script type="text/javascript">
            $(document).ready(function () {
                var data = new Array();
                var i = 0;
                while (i <= 2) {
                    var Column = ["Company"];
                    var Domain = ["Progamming",
                        "CS subjects",
                        "GATE preparation"];
                    var Rank = ["Ranking"];
                    var row = {};
                    row["Domain"] = Domain[i];
                    row["Column"] = "Company";
                    row["Rank"] = "Domain";
                    data.push(row);
                    i++;
                }
                var dataAdapter = new $.jqx.dataAdapter({
                    localdata: data,
                    datafields:
                        [
                            { name: 'Rank', type: 'string' },
                            { name: 'Domain', type: 'string' },
                            { name: 'Column', type: 'string' },
                        ]
                });
                var pivotDataSource = new $.jqx.pivot(
                    dataAdapter,
                    {
                        values: [
                            { text: 'GeeksforGeeks' }
                        ],
                        columns: [{ dataField: 'Column' }],
                        rows: [{ dataField: 'Rank' },
                        { dataField: 'Domain' }],
                    }
                );
                $('#jqx_Pivot_Grid').jqxPivotGrid({
                    source: pivotDataSource
                });
                $("#button_for_getPivotRows").jqxButton({
                    width: 300
                });
                $('#button_for_getPivotRows')
                .jqxButton().click(function () {
                    var a = $('#jqx_Pivot_Grid')
                        .jqxPivotGrid('getPivotRows');
                    $("#log").html('This widget has ' 
                        + a.items.length + ' row.');
                 })
            });
        </script>
    </center>
</body>
  
</html>


Output:

jQWidgets jqxPivotGrid getPivotRows() Method

Reference: https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxpivotgrid/jquery-pivotgrid-api.htm?search=



Last Updated : 29 Dec, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads