Query Based Data Element (QBDE)
In Unifier, a Query Based Data Element (QBDE) enables you to view data from the Upper Form or Detail form of a Business Process. QBDE also enables you to 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. See the "Configure a Query for a Query Based Data Element on a BP" for additional details.
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 Template
Evaluating Query Setups of Data Picker Data Elements
Unifier 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 (Unifier Application in the browser), 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
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.
See Also
Using Formulas or Conditions in Queries
Assignee Filter Query Condition
Defining the Format of the Currency for QBDE
Last Published Friday, February 2, 2024