Process Flow Overview of Effectivity Services with Query Builder and Tree Grid View

Combining Effectivity Services with the Query Builder and Tree Grid View applications is one of the native ways to visualize the results of the effectivity resolution process in the user interface.

The intended use of the Query Builder application is to create Query Definitions which are reusable AML requests. For more information about using Query Builder, refer to the Aras Innovator 37– Query Builder Guide.

The Tree Grid View application enables you to build a visual data structure. For more information about Tree Grid View, refer to the Aras Innovator 37 – Tree Grid View Administrator Guide.

Effectivity Services acts as an interlayer in the native Query Definition process flow. The Effectivity Resolution Engine performs additional processing on the items requested by Query Definition.

Figure 4 illustrates the process flow for Effectivity Services combined with Query Builder and Tree Grid View.

Figure 4.

1. The configured Tree Grid View uses its associated Query Definition to query data to display. For information on how to configure the Tree Grid View, refer to section Creating a Tree Grid View to Display Effective Items.

2. The Query Builder Engine processes the received Query Definition to retrieve data from a database (DB) and return it. To complete this task, the Query Builder Engine prepares and sends the AML request internally. For information on how to configure the Query Definition, refer to section Creating a Query Definition to Filter by Effectivity Creating a Query Definition to Filter by Effectivity.

3. The Effectivity Resolution Engine receives the AML request from the Query Builder Engine, gets the necessary data from a DB by applying the request, and filters data according to the Effectivity Criteria.

4. The Effectivity Resolution Engine prepares the AML response containing the effective items and sends it back to the Query Builder Engine.
5. The Query Builder Engine receives and processes the requested data according to the requirements of the regular query execution flow.
6. The Query Builder Engine sends the items structure to the Tree Grid View to display.