E1: ORCH: How to Select Multiple Rows and add a Filter for row Selection in a Form Service Request (available starting with TR 9.2.5.2)
(Doc ID 2753390.1)
Last updated on SEPTEMBER 10, 2024
Applies to:
JD Edwards EnterpriseOne Tools - Version 9.2 and laterInformation in this document applies to any platform.
Goal
Starting with Studio release 9.2.5.2, when creating a form service request these two new features are available, providing more flexibility and eliminating the need for custom groovy steps.
1. Select Multiple Rows
The Select Row action can now take a list of comma separated integers to select many rows. The value can be sent as a variable and/or the default value.
2. Row Filtering
A filter can be added to select and update on non-QBE columns to find the rows to select or update. If the grid has any non-QBE columns, a 'Filter' check box appears next to the action when selected.
When selecting the filter icon, a popup opens containing all the no-QBE columns in the grid.
Conditions can be added to one or more columns with literal values or variables using ${<var>} notation.
The Filter option does not work on Return Values, it only works for finding rows to select or update.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Example 1: Enter a Sales order with multiple lines. Then, updates the Description 2 column for all the rows with "item 210". Then, it cancels all lines with backorder qty >0. |
| Example 2: Select rows for price update. |
| Example 3: Update multiple line numbers using variables. |
| References |