Feedback Print

Search

Settings

With this interface, you can define general options of the Search Form.

Search configuration Interface. 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.

Search Criteria

With this interface, you can configure the conditions available for each field of the Search form.

Search configuration Interface. 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 the table below we are able to set all the options that will be part of the application “Grid Search”.

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. Labels with opened treeview

Start close

It displays the full description of the tags as text. Labels with closed treeview

Select fields

![Interface for filter fields selection.][filtro_avancado_configuracao_selecionar_campos] Interface for filter fields selection.

Required

Defines which fields of application will be required for the Search.

![Required fields interface.][filtro_avancado_configuracao_campos_obrigatorios] Required fields interface.

The application generated will be displayed a bullet (*) next to the field and an error message is generated if not assigned no value.

![Configuration interface of the marker placement.][filtro_avancado_configuracao_campos_obrigatorios_posicionamento] Configuration interface of the marker placement.

  • Marker position : Marker’s position relative to the field.
  • Display message : Displays whether or not the validation error message.

Toobar

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. Toolbar Interface.

  • 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 Online Buttons in the button settings.

Button Settings

Button Settings Interface. Button Settings Interface.

  • Hotkey: Allows you to set keyboard hotkeys to a button.
  • Use Inline Buttons: Allows alignment of the filter buttons next to the fields.
  • 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. Options Interface.

  • Button Position(Top/Bottom) Positioning the buttons of the toolbar Top/Bottom.

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.

Save Filter Interface. Save Filter Interface.

Events

In event blocks can be used global variables, local, JavaScript code, CSS codes and Scriptcase macros.

onScriptInit

This event occurs when the application scripts are started. It runs before the OnLoad events(when present), however, it will always be executed when running, reloading or navigating the application.

onRefresh

This event runs when the refresh option of the application is enabled.

onSave

This event runs when the application saves the record.

onValidate

This event runs when validating the information of the fields, when submitting the form.

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 Application Block configuration

On the left side of each block, there are two icons, the first one Application Block configuration to edit the information of the block and the second one Application Block configuration 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 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

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 :
    1. Above: Display the label above the field.
    2. Beside: Display the label beside the field.
    3. 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:
    1. Below: Display the fields one below the other respecting the number of columns.
    2. Beside: Display the fields one beside the other respecting the number of columns.
    3. Line: Display the fields one beside the other with no tabulation.

      Organization

  • Next: The way to display the blocks in the page:
    1. Below: Set to show the following block below the current one.
    2. Beside: Set to show the following block beside the current one.
    3. 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 Creating application blocks configuration. Then, enter the name and label of the block in the following interface and finish by click on Create.

Creating application blocks configuration 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 Creating application blocks configuration, 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 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 Display Theme Configuration Application Layout Settings

Header Template

Allows choosing the look of the application Header.

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.

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 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”. Application Footer configuration.
  • 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.

Application Footer Configuration Application Footer Settings

This page may change depending on the footer template chosen in the Layout Settings.

This option determines if we want to display the footer or not.

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”. Application Footer configuration.
  • Value: It displays the content of the text input. You can inform static texts and “Global Variables”. e.g. “Employee Name: [v_name]”.

Fields

This is a list of fields available for use in the filter. Click on the desired field to access the configuration instructions.

Text Field Field Select
Integer Field Field Double Select
Decimal Field Field Checkbox
Currency Field Field Radio
Date Field Field Text Auto-Complete
Field time Field Number Auto-Complete
Field Datetime