Search
View video

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.

Advanced Filter Configuration Interface

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

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

Select fields interface.

Required

This interface has the options for you to select and set the Search form required fields.

Required fields interface

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 placement configuration interface

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.

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.

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.

Inline Buttons settings.

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

Inline Buttons settings.

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.

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

This event occurs whenever the application is loaded, or reloaded. This event occurs when the application its loaded, or reload. Occurs before the application runs the SQL statement, so using this event it is possible to modify the grid SQL statement dynamically, based on any logical. Macros frequently called on this event: sc_select_field, sc_select_order, sc_select_where(add), etc.

onRefresh

This event occurs when the form its reloaded. This event occurs when the form application is reloaded, is possible to reload the form based on fields (select , radio, checkbox)

onSave

This event occurs always that some search setting is saved in the filter application. This event occurs always that some search setting is saved in the filter application.

onValidate

This event occurs when the search form is submitted. This event occours when the search form is submitted. Ex. in order to prevent some searches or to validate any search params if( strlen({name}) <= 0) { sc_error_message(" Please fill the name field before submit your search "); }

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

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

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

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

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.

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