Filter on Form Aplication

Filter on Form Aplication

This application filters data that will be displayed on editing forms. This type of application necessarily works linked to a form.

 The table used to create this application must be the same as the one used to create the form.

In this article we will show you how to configure a filter application.

 

After creating the filter application, using the same table as the form, follow the steps below:

 

 

1. First, we must select the fields that will be present in the filter.

    In the application settings, in the side menu access Filter> Field positioning.

 


 

2. Next, we must create an application-type connection, with the form that will have the filter.

    To create this link, in the application settings in the side menu go to Links> New Link



 

3. Next, a list of available applications for creating the filter will be displayed.

 


 

4. Now, a screen will be displayed with the fields of the filter to make the association with the fields of the form.



 

5. Finally, a screen for the connection settings will be displayed.

    With some settings like Link operation mode, which sets the way the filter will be displayed.



    • Related Articles

    • Filter Connection

      Some databases use schemes to organize internally their data, just like Oracle, PostgreSQL, and SQL Server. Such feature is great when known and used correctly. The problem is when the database has a lot of schemes, that results in delay at the time ...
    • Using two search applications to access a form

      In this example we are going to create 2 applications of the "Search" type, and 1 application of the "Form" type. In the Search type applications, we will use the "customers" and "orders" tables, however, we will select only a few fields from each ...
    • How to change the application's state in run time

      To change the properties of application execution, changing their form of execution than initially planned, Scriptcase has a macro called sc_apl_conf. The macro should be used as follows: sc_apl_conf ( Application , property , value ) ; So, we can ...
    • How to create a capture link

      Capture Link: Used for the grid filter form, it imports data from another grid into the filter form field. Selecting the capture link type will display a list of fields in the filter form so that you select the field that will receive the data ...
    • How to create an application link

      Application Link: This is used to link the application with any other type of project application. This type of link is associated with insert and update events. How to do an application link: Open your application and go to the “Application Links” ...
    • Popular Articles

    • Examples for diagrams

      This tutorial shows how you can import and use the new examples for diagrams released with Scriptpcase V9.2.16.  The applications were created using the components: Jsmind, JKanban e Orgchart.  - Sample 1: Mind Map diagram Click here to  execute the ...
    • PHP functions necessary for ScriptCase

      In PHP , there are some essential functions for the operation of Scriptcase .  On some servers , these functions are disabled , this makes the Scriptcase not work properly.  If you're using a shared hosting server, you'll need to contact the host ...
    • Oracle Connection - Scriptcase 9 - Linux 64 Bits

      This procedure will only work if you have a Scriptcase manual installation in your server. Installing PHP 7.0 Installing the Scriptcase Manually To connect with Oracle in a Linux System, we must follow these steps below: Step 1 -  Installing these ...
    • Using friendly URL

      The friendly URL was included from Scriptcase 7, in order to make the URL, of the applications generated by Scriptcase, cleaner and easier to associate them with applications. For example, using friendly URLs the link to a Scriptcase application ...
    • Correcting access error for the Scriptcase database

      Sometimes we encounter an error accessing the Scriptcase database itself, as shown in the image below:   This problem happens when we change the folder name of the scriptcase to another name, such as "sc". Then, the error happens because the complete ...