Query Based Data Element (QBDE)
A Query Based Data Element (QBDE) lets you view data from the Upper Form or Detail form of a Business Process. QBDE also lets you view data from:
- Other Business Processes
- Sheets
- Cash Flow
The QBDEs are based on the “SYS Numeric Query Based” Data Definition (DD), and the query for these QBDEs is set in the Business Process Configuration setup. For more information, see Configure a Query for a Query Based Data Element on a BP in the Unifier Modules Setup Administration Guide.
In addition to the Web interface (Unifier application in the browser), the system evaluates QBDE in the following areas:
- CSV import for record creation
- CSV import for Line Item creation
- Web Service methods for record creation along with Line items
- Web Service methods for Line Item creation
- Web Service methods for record updates
- Bulk Edit
- Bulk Update
- Creating BP records using BP
Note: Oracle recommends that you do not use a Required field to create a query that uses a Data Picker, Cost Breakdown Structure (CBS) Picker, or Fund Breakdown Structure (FBS) Picker. If the data entered in a data element (DE) field with a Required condition is cleared, the system bases the query on the previous value of the field.
Evaluating Query Setups of Data Picker Data Elements
The system supports many types of Data Picker DEs. The Administrator can set up Query conditions on these Data Picker DEs to filter the results. When a Data Picker DE is launched in the Web interface, the system runs the query and displays the records based on the queries defined in uDesigner. The system evaluates the data picker query conditions in the following areas, as well:
- CSV import for record creation
- CSV import for Line Item creation
- Web Service methods for record creation along with Line items
- Web Service methods for Line Item creation
- Web Service methods for record updates
The following is a list of the supported Data Pickers:
- BP Data Picker
- Shell Data Picker
- User Data Picker
- CM Data Picker
- Role Data Picker
Note: If a BP Data Picker (BP Picker) or any Data Picker is selected as a trigger element for QBDE and the picker value is automatically populated (auto populated) instead of manual entered, the QBDE element will not be evaluated.
For more information about importing data, see Importing Configuration Packages in the Unifier Modules Setup Administration Guide.
Creating a Record from the Query Based Tab
When creating a record from the Query Based tab of another BP (that auto-populates data to the record being created), the Data Element (DE) of type “SYS Numeric Query Based” Data Definition (any DE of this type) is not updated, unless the user manually changes the trigger element.
If a query condition involves only constant dates, it is not converted based on the user's timezone.
See Also
Using Formulas or Conditions in Queries
Assignee Filter Query Condition
Defining the Format of the Currency for QBDE
Last Published Tuesday, December 12, 2023