Creating Query-Based Tab in Business Processes
To create a Query tab, go to Company Workspace tab > Admin mode > uDesigner > Business Processes:
- Select a business process.
- From the left-hand Navigator, click Query Items to open the sub-nodes.
- Click Query Tabs.
- Click New.
- In the Select Business Process window, click the drop-down list (under Select Business Process/ Attribute field), select a business process or attribute, and click OK to open the Query Tab window.
- In the Query Tab window, enter values in the Name, Description, and Reference Picker fields (this is to filter records in the Query tab).
The value for the Reference Picker field is auto-populated when a user creates a new business process record based on a QBT. In such a case, the record number of the parent record will be auto-populated and the user can edit the number and change it to a desired record number. Once the business process record is successfully created, the reference graph shows the intended business process record.
- When finished, click OK.
- From the left-hand Navigator, click Item Logs (previously, the Line Item List node) to begin designing the log. You can have a total of 8 (eight) tabs, including the Query tabs.
The log for the Items Log (previously, the Line Item List node) has several columns. The column, "Type," enables you to distinguish between the Detail Form line items list and the Query Items. The "Tab Name" column appears before "Name" column. Define query conditions in the setup for filtering the list of records returned at runtime.
- Click to open the Query items widow and click the Query tab to begin setting your condition.
- Click Add to open the Query Condition window. If you do not add a query, the tab returns all the records, based on the reference process.
- Select and enter values in the Data Element and Condition fields. You can add multiple conditions. the system performs the query with "And" operand, on the conditions.
- From the left-hand Navigator, go to the Upper Forms node to configure the Query tab options, similar to the Detail Forms.
- Complete your business process.
- Deploy the business process form.
Additional information:
Within a selected BP, the Query Items sub-node provides the following two links:
- Query Tabs
- Summary Elements
Query Tabs
You can use the Query Tabs sub-node to define and maintain the various Query tabs that are defined within the business process.
General Tab
In the General tab, you can enter the name, description, and reference picker for the required QBT.
In case, you have already included the reference picker in the Upper Form of the business process, the reference picker appears in the drop-down list of the Reference Picker field. In this case, the Name field is populated with the name of the business process, but you can change the name of the QBT, if necessary. The name and reference pickers are mandatory fields on the General Tab, so you cannot create a QBT if you have not included the reference picker on the Upper Form of the business process.
Query Tab
The Query Tab of the QBT is used to create a query to filter the results, displayed within the QBT, based on any particular condition.
To access the Query Tab, go to Item Logs sub-node, open the QBT that was created, and switch to the Query tab.
Note: It is not mandatory to have a query. If no queries are defined, then all records display in the QBT, in User mode.
You can define multiple queries within the Query tab.
The Query Tabs log page allows you to:
- See all the Query Tabs
- Create a new QBT (New).
- Open an existing QBT to review or change content (Open).
- Delete an existing QBT (Delete).
Summary Elements
You can use the summary elements on the Upper Form of the business process to show the data that is being exchanged. You can use the following types of the summary elements in QBT:
- Average
- Count
- Total
- Maximum
- Minimum
You can define multiple summary elements. To create summary elements:
- Go to Company Workspace tab > Admin mode > uDesigner > Business Processes.
- Go to your business process, click Summary Elements node and use the QBT to create your summary elements. After defining the summary elements, click OK to save.
The log page for the Summary Elements node allows you to:
- See all the Summary Elements.
- Create a new Summary Element (New).
- Open an existing Summary Element to review or change content (Open).
- Delete an existing Summary Element (Delete).
Once you create the summary elements, you can include them in the Upper Form of your business process.
Last Published Saturday, July 13, 2024