Getting Started

In this section, you can learn how to create Grid using JavaScript in mobile app.

Create your first Grid in JavaScript

Essential Grid for Mobile JavaScript is a feature-rich Grid component that can handle large amount of data. It is very easy to use and includes features like data binding, filtering, paging, and sorting. You can make use of the Mobile Grid control to generate complex grid-based reports. In the following guidelines, you will learn about the features in Mobile Grid widget by creating a Sales data grid.

Create the necessary layout

Essential JavaScript Mobile Grid can be rendered only by specifying the data source. It is rendered based on the default values for all the properties; you can easily customize Mobile Grid control by changing its properties according to your requirement.

  1. Create an HTML file and paste the following template to it for Grid creation.
  • html
  • <!DOCTYPE html>
    
    <html>
    
    <head>
    
        <meta id="viewport" name="viewport" content="width=device-width, initial-scale=1.0,maximum-scale=1.0, user-scalable=no" />
    
        <title>Grid</title>
    
        <link href="[http://cdn.syncfusion.com/14.3.0.49/js/mobile/ej.mobile.all.min.css](http://cdn.syncfusion.com/14.3.0.49/js/mobile/ej.mobile.all.min.css)" rel="stylesheet" />
    
        <script src="[http://cdn.syncfusion.com/js/assets/external/jquery-1.10.2.min.js](http://cdn.syncfusion.com/js/assets/external/jquery-1.10.2.min.js)"></script>
    
        <script src="[http://cdn.syncfusion.com/js/assets/external/jsrender.min.js](http://cdn.syncfusion.com/js/assets/external/jsrender.min.js)"></script>
    
        <script src="[http://cdn.syncfusion.com/14.3.0.49/js/mobile/ej.mobile.all.min.js](http://cdn.syncfusion.com/14.3.0.49/js/mobile/ej.mobile.all.min.js)"></script>
    
        <script type="text/javascript" src="[http://js.syncfusion.com/UG/Mobile/Content/jsondata.min.js](http://js.syncfusion.com/UG/Mobile/Content/jsondata.min.js)"> </script>
    
    </head>
    
    <body>
    
        <div data-role="appview">
    
            <div id="header" data-ej-title="Grid-Sales Data" data-ej-position="normal" data-role="ejmheader">
    
            </div>
    
            <div id="content">
    
                <div>
    
                    <!--Mobile Grid control  -->
    
                </div>
    
            </div>
    
            <div id="pagescroll" data-role="ejmscrollpanel" data-ej-target="content">
    
            </div>
    
        </div>
    
    </body>
    
    </html>

    Create the Grid

    In your Sales data grid, you require three columns to display the Order ID, Customer ID, and Freight. Create a div element for grid with its unique id. Here you don’t have to specify “data-role” attribute since it’s not an unobtrusive control. So the Grid control can be initialized in script by calling the widget “ejmGrid” with the necessary options. The data source can be set using the datasource attribute and its columns can be configured using the columns attribute. You can set specific properties for each field by using columns attribute.

    Refer to the following code example.

  • html
  • <!--Mobile Grid control  -->
    
    <div id="mobgrid"> </div>

    Refer to the following script section.

  • html
  • <script type="text/javascript">
    
            $(function () {
    
                    // The datasource "window.gridData" is referred from jsondata.min.js
                    
                    var data = ej.DataManager(window.gridData).executeLocal(ej.Query().take(50));
    
                    // Creates Mobile grid
    
                    $("#mobgrid").ejmGrid({
    
                    dataSource: data,
    
                    // Configures Columns for Mobile grid
    
                    columns: [
    
                       { field: "OrderID", headerText: "Order ID" },
    
                       { field: "CustomerID", headerText: "Customer ID", width: 130 },
    
                       { field: "Freight", headerText: "Freight" }
    
                    ]
                });
            });
    </script>

    Run this code and you can see the following output.

    Grid with Scrolling

    Now, you have to enable scroll support in Grid. Scroll is used to view all the content present in the Grid when the screen size is smaller than the Grid content. For that, you have to set allowScrolling attribute as true. This enables the scroll panel in the Grid. Use scrollSettings attribute to set scroll panel properties. Here scroll panel height has been set by using height attribute.

  • html
  • <script type="text/javascript">
    
            $(function () {
    
                // The datasource "window.gridData" is referred from jsondata.min.js
    
                var data = ej.DataManager(window.gridData).executeLocal(ej.Query().take(50));
    
                // Creates Mobile grid
    
                $("#mobgrid").ejmGrid({
            
                    dataSource: data,
    
                    allowScrolling: true,
    
                    scrollSettings: { height: 260 },
    
                    // Configures Columns for Mobile grid
    
                    columns: [
    
                       { field: "OrderID", headerText: "Order ID" },
            
                       { field: "CustomerID", headerText: "Customer ID", width: 130 },
    
                       { field: "Freight", headerText: "Freight" }
    
                    ]
                });
            });
    </script>

    Run this code and you can see the following output.

    From the above output, it is clear that we can scroll up and down to view the Grid contents.

    Grid with Paging

    Now, enable Paging feature in Grid. This offers complete navigation support to easily switch between the pages. This can be achieved by using the pager bar available at the bottom of the Mobile Grid control. To enable paging, use allowPaging attribute of Grid as shown below. Pager can be scrolled horizontally if its width exceeds the target window. The pageSize attribute describes the number of records to be displayed in single Grid page.

  • html
  • <script type="text/javascript">
    
            $(function () {
    
                // The datasource "window.gridData" is referred from jsondata.min.js
    
                var data = ej.DataManager(window.gridData).executeLocal(ej.Query().take(50));
    
                // Creates Mobile grid
    
                $("#mobgrid").ejmGrid({
    
                    dataSource: data,
    
                    allowScrolling: true,
    
                    scrollSettings: { height: 260 },
    
                    allowPaging: true, //Enables Paging for mobile grid
    
                    pageSettings: { pageSize: 10 }, //Specifies page size for mobile grid
    
                    // Configures Columns for Mobile grid
    
                    columns: [
            
                           { field: "OrderID", headerText: "Order ID" },
    
                           { field: "CustomerID", headerText: "Customer ID", width: 130 },
    
                           { field: "Freight", headerText: "Freight" }
    
                    ]
                });
            });
    </script>

    Run this code and you can see the following output.

    Grid with Filtering

    Now, enable Filtering feature in Mobile Grid. A filter facilitates the extraction of a subset of records that meet certain criteria. Filters can be applied to one or more columns. To enable filtering, use the allowFiltering attribute of Grid.

    Click the filter icon in column header to make the filtering text box visible. Then enter search content to filter your Mobile Grid data.

  • html
  • <script type="text/javascript">
    
            $(function () {
    
                var data = ej.DataManager(window.gridData).executeLocal(ej.Query().take(50));
    
                $("#mobgrid").ejmGrid({
    
    	            dataSource: data,
    
        	        allowFiltering: true, //Enables Filtering for Mobile grid
    
        	        allowScrolling: true,
    
        	        scrollSettings: { height: 260 },
    
        	        allowPaging: true, //Enables Paging for mobile grid
    
        	        pageSettings: { pageSize: 10 }, //Specifies page size for mobile grid
    
    	            columns: [
    
    	               { field: "OrderID", headerText: "Order ID" },
    
    	               { field: "CustomerID", headerText: "Customer ID", width: 130 },
    
    	               { field: "Freight", headerText: "Freight" }
    
    	            ]
                });
            });
    </script>

    NOTE

    The filter query is a combination of value and symbols (<, >, =, etc). For example, you can provide “<10255” in Order ID column. The numeric columns can be filtered by using the symbols “<”, “>”, “=”, “<=”, “>=”, “!” and the string columns can be filtered by using the symbols “%” (for startswith and endswith) and “*“ (contains). Also , you can use “&&” and “   ” operator to provide multiple conditions in single column.

    Run this code and you can see the following output.

    In the above output, it is clear that Order ID filter is selected and the Order ID filter column is filled with the value 10260.

    Sortable Grid columns

    Now, enable Sorting feature in Mobile Grid. Mobile Grid columns are sortable. You can sort column data either in ascending or descending order. To enable sorting, use allowSorting attribute of Grid as shown below. Click the column header to sort the Grid columns. The down arrow indicates that the column is sorted in ascending order and up arrow indicates that the column is sorted in descending order. If there is no arrow, it means the sorting is cleared.

  • html
  • <script type="text/javascript">
    
            $(function () {
    
                var data = ej.DataManager(window.gridData).executeLocal(ej.Query().take(50));
    
                $("#mobgrid").ejmGrid({
    
                    dataSource: data,
    
                    allowFiltering: true, //Enables Filtering for Mobile grid
    
                    allowScrolling: true,
    
                    scrollSettings: { height: 260 },
    
                    allowPaging: true, //Enables Paging for mobile grid
    
                    pageSettings: { pageSize: 10 }, //Specifies page size for mobile grid
    
                    allowSorting: true, //Enables Sorting for Mobile grid                
    
                    columns: [
    
    	                 { field: "OrderID", headerText: "Order ID" },
    
    	                 { field: "CustomerID", headerText: "Customer ID", width: 130 },
            
    	                 { field: "Freight", headerText: "Freight" }
    
                    ]
                });
            });
    </script>

    Run this code and you can see the following output.