Your search did not match any results.
DataGrid

Grid Columns Hiding Priority

Documentation

The DataGrid can hide columns according to the specified priority if screen width is not enough to display all of them. The hiding priority is specified using the hidingPriority field of an item in the columns array. Switch between the landscape and portrait layouts to see how the DataGrid looks on wide and narrow screens.

Copy to CodePen
Apply
Reset
window.onload = function() { var viewModel = { gridOptions: { dataSource: orders, columns: [{ dataField: "OrderNumber", caption: "Invoice Number", width: 130 }, { caption: "City", dataField: "CustomerStoreCity", hidingPriority: 0 }, { caption: "State", dataField: "CustomerStoreState", hidingPriority: 1 }, "Employee",{ dataField: "OrderDate", dataType: "date" }, { dataField: "SaleAmount", format: "currency" }] } }; ko.applyBindings(viewModel, document.getElementById("grid")); };
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>DevExtreme Demo</title> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0" /> <script src="js/jquery-3.1.0.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/knockout/3.4.0/knockout-min.js"></script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/17.2.3/css/dx.spa.css" /> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/17.2.3/css/dx.common.css" /> <link rel="dx-theme" data-theme="generic.light" href="https://cdn3.devexpress.com/jslib/17.2.3/css/dx.light.css" /> <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.2/jszip.min.js"></script> <script src="https://cdn3.devexpress.com/jslib/17.2.3/js/dx.all.js"></script> <script src="data.js"></script> <link rel="stylesheet" type ="text/css" href ="styles.css" /> <script src="index.js"></script> </head> <body class="dx-viewport"> <div class="demo-container"> <div id="grid"> <div id="gridContainer" data-bind="dxDataGrid: gridOptions"></div> </div> </div> </body> </html>
#gridContainer { padding: 10px; }
var orders = [{ "ID": 1, "OrderNumber": 35703, "OrderDate": "2014/04/10", "SaleAmount": 11800, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Los Angeles", "Employee": "Harv Mudd" }, { "ID": 4, "OrderNumber": 35711, "OrderDate": "2014/01/12", "SaleAmount": 16050, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "San Jose", "Employee": "Jim Packard" }, { "ID": 5, "OrderNumber": 35714, "OrderDate": "2014/01/22", "SaleAmount": 14750, "Terms": "15 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 7, "OrderNumber": 35983, "OrderDate": "2014/02/07", "SaleAmount": 3725, "Terms": "15 Days", "CustomerStoreState": "Colorado", "CustomerStoreCity": "Denver", "Employee": "Todd Hoffman" }, { "ID": 9, "OrderNumber": 36987, "OrderDate": "2014/03/11", "SaleAmount": 14200, "Terms": "15 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 11, "OrderNumber": 38466, "OrderDate": "2014/03/01", "SaleAmount": 7800, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Los Angeles", "Employee": "Harv Mudd" }, { "ID": 14, "OrderNumber": 39420, "OrderDate": "2014/02/15", "SaleAmount": 20500, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "San Jose", "Employee": "Jim Packard" }, { "ID": 15, "OrderNumber": 39874, "OrderDate": "2014/02/04", "SaleAmount": 9050, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 18, "OrderNumber": 42847, "OrderDate": "2014/02/15", "SaleAmount": 20400, "Terms": "30 Days", "CustomerStoreState": "Wyoming", "CustomerStoreCity": "Casper", "Employee": "Todd Hoffman" }, { "ID": 19, "OrderNumber": 43982, "OrderDate": "2014/05/29", "SaleAmount": 6050, "Terms": "30 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 29, "OrderNumber": 56272, "OrderDate": "2014/02/06", "SaleAmount": 15850, "Terms": "30 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 30, "OrderNumber": 57429, "OrderDate": "2013/12/31", "SaleAmount": 11050, "Terms": "30 Days", "CustomerStoreState": "Arizona", "CustomerStoreCity": "Phoenix", "Employee": "Clark Morgan" }, { "ID": 32, "OrderNumber": 58292, "OrderDate": "2014/05/13", "SaleAmount": 13500, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Los Angeles", "Employee": "Harv Mudd" }, { "ID": 36, "OrderNumber": 62427, "OrderDate": "2014/01/27", "SaleAmount": 23500, "Terms": "15 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 39, "OrderNumber": 65977, "OrderDate": "2014/02/05", "SaleAmount": 2550, "Terms": "15 Days", "CustomerStoreState": "Wyoming", "CustomerStoreCity": "Casper", "Employee": "Todd Hoffman" }, { "ID": 40, "OrderNumber": 66947, "OrderDate": "2014/03/23", "SaleAmount": 3500, "Terms": "15 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 42, "OrderNumber": 68428, "OrderDate": "2014/04/10", "SaleAmount": 10500, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Los Angeles", "Employee": "Harv Mudd" }, { "ID": 43, "OrderNumber": 69477, "OrderDate": "2014/03/09", "SaleAmount": 14200, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Anaheim", "Employee": "Harv Mudd" }, { "ID": 46, "OrderNumber": 72947, "OrderDate": "2014/01/14", "SaleAmount": 13350, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 47, "OrderNumber": 73088, "OrderDate": "2014/03/25", "SaleAmount": 8600, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Reno", "Employee": "Clark Morgan" }, { "ID": 50, "OrderNumber": 76927, "OrderDate": "2014/04/27", "SaleAmount": 9800, "Terms": "30 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 51, "OrderNumber": 77297, "OrderDate": "2014/04/30", "SaleAmount": 10850, "Terms": "30 Days", "CustomerStoreState": "Arizona", "CustomerStoreCity": "Phoenix", "Employee": "Clark Morgan" }, { "ID": 56, "OrderNumber": 84744, "OrderDate": "2014/02/10", "SaleAmount": 4650, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 57, "OrderNumber": 85028, "OrderDate": "2014/05/17", "SaleAmount": 2575, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Reno", "Employee": "Clark Morgan" }, { "ID": 59, "OrderNumber": 87297, "OrderDate": "2014/04/21", "SaleAmount": 14200, "Terms": "30 Days", "CustomerStoreState": "Wyoming", "CustomerStoreCity": "Casper", "Employee": "Todd Hoffman" }, { "ID": 60, "OrderNumber": 88027, "OrderDate": "2014/02/14", "SaleAmount": 13650, "Terms": "30 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 65, "OrderNumber": 94726, "OrderDate": "2014/05/22", "SaleAmount": 20500, "Terms": "15 Days", "CustomerStoreState": "California", "CustomerStoreCity": "San Jose", "Employee": "Jim Packard" }, { "ID": 66, "OrderNumber": 95266, "OrderDate": "2014/03/10", "SaleAmount": 9050, "Terms": "15 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 69, "OrderNumber": 98477, "OrderDate": "2014/01/01", "SaleAmount": 23500, "Terms": "15 Days", "CustomerStoreState": "Wyoming", "CustomerStoreCity": "Casper", "Employee": "Todd Hoffman" }, { "ID": 70, "OrderNumber": 99247, "OrderDate": "2014/02/08", "SaleAmount": 2100, "Terms": "15 Days", "CustomerStoreState": "Utah", "CustomerStoreCity": "Salt Lake City", "Employee": "Clark Morgan" }, { "ID": 78, "OrderNumber": 174884, "OrderDate": "2014/04/10", "SaleAmount": 7200, "Terms": "30 Days", "CustomerStoreState": "Colorado", "CustomerStoreCity": "Denver", "Employee": "Todd Hoffman" }, { "ID": 81, "OrderNumber": 188877, "OrderDate": "2014/02/11", "SaleAmount": 8750, "Terms": "30 Days", "CustomerStoreState": "Arizona", "CustomerStoreCity": "Phoenix", "Employee": "Clark Morgan" }, { "ID": 82, "OrderNumber": 191883, "OrderDate": "2014/02/05", "SaleAmount": 9900, "Terms": "30 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Los Angeles", "Employee": "Harv Mudd" }, { "ID": 83, "OrderNumber": 192474, "OrderDate": "2014/01/21", "SaleAmount": 12800, "Terms": "30 Days", "CustomerStoreState": "California", "CustomerStoreCity": "Anaheim", "Employee": "Harv Mudd" }, { "ID": 84, "OrderNumber": 193847, "OrderDate": "2014/03/21", "SaleAmount": 14100, "Terms": "30 Days", "CustomerStoreState": "California", "CustomerStoreCity": "San Diego", "Employee": "Harv Mudd" }, { "ID": 85, "OrderNumber": 194877, "OrderDate": "2014/03/06", "SaleAmount": 4750, "Terms": "30 Days", "CustomerStoreState": "California", "CustomerStoreCity": "San Jose", "Employee": "Jim Packard" }, { "ID": 86, "OrderNumber": 195746, "OrderDate": "2014/05/26", "SaleAmount": 9050, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Las Vegas", "Employee": "Harv Mudd" }, { "ID": 87, "OrderNumber": 197474, "OrderDate": "2014/03/02", "SaleAmount": 6400, "Terms": "30 Days", "CustomerStoreState": "Nevada", "CustomerStoreCity": "Reno", "Employee": "Clark Morgan" }, { "ID": 88, "OrderNumber": 198746, "OrderDate": "2014/05/09", "SaleAmount": 15700, "Terms": "30 Days", "CustomerStoreState": "Colorado", "CustomerStoreCity": "Denver", "Employee": "Todd Hoffman" }, { "ID": 91, "OrderNumber": 214222, "OrderDate": "2014/02/08", "SaleAmount": 11050, "Terms": "30 Days", "CustomerStoreState": "Arizona", "CustomerStoreCity": "Phoenix", "Employee": "Clark Morgan" }];