jQWidgets jqxDataTable groups Property

Last Updated : 29 Jul, 2022

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 jqxDataTable is used for reading and displaying the data from the HTML Table. This is also used to display data from various data sources like XML, JSON, Array, CSV, or TSV.

The groups property is used to set or return the data groups of the displayed jqxDataTable. By setting this property one can display the data that is grouped by a batch of column(s). It is of Array type and its default value is [].

Syntax:

Set the groups property:

$('Selector').jqxDataTable({ groups: ["Employee_Name"] });

Return the groups property:

var groups = $('Selector').jqxDataTable('groups');

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/jqxscrollbar.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxlistbox.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdropdownlist.js”></script>
<script type=”text/javascript” src=”jqwidgets/jqxdatatable.js”></script>

Example 1: The below example illustrates the jqxDataTable groups property in jQWidgets.

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.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/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color: green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable groups 
            Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" 
               style="margin: 29px;" 
               id="jqxbtn" 
               value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                groups: ['Employee_Name'], 
                height: 200, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var gr = $('#Data_Table').jqxDataTable( 
                    'groups' 
                ); 
                $('#log').text(gr); 
            }); 
        }); 
    </script> 
</body> 
  
</html>

Output:

Example 2: The following is another example of the jqxDataTable groups property that is set to “[]”.

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.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/jqxlistbox.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdropdownlist.js"> 
    </script> 
    <script type="text/javascript" 
            src="jqwidgets/jqxdatatable.js"> 
    </script> 
</head> 
  
<body> 
    <center> 
        <h1 style="color: green;"> 
            GeeksforGeeks 
        </h1> 
        <h3> 
            jQWidgets jqxDataTable groups 
            Property 
        </h3> 
        <div id="#Data_Table"></div> 
        <table id="Data_Table" border="1"> 
            <thead> 
                <tr> 
                    <th>Employee_Name</th> 
                    <th>Company</th> 
                    <th>Designation</th> 
                </tr> 
            </thead> 
            <tbody> 
                <tr> 
                    <td>Rohit</td> 
                    <td>GeeksforGeeks</td> 
                    <td>HR</td> 
                </tr> 
                <tr> 
                    <td>Rahul</td> 
                    <td>Capgemini</td> 
                    <td>Software Engineer</td> 
                </tr> 
                <tr> 
                    <td>Vivek</td> 
                    <td>CESC</td> 
                    <td>Electrical Engineer</td> 
                </tr> 
                <tr> 
                    <td>Amit</td> 
                    <td>Apple</td> 
                    <td>Manager</td> 
                </tr> 
            </tbody> 
        </table> 
  
        <input type="button" 
               style="margin: 29px;" 
               id="jqxbtn" 
               value="Click here" /> 
        <div id="log"></div> 
    </center> 
    <script type="text/javascript"> 
        $(document).ready(function () { 
            $("#Data_Table").jqxDataTable({ 
                groups: [], 
                height: 200, 
                columns: [{ 
                    text: 'Employee_Name', 
                    dataField: 'Employee_Name', 
                    width: 190 
                }, { 
                    text: 'Company', 
                    dataField: 'Company', 
                    width: 160 
                }, { 
                    text: 'Designation', 
                    dataField: 'Designation', 
                    width: 190 
                }] 
            }); 
            $("#jqxbtn").jqxButton({ 
                width: 280 
            }); 
            $("#jqxbtn").on("click", function () { 
                var gr = $('#Data_Table').jqxDataTable( 
                    'groups' 
                ); 
                if (gr === 'Employee_Name') { 
                    $('#log').text("Grouped!"); 
                } 
                else { 
                    $('#log').text("Empty!"); 
                } 
            }); 
        }); 
    </script> 
</body> 
  
</html>