These are the general settings of the “Group By” in the Grid, independently of it’s type, static or dynamic. Here we can define some Group By viewing options, such as the use of Tree view, for example. The option Enable TreeView isn’t available in the Infinite Scroll. Group By Line : Sets the positioning of group by in relation to group records.Enable TreeView : Defines the use of TreeView in “Group By”, which allows you to expand or collapse the records displayed in Group by. Separates the Group By : Sets the spacing between two Group By.Tab a Group By : Sets the left margin of Group By.Value Separator : Define the separator between the title and the field value in the GROUP BY.Record count title : Sets a title for the records quantity column.Display Titles : Allows the label display of the fields within the groups.Group By sorting : It allows to order the fields respecting the Group By.Group By Header : Lets you display the Group By header on all pages.The options are Before the records or After the records. In this type of security, access to applications is defined according to the user groups created and configured by the system administrator. The process for the security module creation is quick and simple. In this screen we define the fields available in Dynamic Group By and will be summarized in Grid and Summary when the Dynamic Group By is used. Making use of the security modules, you can implement a complete access rules for systems developed by ScriptCase. In this screen we define the fields available in the Dynamic Group By and will be summed in the Grid and Summary when the dynamic Group By is used. This option is available only when the initial module is set to be the Filter. Use Iframe : This option configures the filter to be displayed within an Iframe (displaying the Filter itself and the search results on the same page). This Group By works independently from any other Group By configuration or Totals already performed, that is, the fields defined to be summarized in the Grid or Summary in the Dynamic Group will be visible only when the Dynamic Group is used. Filter Module : This option configures which application will be called after the Filter. We will be able to see all available fields for the Group By configuration and totals in the Grid Fields. Summary Totals: Defines the fields that are part of the Summary Totals.Grid Totals: Defines the fields that are part of the Grid Totals.Group By Fields: Defines the fields that are part of the Group By.Grid Fields: List of all the fields of the application.The Use Dynamic Group By option enables the Group By in the run-time application.įields used when using the Grid must be configured to be displayed on the Grid. After going to 8.0.037 (and 38 now too) - this fixed the issue to allow me to completely reset / clean my Dynamic Group By (DGB) settings. Choose CustomerID, CompanyName, Adress, Phone and Country fields in the Fields Positioning menu. In Scriptcase the fields are internally treated as local variables PHP, however, at Scriptcase interface it’s necessary to inform these, using keys, so it’s possible to retrieve or assign values to the application fields. We must drag and drop the fields that will be part of the Group By in Group By Fields.Įach field can only be added once to the Group By Fields, except for the date and datetime fields. Create a new grid application using customers table. Record Count : This option allows you to view the amount of records by the General Total title. Thank you ahead of time to anyone responding. grid, group-by, collapse-all, expand-all. After choosing the name of your project, click in next and create a database connection to your system, we highly recommend you to use sqlite because you do not need to have a previously installed Database in your machine, afterwards. Currently, I cannot find any option to allow expand all or collapse all when using the group by options. This is really a disaster and I do not have any solution yet.Date and Datetime fieldsįor date and datetime fields, some display intervals have been added, so these fields can be added two or more times to the Group By.Īll Grid fields can be added to the “totals”, the only difference being the functions available. Group Subtotal : This option defines where the subtotal group by will be displayed. Create a new system in your Scriptcase clicking at create project or new project. Making use of the security modules, you can implement a complete access rules for systems developed by ScriptCase.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |