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.

use case

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.

use case

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.

use case

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.

FAQ

Most frequent questions and answers

Yes you can edit every single element.

Yes you can edit every single element.

Get the best of technology with Extension Kit