Extended Property Builder
Get property value(s) from database. Set calculated value from SQL query or stored procedure call result.
Create query for property value
Create select query, define database and get value for any property.
Call store procedure for property value
Call store procedure, define database to extract needed value.
Use parameter from object in query string
Use parameter from current object where property is triggered and use it in selected query.
Dynamically select employee position from database
Customer is maintaining organizational structure (roles and positions) in program with MS SQL database. For every person they extract their position from database.
Select employee by position in value list
Customer is maintaining organizational structure (roles and positions) in program with MS SQL database. In all workflows they are using roles and positions. Those roles are properties in M-Files and those properties are automatically populated by persons from database.
Get Project financial info from Navision
Customer is using M-Files for Project Management. They are providing Project financial info from ERP to an M-Files Project object.