Working with Business Object Designer
The Business Object Designer (BOD) is an administrator-level tool for viewing, editing, and creating business objects especially for iMIS. It provides a graphical user interface to the properties related to business objects.
Warning! Do not share a login while using the Business Object Designer. Using the same login to concurrently access and edit business objects can cause business objects to be overwritten, properties to be incorrectly modified, and will corrupt your business objects.
Do the following to explore Business Object Designer:
- Go to RiSE > Business Object Designer.
- Select a business object in the list, such as Campaign.
- Click Edit.
- Explore the Definition, Properties and Database tabs.
Note: You cannot edit a locked Business Object. You must save a copy of a locked Business Object and make edits to the saved copy.
In This Article
- Accessing business objects
Finding underlying table data for business objects
Building a new business object
Managing business object properties
Commonly queried CsObjects include but are not limited to the following | ||
---|---|---|
CsActivity | CsDuesHisotry | CsOrderLines |
CsAddress | CsEvent | CsOrders |
CsCalls | CsEventHistory | CsPledges |
CsCommittee | CsFunction | CsProduct |
CsContactBasic | CsGeneralLookupTables | CsRegistration |
CsDonations | CsInventory | CsRelationship |
CsDonationsDetail | CsMemberType | CsStaffUser |
CsDonorData | CsOrderHistory | CsSubscriptions |
These objects include but are not limited to the following | ||
---|---|---|
AccessArea | User | |
AccessItem | Role | UserRole |
AccessMain | UniformRegistry | UserToken |
Accessing business objects
Note: You must have system-level administrator privileges to perform the tasks discussed in this section. Having administrator privileges for a given module is not sufficient authority to change business objects.
Business objects are central to creating IQA queries, generating reports, and running processes. You can view the list of available business objects by navigating from the Staff site to RiSE > Business Object Designer.
Finding underlying table data for business objects
Business objects are user-friendly abstractions and collections of data from the iMIS tables. These abstractions enable you to write powerful queries and reports safely, without needing to be familiar with the iMIS database schema.
In most cases, the business object name and the names of its various properties are suggestive enough to guide experimentation. At times, however, it can be useful to trace the properties of a business object to their underlying table columns. Do the following to trace business object properties to their underlying table data.
Important! It is recommended to exercise caution when using dynamic group views (those beginning with vlqa) in custom business objects, as they may lead to poor performing queries, or may present problems if the dynamic groups are changed in the future.
- Go to RiSE > Business Object Designer.
- Double-click the business object that you want to examine.
- (Properties tab > Definition sub-tab) Select the property that you want to trace. The Database table and Database column fields specify the table and column from which the property derives its data.
- (Database tab) It can also be useful to examine the table joins used in a business object that comprises multiple tables. Examine the Joins field.
Note: Some business objects might use the term Appeal to refer to Source Codes.
Building a new business object
To build a new business object you should build a new SQL table or view (or identify an existing one to use), customize the properties for the new business object, then build and publish the new business object.
Note: If no table exists for this business object, open SQL Server and create it, granting appropriate permissions.
- Go to RiSE > Business Object Designer.
- Select New > Design Business Definition.
- (Definition tab) Enter the business object's information.
- Click Create Object.
- Add properties to the business object, saving after you edit each tab:
- (Database tab) Add the Tables that contain the columns you want to use in your business object. In the Available Columns list, select which columns to use.
- Click Add as Properties or Add All as Properties.
- Select Save.
- (Properties tab) Select properties from the list to define the property's characteristics. To create a lookup, select the field you want to edit.
- (Properties tab > Values sub-tab) Define any lookups you need.
- Edit these values as needed.
- Click Save.
- Build and publish the new business object:
- Select the new object.
- Click Edit.
- Click Publish.
Note: If an error occurs when publishing the business object, check the Database tab and ensure that appropriate Joins are defined if more than one table is listed in the Tables list.
Managing business object properties
Changing property displays
A property’s display determines what your users see in iMIS. The property’s display value is used by default on windows and outputs, but you can design queries to override these defaults.
- Go to RiSE > Business Object Designer.
- Select an object from the list.
- Click Edit.
- (Properties tab) Select the property to be changed.
- (Properties tab > Display sub-tab) Change the value of Prompt for field.
- Click Save, and then Publish. Any messages should state that there are no errors.
- Click Close.
- Test your changes. Write a query against the object and select the updated property on the Display tab.
Adding value lists to properties
Adding Value lists to properties can make querying and data entry easier for end users. Value lists define the values that can be stored or selected for a property. There are three ways of adding Value lists to properties:
Defining property values using IQA
Use IQA to query the values from an object within the database, for example, General Look Up tables or CsActivityTypes.
Important! It is recommended to exercise caution when using dynamic group views (those beginning with vlqa) in custom business objects, as they may lead to poor performing queries, or may present problems if the dynamic groups are changed in the future.
Selecting values to display for a property
Do the following to select values to display for a property:
- Go to RiSE > Business Object Designer.
- Select an object from the list.
- Click Edit.
- (Properties tab) Select the property that needs values.
- (Properties tab > Values sub-tab) Select the Query object radio button.
- Browse for and select the query you saved.
- Define the Data value to match the code that exists in the data.
- Define the Display value to match the expanded description that describes the Data value.
- Click Save, and then Publish. Any messages should state that there are no errors.
- Test your changes. Write a query against the object. Select the property on the Filters tab, and confirm that it now includes a value list.
Building a value display manually
Manually add the codes and expansions to the property within the business object. The Business Object Designer allows for value displays to be built directly within the object itself.
- Go to RiSE > Business Object Designer.
- Select an object from the list.
- Click Edit.
- (Properties tab) Select the property that needs values.
- (Properties tab > Values sub-tab) Select the Value list radio button.
- Build your value list by entering the code into the Data Value property column, and the expanded description for the code into the Display Value column.
- Click Save, and then Publish. Any messages should state that there are no errors.
- Click Close.
- Test your changes. Write a query against the object. Select the property on the Filters tab, and confirm that it now includes a value list.
Note: The Data Value can match the Display Value as long as the code value is not longer than the Data Type allows. Spaces can be used as well.
In many ways, using IQA to manage value lists is the most flexible and user-friendly way to manage a lookup. Values can be added to look up tables and to the modules within iMIS. Interfaces can be modified by adding values to a table that otherwise would not be available to users. These interfaces can be accessed by users who do not have the SysAdmin role access in iMIS. Value lists that are managed within the business object can only be managed through the Business Object Designer.
Adding properties to business objects
You can add new properties to your objects that are based on a table or view in your iMIS database.
- Go to RiSE > Business Object Designer.
- Select an object from the list.
- Click Edit.
- (Database tab) Select the property from the Available Columns that you want to add to the object.
- Click Add as Properties or Add All as Properties to move the property from Available Columns to Used Columns.
- Click Save, and then Publish. Any messages should state that there are no errors.
- Test your changes by writing a query against the object. Add the new property on the Display tab.
Important! It is recommended to exercise caution when using dynamic group views (those beginning with vlqa) in custom business objects, as they may lead to poor performing queries, or may present problems if the dynamic groups are changed in the future.
Note: Any properties you add to the business object will display at the end of the list of properties displayed in the Filters and Display tabs in IQA.
Modifying display properties to create hyperlinks in a query
Note: You cannot edit a locked business object. You must save a copy of a locked business object and make edits to the saved copy.
Staff can create hyperlinked websites and email addresses in query results by modifying business object properties. Create the hyperlink by selecting Email Address or Web Address from the Display control drop-down.
These links allow users to quickly open a website related to a contact or send the contact an email from the query results.
The following business objects allow for hyperlinked results out-of-the-box when used in a query:
- CsContact (Email and Website properties)
- CsContactBasic (Email and Website properties)
- NetContact (Email and Website properties)
- NetContactBasic (Email and Website properties)
- NetContactData (Email and Website properties)
To make email and website address links available in the query results, do the following:
- Go to RiSE > Business Object Designer.
- Make a copy of the CsContactBasic business object.
- (Properties tab > Display sub-tab) Select the Email property.
- Scroll to the Display control drop-down and select Email Address.
- (Properties tab > Display sub-tab) Select the Website property.
- Scroll to the Display control drop-down and select Website address.
- Save the modifications, and then Publish.
- Create a query using the business object and select the updated property on the query's Display tab.
Note: When creating the website link, ensure that you correctly enter the web address.