RadSystem Studio pages are the core of application development. The pages panel is divided into four sections:
- Database Tables
- Table Pages
- Table Page Fields
- Table Page Properties
- According to the graph, on the left side of the panel you can find the direct access to the tree database tables, in addition to the views created. You can create your own views too.
- There is a three button menu. the first one allows you to change the details of the connection to the database.
- The next button allows you to manage the Database. Through the interface, you can add, duplicate or delete tables and, for each table, you can manage the fields as well as the field type, size and other properties.
- The last button synchronizes the database updating all the changes that have occurred through the Database manager.
By default, RadSystem Studio creates interfaces (pages) for managing each table in the Database. What is generally known as CRUD (Create, Read, Update and Delete), can be seen in 5 pages: One to list the records, one to see the details of each record, one to Add Records, one to Edit Records and, finally, one to Delete a Record.
The Section also offers three buttons for managing the pages:
- The first button in the section allows you to add a custom page to the project. Among the options in the window, we can choose the name of the page, the type of page (List, Add, Edit or View). If we have a menu configured, we can also choose if the shortcut to be created is a submenu of the main one or if it is created as an independent access in the main menu.
- The second button allows you to duplicate the selected page.
- There is also a button for direct access to the page design.
At the bottom we have access to each of the properties that can be applied to a certain page.
- AjaxPage: Allows you to establish whether the page will use the asynchronous JavaScript technique, processing any request to the server in the background.
To enable ajax search in the list, it is important set to True this option.
- PageTitle: By default, RadSystems Studio uses the table name as the page name. This option allows you to customize the name of the Title that will appear in the List Page.
- DisplayType: You can select how the data is presented. Choose between a tabular or a grid format.
- EmptyRecordMessage: Allows you to customize the message when there is no data in the table.
- Join Tables: Here you can specify your own SQL query or access a window that will help you with its construction.
- Where: The option allows you to specify the SQL WHERE clause that allows you to retrieve a data set under a condition.
- Having: The option allows you to specify the SQL HAVING clause that allows you to retrieve a data set under a SUM or MAX condition.
- Order By: You can specify whether the query is sorted in ascending or descending order and the fields to which it applies.
- Record Limit: It allows to specify the number of records to display per page block.
- InlineEdit: Allows you to specify whether it is possible to edit the records on the same list.
- EditFieldControlType: Allows you to choose whether the inline edition will be based on what is configured on the Edition page or through a specific data format.
- UsePopOverDisplay: Allows you to enable or disable the pop - screen for inline editing.
- Placement: The option allows you to specify the position of the popover display on a inline edition.
- ActivateMode: You can specify the method by which inline editing is triggered.
- ShowButtons: Allows you to specify the position of the buttons that allow inline editing.
- ActionButtonDisplayStile: Allows you to specify whether to view, edit or delete a record, icons or a drop-down menu will be used.
- ActionButtonInFront: You can select if the action buttons will be in front of each row of records or at the end of them.
- DeleteButton: Select if the delete record button will be visible.
- EditButton: Select if the Edit record button will be visible.
- ViewButton: Select if the View record button will be visible.
- EditButtonText: Allows you to customize the caption of the Edit button.
- ViewButtonText: Allows you to customize the caption of the View button.
- DeleteButtonText: Allows you to customize the caption of the Delete button.
- Export: Specify if the export selector will be present in the record list view.
- ExportSettings: In the pop-up window, you can configure the export formats that will be available as well as specify a custom template or define the page orientation for export, among other options.
- ExportButtonText: Allows you to customize the caption of the Export button.
- ImportData: In the pop-up window, you can set whether the data import button will be available, define the text selector or the sign used to define the field separation in a CSV data import.
- ImportButtonText: Allows you to customize the caption of the Import button.
- ListSequence: Specify if a List Sequence will be present in the record list view.
- IncludeCheckBox: Specify if a Check Box will be present for each record in list view.
- Pagination: Specify if the page number selector will be present in the record list view.
- PaginationSettings: Here you can set the pagination style, as well as set if the record counter, page counter and per page record selector will be visible.
- ModalEdit: Allows you to set if the modal edition will be available.
- ModalView: Allows you to set if the modal view will be available.
- TableBorderStyle: Allows you to set the border Style of the List Page.
- TableStripped: It allows to set if the list of records will be visually divided through separator lines.
- TableDark: Allows to apply a dark theme to the records table.
- TableCompact: Allows you to set a compact format for the list page.
- TableHeaderBackground: Here you can select, in bootstrap format, the style of the background color of the field headers.
- TableHeaderTextColor: Here you can select, in bootstrap format, the text colorr of the field headers.
- TableHoverable: Allows you to set if the feature of selecting records on mouse over will be available.
- TableResponsive: Allows you to set if the Responsive feature of the table will be available.
- TableCellAlignment: Allows you to set the alignment of the data in the cells.
- AjaxPage: Allows you to set whether the page will use the asynchronous JavaScript technique, processing any request to the server in the background.
- PageTitle: This option allows you to customize the name that will appear as Title in the View page.
- DisplayType: Here you can set if the layout of each record and its titles will be horizontal or vertical.
- Join Tables: Let you specify your own SQL query or access a window that will help you with its construction.
- Mail Action Settings: Here you can set if an email will be sent every time the record is displayed as well as the title, subject and origin of the mail.
Make sure you have set the default mail configuration in the Project setting option.
- EditButton: Select if the Edit record button will be visible.
- DeleteButton: Select if the Delete record button will be visible.
- EditButtonText: Allows you to customize the caption of the Edit button.
- ModalEdit: Allows you to set if the modal edition will be available.
- DeleteButtonText: Allows you to customize the caption of the Delete button.
- Export: Let you set if the export selector will be present in the view record.
- ExportSettings: In the pop-up window, you can configure the export formats that will be available as well as specify a custom template or define the page orientation for export, among other options.
- ExportButtonText: Allows you to customize the caption of the Export button.
- PageTitle: This option allows you to customize the name that will appear as Title in the Add page.
- SubmitButtonText: Allows you to customize the caption of the Add button.
- EnableCaptchaValidation: Let you set if the Captcha Validation will be available before add a record.
- PageCustomValidation: Let you place your own code for validate when a new record is inserted.
- EnableAutoCompleteField: Select if the autocomplete feature will be available.
- SubForms: This feature let you add subforms when adding a record. You can Specify the relation type, the name of the child form and the foreing key.
- FormLayoutType: Let you select the form layout.
- MessageAfterAdd: Allows you to customize the message that will be displayed once a record has been added.
- Redirect To After Add: Let you set the page to which it will be redirected once the record has been added.
- Mail Action Settings: Here you can set if an email will be sent every time the record is added as well as the title, subject and origin of the mail.
Make sure you have set the default mail configuration in the Project setting option.
- Load Indicator Settings: Here you can set the pagination style, as well as set if the record counter, page counter and per page record selector will be visible.
- PageTitle: This option allows you to customize the name that will appear as Title in the Edit page.
- SubmitButtonText: Allows you to customize the caption of the Edit button.
- EnableCaptchaValidation: Let you set if the Captcha Validation will be available for a edited record.
- PageCustomValidation: Let you place your own code for validate when a record is edited.
- FormLayoutType: Let you select the form layout.
- MessageAfterAdd: Allows you to customize the message that will be displayed once a record has been edited.
- Redirect To After Add: Let you set the page to which it will be redirected once the record has been edited.
- Mail Action Settings: Here you can set if an email will be sent every time the record is edited as well as the title, subject and origin of the mail.
Make sure you have set the default mail configuration in the Project setting option.
- Load Indicator Settings: Here you can set the pagination style, as well as set if the record counter, page counter and per page record selector will be visible.
- PromptMessageBeforeDelete: Here you can customize the message displayed before a record is deleted.
- PromptDisplayStyle: Let you set de Style of the prompt message displayed.
- Redirect To After Delete: Let you set the page to which it will be redirected once the record has been deleted.
- Mail Action Settings: Here you can set if an email will be sent every time the record is deleted as well as the title, subject and origin of the mail.
Make sure you have set the default mail configuration in the Project setting option.
For an explanation on the “Edit Code” column, please follow this link
In this section, the first column is made up of 5 types of buttons:
- The first two buttons allow you to reorder the fields for rendering on the page.
- This button allows you to add a custom field.A new window opens, allowing you to enter an expression, an alias and the name of the field. You can enter an expression from the list of examples or create your own.
- You can edit the custom field.
- You can delete the custom field.
The next columns in the section allow you to:
- The checkboxes in the OUTPUT column define whether the field will be rendered in the final view of the page.
- The checkboxes in the SEARCH column define whether the fields will be searched in the final view of the page.
In the section we can also define the logical operator SQL LIKE and the wildcards for the search.
In this section, for the View-Page fields, you can find the same buttons for to reorder and output a field and for to add, edit and delete a custom field.
In this case, for the Add-Page fields, you can reorder the fields and manage the output of the fields on the add-page or edit-page of the record.
In the case of the Edit-Page fields, you can find the same options as the Add-Page fields section.
In this section, the properties of a field will depend on the type of field that is chosen. In RadStudio System there is 7 types of fields:
- PlainText
- Image
- StarRating
- ProgressBar
- CheckButton
- RelativeDate
- Custom
In the view, for example, the PlainText type field allows us to:
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- Field Link: By default, the system sets a shortcut to the record view with the option --CurrentRecordDetail–. We can also choose between a direct access to the categories, the file, the search value, an email or a telephone as well as the pages to add or list the pages that we have created.
- –CurrentRecordDetails–: Redirects a field’s record to a detail page or view page.
- –CurrentFieldCategory–: Filters record based on the field.
- –CurrentFieldvalue–: Used to link a particular field data to a file or an attachment.
- –CurrentFieldValueSearch–: Used to search current field.
- –CurrentFieldMailTo–: Adds mailto link to the current field’s data.
- /menuexample/list: Used to link the current field record or data to the list page.
- /menuexample/add: Used to link the current field record or data to the add page.
- FormatRecordField: This property also depends on the type of field one chooses. For the example, through this property, we can set the date or currency format, format a STRING so that everything is uppercase or lowercase or convert a numeric data type to Letters among other options.
- human_date: convert the current field record to human readable date.
- human_time: converts the current field record to human readable time.
- human_datetime: converts the current field record to human readable date and time.
- relative_date: converts the current field record to relative date for example; few seconds ago.
- to_currency(‘en_US’): converts the current field record to currency.
- ucwords: converts the first letter of every word in the current field record or data to uppercase.
- ucfirst: converts the first letter of every string in the current field record to uppercase.
- strtolower: converts the current field record to lowercase.
- strtoupper: converts the current field record to uppercase.
- str_truncate(50,‘…’): intercepts the length of data in the current field record, to the specified value.
- approximate(2): Approximates data in the current field record according to specified value.
- to_number: formats the data in a current field record. For example: 1988665545 to 1,988,665,545.
- number_to_words(‘en’): formats a given data in a current field record to words. For example: 1 2 3 4 to “one two three four”.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- ColumnWidth: Allows you to set the width of the field column.
- Display Label: Allows you to set the Title of the Field column.
- Record Detail Page: Set the characteristics of a relationship between master and detail tables.
- Relation Type: You can select between a one-to-one or one-to-many relationship.
- Master Table: Sets the master table and the defined field as primary key.
- Detail Table: Here you can choose the detail table and the related field.
- Aply To Pages: The checkboxes allow you to establish whether the relationship will be applied to the detail view of the record or to the page of adding a record or to both.
- Page Display: Allows you to select the table that will be incorporated as a detail of the relationship and the style of its display (modal, online, popover or as a link).
- Record Display Field / Text: Here you can set the text that will be displayed in each related record. You can set it to show the value of the record or a specific value of the table fields.
- Display Icon: According to the original settings, you can choose the icon to be displayed on each related record.
- Button Color: In the boostrap format, you can select the color of the button that gives access to the detail table view.
If the online editing option is enabled in the assignment of page properties, here you can specify if this option will be available for each field individually.
- Inline Edit: Set to TRUE to enable inline editing of the field.
- Inline Edit: Allows you to choose whether the inline edition will be based on what is configured on the Edit page or through a specific data format.
- UsePopoverDisplay: Allows you to enable or disable the pop - screen for inline editing.
- Placement: The option allows you to specify the position of the popover display on a inline edition.
- ActivateMode: You can specify the method by which inline editing is triggered.
- ShowButtons: Allows you to specify the position of the buttons that allow inline editing.
- Field Link: Used to link a particular field record to a page.
- –CurrentRecordDetails–: Redirects a field’s record to a detail page or view page.
- –CurrentFieldCategory–: Filters record based on the field.
- –CurrentFieldvalue–: Used to link a particular field data to a file or an attachment.
- –CurrentFieldValueSearch–: Used to search current field.
- –CurrentFieldMailTo–: Adds mailto link to the current field’s data.
- /menuexample/list: Used to link the current field record or data to the list page.
- /menuexample/add: Used to link the current field record or data to the add page.
- FormatRecordField: Allows you to format the field’s record data.
- human_date: convert the current field record to human readable date.
- human_time: converts the current field record to human readable time.
- human_datetime: converts the current field record to human readable date and time.
- relative_date: converts the current field record to relative date for example; few seconds ago.
- to_currency(‘en_US’): converts the current field record to currency.
- ucwords: Converts the first letter of every word in the current field record or data to uppercase.
- ucfirst: Converts the first letter of every string in the current field record to uppercase.
- strtolower: Converts the current field record to lowercase.
- strtoupper: Converts the current field record to uppercase.
- str_truncate(50,‘…’): Intercepts the length of data in the current field record, to the specified value.
- approximate(2): Approximates data in the current field record according to specified value.
- to_number: formats the data in a current field record.
- number_to_words(‘en’): formats a given data in a current field record to words.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- ColumnWidth: Allows you to set the width of the field column.
- Display Label: Allows you to set the Title of the Field column.
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- ImageSize: You can set it to small, medium or large size of the image.
- Image Tag size: Here you can specify the width and height of an image.
- MaxImages: You can set the maximum number of images that the log will save.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- ColumnWidth: Allows you to set the width of the field column.
- Display Label: Allows you to set the Title of the Field column.
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- NumberOfStars: You can set the number of stars that appear in the rate field.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- FieldHeaderIcon: Allows you select the icon that will apper in the header of the column’s field.
- Display Label: Allows you to set the Title of the Field column.
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- MaxValue: You can set the max value of the progress bar.
- ProgressBarClass: You can set a custom class or a bootstrap class for styling the progress bar.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- ColumnWidth: Allows you to set the width of the field column.
- Display Label: Allows you to set the Title of the Field column.
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- CheckValue: If it is set to TRUE, the checkbox is marked.
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- Field Link: Used to link a particular field record to a page.
- –CurrentRecordDetails–: Redirects a field’s record to a detail page or view page.
- –CurrentFieldCategory–: Filters record based on the field.
- –CurrentFieldvalue–: Used to link a particular field data to a file or an attachment.
- –CurrentFieldValueSearch–: Used to search current field.
- –CurrentFieldMailTo–: Adds mailto link to the current field’s data.
- /menuexample/list: Used to link the current field record or data to the list page.
- /menuexample/add: Used to link the current field record or data to the add page.
- FormatRecordField: Allows you to format the field’s record data.
- human_date: convert the current field record to human readable date.
- human_time: converts the current field record to human readable time.
- human_datetime: converts the current field record to human readable date and time.
- relative_date: converts the current field record to relative date for example; few seconds ago.
- to_currency(‘en_US’): converts the current field record to currency.
- ucwords: Converts the first letter of every word in the current field record or data to uppercase.
- ucfirst: Converts the first letter of every string in the current field record to uppercase.
- strtolower: Converts the current field record to lowercase.
- strtoupper: Converts the current field record to uppercase.
- str_truncate(50,‘…’): Intercepts the length of data in the current field record, to the specified value.
- approximate(2): Approximates data in the current field record according to specified value.
- to_number: formats the data in a current field record.
- number_to_words(‘en’): formats a given data in a current field record to words.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- ColumnWidth: Allows you to set the width of the field column.
- Display Label: Allows you to set the Title of the Field column.
- Record Detail Page: Set the characteristics of a relationship between master and detail tables.
- InlineEdit: Allows you to specify whether it is possible to edit the records on the same list.
- EditFieldControlType: Allows you to choose whether the inline edition will be based on what is configured on the Edition page or through a specific data format.
- UsePopOverDisplay: Allows you to enable or disable the pop - screen for inline editing.
- Placement: The option allows you to specify the position of the popover display on a inline edition.
- ActivateMode: You can specify the method by which inline editing is triggered.
- ShowButtons: Allows you to specify the position of the buttons that allow inline editing.
- Sortable: If it is set to TRUE, a control will be added to the page view that will allow the column to be sorted by this field.
- CustomCode: You can insert your own custom code.
- FormatRecordField: Allows you to format the field’s record data.
- human_date: convert the current field record to human readable date.
- human_time: converts the current field record to human readable time.
- human_datetime: converts the current field record to human readable date and time.
- relative_date: converts the current field record to relative date for example; few seconds ago.
- to_currency(‘en_US’): converts the current field record to currency.
- ucwords: Converts the first letter of every word in the current field record or data to uppercase.
- ucfirst: Converts the first letter of every string in the current field record to uppercase.
- strtolower: Converts the current field record to lowercase.
- strtoupper: Converts the current field record to uppercase.
- str_truncate(50,‘…’): Intercepts the length of data in the current field record, to the specified value.
- approximate(2): Approximates data in the current field record according to specified value.
- to_number: formats the data in a current field record.
- number_to_words(‘en’): formats a given data in a current field record to words.
- FieldFooterExpressión: Through this property, we can define an expression that is displayed at the end of each page and at the foot of the selected field. You can select a sample expression from the drop-down list or create your own.
- ColumnWidth: Allows you to set the width of the field column.
- Display Label: Allows you to set the Title of the Field column.