|
Adding Grids based on Data providers or Procedures to a web panel generated using K2BWebPanelDesigner involves many steps, as the developer must select the grid's columns, its filters, orders, and the Data Provider. To simplify this process, K2BWebPanelDesigner includes the "Add grid from Data Provider action" and the "Add grid from Procedure" action. Using any of these actions, a grid is added to the web panel, the Data source property is set, then it adds a variable for each SDT field in the first level of the return value. Also if the data source allows changing the output order and filtering it creates OrderBy and Filter nodes in the grid.
The inferred grid may not suit all needs, but is a very good starting point that the developer can customize later to suit its particular requirements.
Adding a grid from a Data Provider or Procedure involves three steps:
- Choose the node under which the grid should be created. The developer may choose nodes from any type, as long as they support having grids as child nodes.
- Select the "Add Grid From Data Provider" (or Add grid from Procedure) action in the Actions menu inside the contextual menu belonging to the node chosen in the previous step.
 |
| Contextual menu |
- Choose the dataprovider the grid should be based on.
 |
| DataProvider selection |
- Choose the layout that should be used when generating the grid. In this point you can choose a dynamic layout, a standard grid, or a free style grid.
 |
| Layout selection |
After following these steps, the result will be similar to the one shown below.
 |
| Generated grid |
All first level fileds in the data source output output SDT that are based on attributes or domains are included as variables in the inferred grid.
The dataprovider parameters that are included as filters are the ones that match all the conditions bellow:
- It's based on an attribute or domain.
- Its name is not PageSize, PageCount, OrderBy, OrderedBy, Skip or Count.
A Order node will be generated with descriptions "First Order" and "Second Order" only if the data source object matches one of the conditions below.
- It contains a parameter called OrderBy or OrderedBy or its name ends with "OrderBy".
|