Business Object

You can connect multiple tables by joining them based on the Main Table. Select columns from the tables configured in the Physical Layer to set up the fields for the Business Object. The Business Object can only be set up with tables from the same Data Source.

• How to Create

1. Click on New in the Business Object List under Business Layer > Business Object to open the popup for creating a new Business Object.

2. Enter the Business Object Name. In the Table Name field, search and select the table to be used in the Business Object, then click "Next"

3. You can set up sorting or filtering by entering Sort Spec or Search Spec for specific fields during Business Object Configuration.

4. Set up the Business Object's fields by selecting columns from the chosen table to be included in the Business Object's Field List. Once configured, click Next and then Confirm to create the Business Object. If you need to include data from multiple tables related to the Main Table, set up join relationships (refer to step 6 below).

5. You can configure attributes by accessing the View Attribute menu of the newly created Business Object in the Business Object List.

   1. Sort Spec: [BO Field 1], [BO Field명 2] DESC

   2. Search Spec: [BO Field Name1] = A or [BO Field Name2] not in (BB,CC)

   3. It's recommended to set Sort Spec and Search Spec in the component rather than in the Business Object. This is because search and sorting conditions are defined based on the specific requirements of the component. Additionally, setting these conditions at the component level allows for greater flexibility when using the same Business Object across multiple components.

   4. When the Physical Delete Flag is set to No, deleting data from the component will logically delete it by updating the SYS_FLAG column in the table to 0. If it's set to Yes, the data will be physically deleted from the table.

6. Select New in the Join List and choose the associated table.

7. The Outer Flag indicates the type of join relationship between tables. Setting it to YES signifies a Left Outer Join, while setting it to NO signifies an Inner Join.

8. Join Spec specifies the join between tables by specifying columns. Set the columns from the Table included in the Business Object as the Source Field and select the columns from the target table as Target Column. You can register multiple fields and columns for joining.

9. Taget Table에서 필요한 Column을 Business Object의 신규 Field로 등록한다. Register the necessary columns from the Target Table as new fields in the Business Object.

   1. Name: Enter the name of the Field in the Business Object.
   2. Type: Set the Field type .
   3. Readonly Flag: Set whether it's read-only (YES/NO).
   4. Required Flag: Set whether it's required (YES/NO).
   5. Use Flag: Set whether it's in use (YES/NO).
   6. Join: Set the join table.
   7. Column: Set the column from the table to be displayed in the Business Object's field
   8. Calc Flag: Set it as a Business Object field calculated by formulas (YES)
      [Image1. Activating Calc Express input field when Calc Flag is set to YES] [Image 2. Example of activated Calc Express input field]

   ※You can use Excel formulas, and Business Object fields are represented as [BO Field].

   9) Default Value: Set the default value. Use JavaScript to set the default value in the Enter a function field.
   Ex1) new Date(now.getTime() + 7 _ 24 _ 60 _ 60 _ 1000); // 7 days after from current date

   Ex2) new Date(now.getTime() - 3 _ 24 _ 60 _ 60 _ 1000); // 3 days ago from current date

   10. Log Flag: Set whether to create a log. If checked as YES, a log will be created when the data of the field changes (including modifications and deletions).

Log Table: qt_sensitive_info_history

[Appendix]. Check SQL Feature

1. When you press the button initially, the SQL is constructed based on the registered Meta information (Fields, Joins, Join Specs) of the BO or AO, and the constructed SQL statement is saved for subsequent use.
2. If there are changes in the Meta information and you need to recheck the SQL, you can reconstruct the SQL statement using the [Refresh] button.