My Oracle Support Banner

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 MARCH 25, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information 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.

 

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. 

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.