041 module additional fields and new grid schema Designer throughout the custom system, module attach fields are also necessary. There are two additional fields for a module, one for the parent module and one for the aggregation field in the Submodule. When the module records the generation of the SQL statement, it simply generates all the basic fields of the module and the ID of its immediate parent module and the field of name. It is not possible to add all the fields of the parent module, only to specify some required fields to join in the SQL statement. For example, when acquiring the order data, the most basic SQL statement includes only the destination city and the Origin city, if you want to display the Origin province and the destination province in the grid, you need to set up additional fields, which is an additional field of the parent module. The second additional field is the aggregation field for the Submodule, and for the order module, it needs to display the number of order details, the subtotal of the order amount, and so on. Additional fields defined can be displayed in a grid, form, and can be used in custom printing.
Here's a look at how to design a grid's column definition and a variety of additional fields, in the context of the newly revised Setup grid field interface.
In the diagram above, the leftmost is the tree of the current Datum module and all its parent modules and Submodules, after clicking on an item, the field of the module is displayed in the middle area, and the selected field is ticked, and the right side is the group and field of the selected list. Is the case after a parent module has been selected.
Finally shield the selection of the aggregation field of the module in a sudden.
After selecting a good field above, you can display this grid in the order. As shown in the following:
In the above fields and grouped designers, each field and grouping can be dragged to determine location and nesting relationships, and you can modify some definitions such as title and width, and if you have special custom attributes, you can put them in additional settings.
Designers can later be used to design query conditions, navigation, the definition of form fields, and so on.
General function and Module customization system (CFCMMS)-041 module additional fields and new grid schema Designer
