Grid Control 3.0 Overview
Grid Control 3.0
Grid Control 3.0 Overview
Grid Control 3.0 offers advanced features and improves performance over Grid Control 2.0. Use Grid Control 3.0 to take advantage of these capabilities:
- Load and paginate data rapidly.
- Present data in a contemporary interface.
- Filter date ranges, numeric ranges, and the like via a mini-console.
- Change column order.
- Group columns.
- Specify fixed columns.
Web Central's PM Planner (ab-pm-planner.axvw) and the Service Console (ab-request-console.axvw) views use this control.
Note: Select the grid control version that suits your needs when you design a grid. You cannot select features from both versions for the same view.
These topics explain how to use Grid Control 3.0:
- Initialize and Load Data
- Actions and Selections
- Data Visualization
- Grouped Columns
- Fixed Columns
- Group by Category
- Edit Grids and Grid Data
- Grid Control 3.0 API Reference
To use these features:
- Define a data source in the view file.
- Define an HTML panel in the view file.
- Add a JavaScript file to the view.
- Initialize the controI in the JS file.
See Add Grid Control to a View in Grid Control 3.0 API Reference , and refer to sample code in these files:
- http://localhost:8080/archibus/schema/ab-products/solutions/parts/grid/ab-ex-advanced-grid-categories.axvw
- http://localhost:8080/archibus/schema/ab-products/solutions/parts/grid/ab-ex-advanced-grid-categories.js
Data Columns
The grid displays data columns defined in JavaScript code, not all columns defined in the data source.
Formats and units for various data values follow Grid Control 2.0 conventions.
Group Columns
To group columns, specify in the view file that certain columns have a group title. See
columnGroupTitle
and
columnGroupId
column properties in
Grid Control 3.0 API Reference
.
The example below groups cost columns under Costs:
Change Column Order
Drag columns left or right to change their order. Reload the view to restore the original order.
If a column lies within a group, you can drag the column within the group, but not outside of it.
Group Records by Category
To group records by category, specify the default category in the view. You can also provide a view action to change a category. See
groupBy
property and
groupBy
method in
Grid Control 3.0 API Reference.
Each category header displays the number of records in that category.
By default, the grid expands all categories after the view loads. You can collapse categories, as above, or expand any category to display its list of records.
Page Control
You can force a grid to display records on multiple pages. See the pageSize property in Grid Control 3.0 API Reference . Page control appears below the list of records:
If the grid groups records by category, records within each category may span multiple pages. If you expand or collapse any category, the grid recalculates the number of visible records, and number of pages required to display them.
Totals and Sub-totals
To display totals for numeric fields, add the
showTotals
property to the data source field in the view. The grid displays total values in the totals row.
If the grid groups records by category, each category header displays sub-totals for numeric fields, such as cost to complete for work requests:
Filter Records
You can filter records by any field value.
Apply these filter operations for text and enumerated fields:
Apply these filter operations for date and numeric fields:
Limitations
By comparison with Grid Control 2.0, Grid Control 3.0 has these limitations:
- Requires JavaScript coding: you cannot define grids in pure AXVW format.
- Does not support Grid Control 2.0's grid index.
- Does not support data export to DOCX, PDF, or XLS files.