Feedback Print

Search options

Settings

In the area below you can define all the options that’ll be part of the of the Search Form.

Search configuration Interface. Search configuration Interface.

  • Attributes

  • Search Criteria : Allows to select the SQL command AND or OR to define the criteria of the search used;
  • Display Condition : Displays the condition of the search for the user to choose. In this case “AND” or “OR” will display in the search form, so that the user can choose the desired option.
  • Use auto-complete in the fields : The field turns into an autocomplete automatically according to the existing values in the database, If the user chooses Yes, the autocomplete will enable automatically in all the fields that contain a relationship. If the user chooses No no autocompletes will be displayed. In the case the option selected is Defined in the field it’ll respect the configuration individually for each field.

Search Criteria

Search configuration Interface. Search configuration Interface.

In this interface, you can configure the conditions for each field of the Search form when filtering the SQL, on the left combo is displayed the field. The combo on the right are listed the options for filtering the selected field, to select the options just click on them (Equal to, Beginning with, Contains and etc.) and the button On/Off. The arrows on the right allows to alter 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 selected option.
  • All : Marks all fields or options.
  • None : Un marks all the fields or options.

Advanced Search

Settings

Through the table below we set all the options that will be part of the application Grid Search.

Interface Configuração do Filtro Avançado

  • Horizontal Alignment : Allows you to define the positioning by aligning horizontally the Search Form.
  • Margins : Allows to position the margins of the Search Form.
  • Keep Values : When enabled, the values from the search is maintained when the user returns to the search form.
  • Keep Columns and Order Selection : allows you to determine whether, at each filter, the values selected for the query and sort fields must be preserved, that is, at each filter, these values return to the original condition.
  • Use Enter to : Allows you to define the action that the Enter Key will have on the Search screen. Tabulate allows you to navigate between fields and Submit performs the search(activates the Search button).
  • Display Tags : Allows to display the Searches used for the Grid in the form of tags.
  • Display after filtering: When enabling, tags will be displayed after performing an advanced search, if disabled, tags will always be displayed regardless of performing an advanced search.
  • Unify results : Sets the number of characters 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 : This option works only if the Treeview is being used and it sets the initial state of the Treeview.
    • Start open : Displaying the tags Etiquetas com treeview aberto
    • Start close : Showing full description as text Etiquetas com treeview fechado.

Select fields

Interface for filter fields selection.

*Interface for filter fields selection.

Required

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

Required fields interface. 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. 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 to organize search profiles, it creates an option Save Filter in a Search application, this way it is possible to save the search done previously. You can add some rules. With these details you can save a search done by the user login.

Save Filter Interface. Save Filter Interface.

Save Filter Interface. Save Filter Interface.

Events

In events, blocks can be used with 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

On this module are available the features of editing, attributes and display of the application, in a way that you can apply display themes, organize blocks, define values and the format of the Header/Footer and etc.

Blocks

Conceptually a block is a “container” where you can position the fields of the Applications: Form, Control or Grid with Slide orientation.

By default, the applications created in ScriptCase are built with a only one block, with the same name as the application. You can add the amount of blocks that you want to organize in a more convenient way. The page below, observe that theirs a column Organization, and that is where you’ll define if the next block will be set beside or below the current one.

Application Block configuration Application Block configuration

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

    • Attributes
      • Block
        • Name : Name of the Block.
        • Label : Title of the block that’ll be displayed in the application.
      • Title
        • Display : Flag that controls the title display of the block.
      • Label
        • Display : Flag that controls id the label of the fields will be displayed in the block.
        • Position : Options to display label :
          • Above : The label will be displayed above the field.
          • Beside : The label will be displayed beside the field.
          • Below : The label will be displayed below the field.
      • Fields
        • Columns : Amount of columns that are displayed side by side in the block.
        • Position : The way that the fields are displayed in the block :
          • Below : The fields are displayed one below the other respecting the amount of columns.
          • Beside : The fields are displayed one beside the other respecting the amount of columns.
          • Line : The fields are displayed one beside the other without the tabulation.
      • Organization
        • Next : The way that the blocks are displayed in the page:
          • Below : Indicates that the next block will be placed below the current one.
          • Beside : Indicates that the next block will be placed beside the current one.
          • Tabs : Indicates that the next block will be placed in a different tab then the current one.
        • Width : Specifies the width that block will occupy in pixels or percentage, in case the value is in percentage, inform the (%).
        • Collapse : Enables the option to close the block.
  • Create New Block

    To include new blocks in an Application, click on the button Creating application blocks configuration. Next, you’ll see the following interface to define the name and label of the block. At the end click on Create.

    Creating application blocks configuration Creating application blocks configuration

    • Attributes
      • Name : Name of the Block.
      • Label : Title of the block that’ll be displayed in the application.
  • Edit Blocks

    To edit a block just click on the icon Creating application blocks configuration, that is on the left side of the block. Next, you’ll see the following interface to define the parameters of the blocks. At the end click on save.

    Application Block editing interface Application Block editing interface

    • Attributes
      • Name : Name of the block.
      • Title : Block title for display.
      • Display Title : This option, when active, allows to display the block title.
      • Title Font : Font applied to the block title.
      • Font Size : Size of the font applied to the block title.
      • Font Color : Font color for the block title.
      • Background Color : Background Color of the block title.
      • Background image : 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 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 : How the width of the block is defined.
      • Label Color : Color of the field labels.
      • Fields Organization : How the fields are organized in the block.
      • Label Position : Position of the field labels relating to the data.
      • Next Block : Position of the next block relating to the current block.
      • Border Color : Border color for the block.
      • Border Width : Border Width for the block.
      • Block Width : Width for the block.
      • Block Height : Height for the block.
      • Cell Spacing : Cell Spacing in the block.
      • Collapse : Enables the option to close the block.

Layout Settings

On this interface, you can define the theme for display of a specific application, this being because ScriptCase uses a Standard Definition of Values per project, that besides the Display Theme, allows to define values for other attributes on a Project level.

Application Display Theme Configuration Application Display Theme Configuration

  • Display Configuration
    • Header Template : Allows to choose the template that’s going to be used as the Header of the application.
    • Footer Template : Allows to choose the template that’s going to be used as the Footer of the application.
    • Button : Allows to choose the button theme for the application.
    • Themes : Choose one of the existing themes, it’ll load the display mode (colors ,fonts, etc.) that’ll be part of the application.

In this block, it’s the definition of the variables content that’ll be part of the header.

Application Header Configuration Application Header Configuration

This page may change depending on the header format chosen in the Layout Settings.

  • Display Header : This option determines if the header will display.
  • Title : Allows to inform the title displayed in the application.
  • Header Variables : The field variables can be informed with anyone of displayed in the Combo box. Depending on the type, it’ll be necessary to associate the content with the field. Below there are the types of content:
    • Field : When you choose the option “Field”, it’ll open a Combo box beside to choose the field you want. Selecting the desired field, it’ll associate the value of the field with the header.
    • Title : This option when selected it’ll display in the header the value informed in the “Application Title”.
    • Date : When selected the “Date” type, it’ll display the system’s date in the header. There are a diversity of formats using the date and time of the server. The format can be informed in the text field that appears beside the field. To access the existing formats, click on the icon and you’ll view a page display the formats.
    • Image : When selecting the image type, it displays a field to inform the name of the existing image in the server. To locate the images existing and selecting one, click the icon “Choose Image” and to upload new images click on the button “UploadApplication Footer configuration.
    • Value : When selecting the type “Value”, the content informed in the text field that appears beside, it’ll be displayed in the header, you can inform 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 Configuration

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

  • Display Footer : This option determines if the footer will display.
  • Footer Variables : The field variables can be informed with anyone of displayed in the Combo box. Depending on the type, it’ll be necessary to associate the content with the field. Below there are the types of content:
    • Field : When you choose the option “Field”, it’ll open a Combo box beside to choose the field you want. Selecting the desired field, it’ll associate the value of the field with the footer.
    • Date : When selected the “Date” type, it’ll display the system’s date in the footer. There are a diversity of formats using the date and time of the server. The format can be informed in the text field that appears beside the field. To access the existing formats, click on the icon and you’ll view a page display the formats.
    • Image : When selecting the image type, it displays a field to inform the name of the existing image in the server. To locate the images existing and selecting one, click the icon “Choose Image” and to upload new images click on the button “Upload” .
    • Value : When selecting the type “Value”, the content informed in the text field that appears beside, it’ll be displayed in the footer, you can inform texts and “Global Variables”. e.g. “Employee Name: [v_name]”.

Dynamic Search

This feature allows the user to search records the application without leaving the current screen, the developer needs to indicate which fields will be available.

Settings

Dynamic Search configuration Interface. Dynamic Search configuration Interface

  • Use the ENTER key to : Use the Enter key to tabulate from one field to the other, or to submit the search.

Select Fields

Dynamic Search Field Selection. Dynamic Search Field Selection.

QuickSearch

Quick Search is an option that allows to search data in various fields of the application, by using the text box in the toolbar.

Application running QuickSearch. Application running QuickSearch.

QuickSearch Settings

In the quicksearch settings are the following options:

QuickSearch Configuration Interface. QuickSearch Configuration Interface.

Button within the search - An option to inform if the search button will be in the text area of the box. Quicksearch show combo box - Displays a combo box if there is only one option in the quicksearch. Quicksearch Watermark - Displays a Placeholder in the quicksearch. Quicksearch width - Defines the width of the Quicksearch field. Display the Quick search old format - Displays in the old format with the selection of the fields in the Quick search. Search anywhere - If enabled, QuickSearch will search each part of the String for the data informed in the field.

Select Fields

You need to define the fields that are part of the search in the Quicksearch Settings .

QuickSearch selecting fields Interface. QuickSearch selecting fields Interface.

And you can select various criteria of the search.

QuickSearch search criteria configuration Interface. QuickSearch search criteria configuration Interface.

You need to add the QuickSearch button in the toolbar in order to use it.

Fields

You can check the Search’s fields settings by clicking here .