Search
Settings
With this interface, you can define general options of the Search Form.
Search configuration Interface.
Search Criteria
Allows to select the logical operator AND or OR to define the criteria of the search;
Display Condition
Gets the condition of the search available for the user to choose one. He can select “AND” or “OR” in a Combobox.
Use auto-complete in the fields
Automatically turns the field into an autocomplete according to the existing values in the database. If the user chooses Yes, the autocomplete will enable automatically in all inputs that contain a relationship. If the user decides No, so no autocompletes will be displayed. Otherwise, the option selected is Defined in the field it’ll keep the settings for each field individually.
Filter conditions
With this interface, you can configure the conditions available for each field of the Search form.
Search configuration Interface.
We can see the fields list on the left combo. On the right, the list of options for filtering the selected field. To select an option, click on one of them (Equal to, Beginning with, Contains, etc.) and then the button On/Off. The arrows, on the right, allows altering the order of the fields.
For the Date type fields, you can define special conditions for the search, accessing the field configurations, and editing the Special Conditions Settings.
Below the list are the buttons to enable the selected options:
- On/Off: Enables or disables the field or the option chosen.
- All: Marks all fields or options.
- None: Unmarks all the fields or options.
Advanced Search
Settings
Through these attributes you can define some general Search settings, such as alignment, width, search conditions, etc.
Margins
Defines the position of the margins of the Search Form.
Keep Values
It keeps the searched values when the user returns to the search form.
Keep Columns and Order Selection
Set it to preserve the selected columns and sorting for each search, if they went changed by the user through the toolbar options.
Use Enter to
It allows you to define the action that the Enter Key has on the Search form. Tabulate enables you to navigate between fields, and Submit performs the search(activates the Search button).
Display Tags
Allows displaying as tags, the searches used for the Grid.
Display after filtering
Display tags only after performing an advanced search. If disabled, it will always display a tag, regardless of the advanced search.
Unify results
Sets the chars limit to group the result of the tags. This option should be used when the field type is multiple-select.
Treeview in the Tags
Sets the use of Treeview for tags.
Initial status of the Treeview
It sets the initial state of the Treeview. (If the app is using Treeview for tags)
Start open
It displays the tags.
Start close
It displays the full description of the tags as text.
Clear other filters after submit
After applying the advanced filter, all other filters will be deleted.
Interact with the dynamic filter
Apply the same filter in matching fields between Advanced and Dynamic Filter, when not showing the labels.
Highlight
Highlights the results in the query. It only works for “Exactly the same”, “Contains” and “Equal start” conditions.
To customize how the highlight will be displayed, you must access the theme editing tool.
1 - Access the Layout > Application Themes menu.
2 - Choose the desired theme and click Advanced Mode.
3 - Then look for the sub-item Grid, within the item of the same name.
4 - In this sub-item you will find the option “Line”, which contains the folders Line Odd and Even. In each of these folders you will find the option Quicksearch highlight, with the options for editing Text, Border and Background of the searched terms.
Select fields
Required
This interface has the options for you to select and set the Search form required fields.
Within the generated application will be displayed a marker(*) next to the field and an error message will also pops up if there’s no value assigned to the mandatory fields. You will be able to set some options for the market using the options below.
- Marker position : Marker’s position relative to the field (options are right, left or Do not display).
- Display message : Displays whether or not the validation error message.
Toolbar
Desktop
The Search toolbar is divided in two parts: Top and Bottom, in a way that is possible to define the buttons that will be displayed in both bars. The selection of buttons in the top and bottom toolbar works independently, allowing the buttons to be displayed in both bars at the same time.
Toolbar Interface.
Navigation: Groups the options relative to the navigation buttons that can be displayed in the application.
- Search: Execute the search.
- Clean: Clean the all the search fields.
- Edit: Enable the Save Tag option.
- Exit: Exit the application.
Others: Groups a diversity of options relative to the application.
- Languages: Displays a combobox with the names available, defined in the project properties.
- Themes: Displays a combobox with the themes available, defined in the project properties.
- HelpCase: Displays a button to redirect to the help page.
Separator
- —————–: Dispays a line separating the buttons, when used the Group Buttons.
Use in-line buttons: Allows the alignment of the filter buttons next to the fields.
- Inline buttons: Allows you to select which buttons will be displayed next to the field, and you can sort them according to your wishes. This option is available by enabling Use buttons inline in the button settings.
When activating the Inline Buttons option, the screen to configure the buttons will be displayed.
The buttons available in this in-line button option are the same as those shown in the standard toolbar described above.
This is the result when using a radio button on the line
Button Settings
Button Settings Interface.
- Hotkey: Allows you to set keyboard hotkeys to a button.
- Position of the in-line buttons: Sets the positioning of the buttons to the right or left of the fields.
- Column Quantity: Sets the number of display columns of the buttons, allowing you to configure whether they will be displayed side-by-side or distributed in columns.
Options
Options Interface.
- Button Position(Top/Bottom) Positioning the buttons of the toolbar Top/Bottom.
Save Search
This feature allows the end-user to save his searches in a profile. You can create some rules, like to save the searches by user login.
Save Filter Interface.
Save Filter Interface.
Events
Scriptcase uses the events to enable the developer to customize the application code. Using the events you can program custom actions at a specific execution time (e.g. After a record is inserted, when it is loaded, upon submitting a Form, …) and for a specific application type. In the event areas you can use global and local variables, JavaScript, CSS, HTML, PHP codes and also Scriptcase macros.
onScriptInit
onRefresh
onSave
onValidate
Layout
This module lets you editing display options for the application. You can apply visualization themes, organize blocks, define values, and the display format of the Header and Footer.
Blocks
Blocks are “containers” where you can position the application fields of Forms, Controls, or Slide Grids.
Scriptcase creates applications with one block by default. You can add more blocks as you wish, to organize it in the best way.
See below, the Columns Organization, and where you can define the position of the next block: beside or below the current one.
Application Block configuration
On the left side of each block, there are two icons, the first one to edit the information of the block and the second one to delete the block.
Organizing the position of the Blocks
See below how to modify the display order of the Blocks in one Page.
Click and drag the block that you desire to modify to its new position.
Application Block Display configuration
- See how to remove a block from the display
Click on the block desired and drag it to the item “Blocks not Shown”. This way, you can also drag the block to another page if desired. See the images below.
Application Block Display configuration
Application Block Display configuration
Block
- Name: The name that identifier the Block.
- Label: Title of the block to display in the application.
Title
- Display: It controls the display of the block title.
Label
- Display: It controls the display of the field labels of the block.
- Position: Options to display label :
- Above: Display the label above the field.
- Beside: Display the label beside the field.
- Below: Display the label below the field.
Fields
- Columns: Amount of columns side by side in the block.
- Position: The way to display the fields in the block:
- Below: Display the fields one below the other respecting the number of columns.
- Beside: Display the fields one beside the other respecting the number of columns.
- Line: Display the fields one beside the other with no tabulation.
Organization
- Next: The way to display the blocks in the page:
- Below: Set to show the following block below the current one.
- Beside: Set to show the following block beside the current one.
- Tabs: Set to show the following block in a different tab then the current one.
- Width: Set the block width in pixels or percentages. Use the symbol “%” to indicates the value in percentage.
- Collapse: Enables the option to close the block.
Create a New Block
To include new blocks in an Application, click on the button . Then, enter the name and label of the block in the following interface and finish by click on Create.
Creating application blocks configuration
Name
Name of the Block.
Label
Title of the block to display in the application.
Edit Blocks
To edit a block, click on the icon , that is on the left side of the block. Then you can see the following interface to define the parameters of the blocks. Click on Save to finish.
Application Block editing interface
Name
Name of the block. #### Title
Block title for display. #### Display Title
This option, when active, allows displaying the block title. #### Title Font
Set the font family of the block title. #### Font Size
Set the font size of the block title. #### Font Color
Set the font color of the block title. #### Background Color
Set the Background Color of the block title. #### Background image
Set a Background image for the block title. #### Title Height
Height in pixels of the block title line. #### Horizontal Alignment
Horizontal Alignment of the block title (Left, Center, and Right). #### Vertical Alignment
Vertical Alignment of the block title (Top, Middle, and Bottom). #### Display Label
Display the labels of the fields in the block. #### Columns
Amount of field columns in a block. #### Columns Width
Set the field column width of the block. #### Label Color
Color of the field labels. #### Fields Organization
The way to display the fields in the block. #### Label Position
Set the position of the field labels of the block. #### Next Block
Set the position of the following block relating to the current one. #### Border Color
The border Color for the block. #### Border Width
The border Width for the block. #### Block Width
The width for the block. #### Block Height
The Height for the block. #### Cell Spacing
The Cell Spacing in the block. #### Collapse
It enables the option to close the block.
Layout Settings
ScriptCase creates an app by using default values defined per project, but you can change those values for a specific application on this interface.
Application Layout Settings
Header Template
Allows choosing the look of the application Header.
Footer Template
Allows choosing the look of the application Footer.
Button
Allows choosing the button theme for the application.
Themes
Choose one of the selected themes in the project properties. It defines the look of the application, like colors, fonts, and others.
Header & Footer
Header
Here we can define if we want to display the header or not, the application title, and fill the header variables. The header looks according to the selected template in the Layout settings interface.
Application Header Configuration
Display Header
This option determines if we want to display the header or not.
Title
Allows informing the title of the application.
Header Variables
We must fill the variable fields with one of the types available in the Combobox. Depending on the type, you need to associate content with it. Those are the types:
- Field: When you choose the option “Field”, it opens a Combobox to choose a field to associate the field value with the header.
- Title: It displays the value of “Application Title” in the header.
- Date: It displays the system’s date in “yyyy/mm/dd” format in the header. There are several display formats available, and you can change it by using the text field beside it. To access existing formats, click on the hint to see an explanation.
- Image: It displays a field to inform the name of an existing image in the server. You can select an image by clicking on the icon “Choose Image”, and you still can upload new images by using the button “Upload”. .
- Value: It displays the content of the text input. You can inform static texts and “Global Variables”. e.g. “Employee Name: [v_name]”.
Depending on the Application, you may have more than one title option.
Footer
Application Footer Settings
This page may change depending on the footer template chosen in the Layout Settings.
Display Footer
This option determines if we want to display the footer or not.
Footer Variables
We must fill the variable fields with one of the types available in the Combobox. Depending on the type, you need to associate content with it. Those are the types:
- Field: When you choose the option “Field”, it opens a Combobox to choose a field to associate the field value with the header.
- Date: It displays the system’s date in “yyyy/mm/dd” format in the header. There are several display formats available, and you can change it by using the text field beside it. To access existing formats, click on the hint to see an explanation.
- Image: It displays a field to inform the name of an existing image in the server. You can select an image by clicking on the icon “Choose Image”, and you still can upload new images by using the button “Upload”. .
- Value: It displays the content of the text input. You can inform static texts and “Global Variables”. e.g. “Employee Name: [v_name]”.
Dynamic Search
This feature allows the end-user to search for records without leaving the current screen. The developer must inform the available fields for search.
Settings
Dynamic Search Settings Interface
- Use the ENTER key to : It allows you to define the action that the Enter Key has on the Search form. Tabulate enables you to navigate between fields, and Submit performs the search(activates the Search button).
Select Fields
This interface allows to select the available fields in the Dynamic Search.
Dynamic Search Field Selection.
Fields
This is a list of fields available for use in the filter. Click on the desired field to access the configuration instructions.