In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   On Demand  |   Home  |   qad.com




Adding Source Application Event Types
The business objects supplied with QXO use only a subset of QAD Enterprise Applications tables, which correspond to the set of default event types to be activated. If you create new business objects to accommodate your own business requirements that reference data from tables not already defined as events, you must add new event types and activate them. See Creating New Business Objects.
You will also need to do this if your business object includes custom tables or references tables in a non-QAD Enterprise Applications database.
Note: Additional steps are required to use new event types with business objects. These are described in Creating New Business Objects.
You can add two types of events: database triggers or business events. You also can define business events for source application types that are DDP.
Click Event Types under the source application. The Event Types overview screen displays.
Adding Database Triggers
1
Click New.
2
A Database Event Type window is displayed. Specify a table name for the database trigger event type. The table name you enter must match exactly the name of the table in the application schema that it is associated with.
If you want to create a database event type for a specific event, enter the event in the Event Filter field.

Adding a New Database Trigger Event Type
3
Click Save to save your changes.
Note: A warning message displays if the table does not exist. A warning symbol displays if the replication-write and/or replication-delete trigger is missing from the schema definition in the source application. A tooltip on this icon displays indicating if one or both of the triggers are missing.
Note: A warning symbol displays if the event type is active but not registered with any event service.
Adding Business Events
Along with database triggers, business events can be added. This allows for business processes to trigger an event, rather than a database change.
You can add a business event manually by using the Add button and specifying the business event name, or use the Import button to import business events from the source application database.
If you define business events manually, when you attempt to save the event type the system checks the source application database to ensure that the table or object you specify exists. If the system cannot find a table or object of that name, it checks the database for a business object. If the system cannot validate the business event entry, it displays an error.
To manually add a business event:
1
Click New.
2
A Business Event Type window is displayed. Specify the event name and associated table/object. The table/object name must be a valid table or a DDP business object.
If you want to create a business event type for a specific event, enter the event in the Event Filter field.

Adding a New Business Event Type
3
Select the Active check box to extract data for this event type.
4
Click Save to save your changes.
Business events can be exported by clicking the Export button. Business events are exported to the source application type folder in the events folder. For example, events for the QADEE source application type are exported to qadapps/qxtend/qxoAppserver/events/QADEE.

Exporting Business Events
QXO automatically detects business events in DDP published data and saves them as inactivated if the events are not in the QXO database.
Note: This does not apply to DDP Only source applications.
In order to be published, DDP documents must be associated with a valid business event. The system checks to verify that the business event is a valid event type for the source application and raises an exception if the event is invalid.
Searching for Database and Business Events
You can use the Filter panel on top of the database and business events lists to search for specific event types.
To search for database events, enter a table name using a wildcard (for example, *_mstr), and specify the active status; then click the Search icon.
To search for business events, enter an event, table, object name, or a combination of them using wildcards, and specify the active status; then click the Search icon. For example, enter “*/bcurrency” in the Object field to find all event types for object bcurrency; enter “create/*” in the Event field to find all objects with the “create” event type.
Search/filter criteria are not case-sensitive.