DevExtreme v23.2 is now available.

Explore our newest features/capabilities and share your thoughts with us.

Your search did not match any results.

Grid Columns Hiding Priority

When the DataGrid adapts its layout to smaller screens, it hides columns based on the hidingPriority. Columns with lower values are hidden first.

In this demo, the CustomerStoreCity column is hidden in vertical and horizontal orientation modes because its hidingPriority is 0. The CustomerStoreState and OrderDate columns have a priority of 1 and 2. The DataGrid hides these columns after the CustomerStoreCity column, only when the screen orientation is vertical.

Backend API
$(() => { $('#gridContainer').dxDataGrid({ dataSource: orders, keyExpr: 'ID', showBorders: true, 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', hidingPriority: 2, }, { dataField: 'SaleAmount', format: 'currency', }], }); });
<!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="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script>window.jQuery || document.write(decodeURIComponent('%3Cscript src="js/jquery.min.js"%3E%3C/script%3E'))</script> <link rel="stylesheet" type="text/css" href="https://cdn3.devexpress.com/jslib/23.2.5/css/dx.light.css" /> <script src="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="gridContainer"></div> </div> </body> </html>
#gridContainer { padding: 10px; }
const 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', }];