Setting up the master for columns

What is a master

A master is a fundamental table required for data processing. Specifically, tables that serve as basic information and are less frequently changed in daily operations, such as 'product master' and 'employee master', are referred to as masters. By preparing a master, you can call up the necessary information from the master whenever necessary.

../../../_images/img_01.en258.png

What you can do with master settings

In creating a CELF Web App, you can associate a master with the columns of the selected table. By associating a master, you can, for example, display the 'product name' in the 'product master' instead of displaying the 'product code' which is the column data of the table, or select from the list of 'product names' in the 'product master' instead of entering the 'product code'.

  • Using master by dropdown list

    ../../../_images/img_02.en244.png

  • Using master by search list dialog

    ../../../_images/img_03.en206.png

Associating the original table with the master table

Click the 'Set' button of the column you want to set via a master table, and display the master settings dialog.

../../../_images/img_04.en177.png

  1. Select the table that will be the master of the column in the original table.

    Tip

    You can also select a CELF management table as the master table.

  2. Select the master column to be associated with the column in the original table.

    Tip

    You can only select columns in the master table that have the same data type as the columns in the original table.

  3. Select the master column to display instead of the column data in the original table.

  4. Add columns from the master table and the original table as needed to display the desired master column values.

    Tip

    You can only select columns in the master table that have the same data type as the columns in the original table.

  5. Add other refinement conditions as needed.

    Use for refinement when data within a master, like a division value master, is categorized in a column.
    You can specify either a fixed value or a column value from the original table as a filter condition.
    ../../../_images/img_05.en160.png

  6. Specify the method of selecting the column data in the original table.

    In the case of 'From dropdown list', the method of selecting column data becomes a dropdown list to select the display column of the master.
    In the case of 'From search list dialog', the method of selecting column data becomes a search list dialog to list and refine the selection of the master.

  7. Click the 'Next' button.

    Display the screen to customize the operation of the master table.
    If you selected 'From dropdown list', you will finish without customizing the operation of the master table.

Customizing the operation of the master table

Customizing the operation of the master table is the same as customizing the operation of the app except for the following points.

  • In 'Setting the visibility and editability of columns', only search conditions and search results are set.

  • In 'Setting the master of columns', the method of selecting data is only 'From dropdown list'.

  • There is no 'Setting related tables'.

    Tip

    Master table data is used only for search conditions and search results, as it is displayed in the search list dialog.