Examples of business object customizations

This example creates a business object for the Name_Note table and exercises the business object with a query.

1. Go to RiSE > Business Object Designer.
2. Select New > Design Business Definition. The New Object window is displayed.
3. Enter Name_Note as the Name for this example.
4. Click Create Object.
5. (Database tab) Click Add. A window listing all the iMIS database tables is displayed:
1. Select the Name_Note table and click OK. The Name_Note table is added to the Tables field, and its columns are added to the Available Columns field.
2. In the Available Columns field, select all the columns except Name_Note.TIME_STAMP.
3. Click Add as Properties.
4. Click Save.
6. (Properties tab > Definition sub-tab) Examine the automatically generated entries on the Description, Type, Display, and Value tabs. For the following properties, verify the Available to Query Builder and Automatically Include in Queries options are selected:
• ID
• NOTE
• NOTE_NUM
• PURPOSE
7. Click Save and then Close.
8. Click Publish.
9. Click OK and then Close.
10. Create a new query in a working folder:
1. Go to RiSE > Intelligent Query Architect.
2. Select the folder Scratch.
3. Select New > Query.
4. Enter a Name for this query.
5. (Define tab > Sources sub-tab) Click Add Source.
6. In the Document browser, go to $/Common/Business Objects.
7. Select Name_Note. Click OK to add it to the Query Sources list.
8. (Define tab > Display sub-tab) The four columns in the display set are selected.
9. Click Save As. On the Document Saver window, enter Name_Note query as the name for this query.
10. Click OK.
11. Click Run to see the sample output.
11. Generate extended results:
1. (Define tab > Sources sub-tab) Click Add Source.
2. In the Document browser, go to $/Common/Business Objects.
3. Select Name_Note. Click OK to add it to the Query Sources list.
4. Add the Name table to the business object, display FULL_NAME in the query results, and republish.
5. In Business Object designer, Edit the Name_Note business object. Select Database, and add the Name table to the Tables list. Add Name_Note.ID=Name.ID to the Joins list by selecting the columns from the left and right drop-down lists.
6. Select Columns, select Name.FULL_NAME, and add a property for the column.
7. (Properties tab > Display sub-tab) Add FullName to the Display Set.
8. Select Save, Close, Build, and Publish.
12. In IQA, open the query for this business object.
13. (Sources tab) Click the Remove icon to remove the existing source.
14. Click Add Source and re-add Name_Note.

Note: Business object changes are not automatically reflected in queries that use the business objects.

15. (Display tab) Change the order to have Id and Full Name first. Use the Refresh button as you go to confirm the order. Save the query.
16. Select Run to see the query results.
17. (Summary tab) See the SQL for the query.

The following example changes a display property on the Campaign object and shows the change from the application.

1. Go to Marketing > Campaigns > Define campaigns.
2. Select a campaign. Note the values for Name and Campaign Code. These values come from the business object.
3. Go to RiSE > Business Object Designer.
4. Select the Campaign object.
5. Click Edit.
6. (Properties tab) Select the Name property.
7. (Display sub-tab) Change the Prompt for field entry to The Campaign Name.
8. Change the Description to The Campaign Description.
9. Click Save As to save the edited business object, and then click Close.
10. Click Publish.
11. Click OK, and then Close.