Introduction
Welcome to the BizFlowsEngine documentation. This is your complete guide to building, managing, and scaling your business workflows with our platform.
🗃️ Configuring System Fields & Dependent Fields — BizFlowEngine
BizFlowEngine allows direct integration with internal and external databases using System Fields. These fields enable dynamic data fetching from tables or views and can be used in UIs like dropdowns or selection tables.
🔌 Available Database Connections
| Module | Description |
|---|---|
| XON | BizFlowEngine MySQL (default) |
| MySQL1 | First external MySQL connection |
| MySQL2 | Second external MySQL connection |
| MSSQL1 | First external MS-SQL connection |
| MSSQL2 | Second external MS-SQL connection |
🛠️ How to Configure a System Field
- Go to the System Field Configuration UI
- Click Create New
- Fill in the following:
| Field | Description |
|---|---|
| Module | Select the database connection |
| Table Name | Select the table or view |
| Code Field Name | Unique identifier (e.g., EmployeeID) |
| Description Field | Display label (e.g., EmployeeName) |
| Sort By Field | Field to sort the data |
| Where Condition | Optional filter (e.g., IsActive=true) |
| Field List | Comma-separated fields to show in popup (e.g., EmployeeID,EmployeeName) |
| Field Headings | Headings for the popup (e.g., ID,Name) |
| isDisabled | Check to disable the field temporarily |
⚠️ Ensure field names match exactly with the database schema.
📥 Example: Employee System Field
Module: XON
Table Name: auth_employees
Code Field: EmployeeID
Description Field: EmployeeName
Sort By: EmployeeID
Where Condition: IsActive=true
Field List: EmployeeID,EmployeeCode,EmployeeName
Field Headings: ID, Code, Name
🧩 Adding System Fields to UI
Open your UI in Edit Mode
Add a new object under a section or table
Set the object’s Integrated Field property to the configured System Field
🔍 When the user clicks the magnifier icon, the configured data will appear in a popup.
🔗 Creating Dependent System Fields
You can create dependencies between System Fields. For example, an Employee field can depend on selected Department and Designation.
🔧 Steps:
1. Reopen the Employee System Field
2. Update the Where Condition:
IsActive=true AND DepartmentID={0} AND DesignationID={1}
3. In your UI design:
Open the Employee object’s properties
In the Table Dependencies section, add the references of Department and Designation fields (comma-separated and in correct order)
✅ Now, the Employee list will only populate after Department and Designation are selected.
🧠 How to Get Field References
Click on any field in the UI Designer
The reference will appear under the Create Formula section
Copy and use it in formulas, conditions, or Pending Request UI setup
✅ Summary
System Fields allow real-time data integration from external/internal databases
Use them for dropdowns, lookups, and linked selections
Configure dependencies for dynamic filtering
Use field references for advanced logic and UI behavior
© BizFlowEngine — Seamless Data Integration for Smarter UIs