Go to Scriptcase store
  1. Home
  2. applications
  3. search application
  4. Creating a Search Application

Creating a Search Application

New Application

The process of creating an application is quite simple and intuitive.

You only need to select the type of application you want to generate from the list of applications available in Scriptcase, and it will be generated automatically.

List of applications that can be created.

Application Data

Required fields for creating applications

Connection

This field lists all connections in the project and defines the connection that will be used by the application.

Select the connection to list the database tables.

Connection with Data Dictionary

Connection field on the application data screen

When the selected connection has a Data Dictionary linked to it, the dictionary name will be displayed below the Connection field.

This information indicates that the connection has a configured dictionary, which can be used to fill in the field labels with lang in the generated applications.

By clicking the dictionary name, a screen will be displayed where you can link new tables to the Data Dictionary. Use this option if the table selected to create the application has not yet been configured in the dictionary.

For more details, access the Data Dictionary documentation.

Name

Defines the name of the application that will be created. This field is required and must contain between 1 and 64 characters.

Alphanumeric characters, period (.), hyphen (-), and underscore (_) are allowed. Spaces and other special characters are not allowed.

Table

Defines the table that will be used as the application’s data source.

After selecting the table, the available fields will be listed in the Fields field, allowing you to define which fields will be part of the application.

Fields

Defines the fields that will be part of the applications.

Localization

Defines the default language of the application that will be created. By default, Scriptcase selects the Inherit project default language option, making the application automatically use the language defined as default in the project properties.

If necessary, you can select a specific language for the application. In this case, the application will use the selected language, regardless of the default language defined in the project.

Application language selection field

After creating the application, the application language can be changed in Application > Settings. If the Inherit project default language option is selected, the language used will be defined by the project’s default language, which can be changed in Project > Properties.

Edit language charset

You can also change the charset used by the language in the application being created. To change the charset, click the edit button displayed next to the language selection field.

Edit language button

When clicking the button, the option to change the charset of the selected language will be displayed.

Edit language button options

Note: This change will be applied only to the application being created. The charset defined for the languages in the project settings will not be changed.

SELECT Command

Displays the SELECT command generated after selecting the tables and fields. This field also allows inserting a previously created SQL statement, as long as it uses tables that exist in the database selected in the connection.

SQL Builder

Opens the SQL Builder in a new browser tab.

This resource allows you to build the SQL command in an assisted way by selecting tables, fields, conditions, sorting, and relationships to generate a custom SELECT.

After building the command, it can be incorporated into the SELECT Command field of the Grid.

Recognize foreign keys and create JOINs automatically

Automatically generates the application’s SELECT command using JOINs, based on the foreign keys existing in the selected table.

This resource is available only when using one table to create the Grid. If the selected table does not have foreign keys configured in the database, the JOINs will not be created automatically.

Relationship

When selecting two or more tables, the “Relationship” tab will be displayed. In this tab, you can view the relationships created between the selected tables.

The relationship will be created and validated automatically, based on the table foreign key configuration.

  • OK (Green lines) - The relationship is correct according to the table configuration.
  • Error (Red line) - The relationship is incorrect according to the table configuration.
  • Saved by user (Yellow lines) - Saved by the user.

This relationship screen is built based on the tables selected in the tables field. If the JOIN is created directly in the SQL field, the tab will not be displayed.

Application relationship screen

Edit Fields

This screen displays the fields from the selected tables and allows you to make adjustments before creating the application, such as changing the data type, display name, and other settings.

List of fields in the grid creation process

  • Fields - Lists the fields from the table used to create the application.
  • Label - Defines the text displayed for the field in the generated applications. When the table is associated with a data dictionary, Scriptcase uses the language variables associated with the fields and displays the translation icon, allowing you to change the text of the lang used in the label.
  • Data type - Defines the field data type, such as text, number, date, or other formats used by the application.
  • Search - Defines whether the field will be available in the application Search.