In Creating a Conditional Constraint Using the Constraints Tab, a constraint was added to the join that specifies if the widgetId of the availRequest element is equal to the widgetId of the priceRequest element the merged repeating element quoteResponse be returned. Creating a constraint using the Where Clause Expression pane of the Constraints tab adds a where clause to the XQuery for loops which limits the target repeating elements which are returned during run time. During run time, the for loop will iterate only over those repeating elements that meet the complex condition.. In this section you add another condition (resulting in a complex condition) to the where of the for loop to further limit what is returned by the for loop as shown in the figure.
To Add a Condition to the Join in the Data Transformation Tutorial
The New Application dialog box is displayed.
c:\bea\weblogic81\samples\domains\integration
Your Tutorial Process application is created and displayed in the Application tab.
The directories and files that make up the Tutorial project are displayed.
The DTF, XQ, and JPD files used in the tutorial are displayed. These files are part of the Tutorial project.
The single condition that makes up the where clause is displayed in Where Clause Expression pane of the Constraints tab.
The Join Type determines how the conditions that make up where clause are evaluated during run time.
The second condition is added to the where clause of the for loop.
The Open XML File to Test dialog box is displayed.
The Open XML File to Test dialog box is displayed.
If not currently running, the WebLogic Server for the current application will be started. In order for a query to run, the WebLogic Server for the current application must be running.
In the Result Data pane, a graphical representation of the target data is displayed. The XML result for this example is also displayed in Figure: Complex Constraint.
During run time, the where clause limits what is returned by the for loop. If the two widgetIds are equal and the requestedQuanity is less than 50, the quoteResponse element is returned.
![]() |
![]() |