M-Files tool for exporting to SQL

Question

Hello, 
 I am using the free M-Files tool for exporting to SQL. In the SQL table, I display workflow stages that currently have a process in that stage within the system. Is it possible to export to the SQL table workflow stages that do not currently have any process in them? The goal is to ensure that if stages are added or removed in the workflow in M-Files, the list of stages in the SQL table will update accordingly.

Joonas Linkola · Answer

I assume you are using the Reporting and Data Export feature to export data to the SQL database? This module exports object data only, so by default you only get those states exported which have at least one object in them. 
 One approach you could try is to enable "Export the change history of this property" in the History and Old Values tab for the State property, then you could get also those states that objects have gone through at some point during their lifecycle even if no object is currently in those states. This would still not help with new states you are adding to the workflow until an object has gone through them.

M-Files tool for exporting to SQL

Contact Us

Schedule a Demo

Careers

Trust Center

Privacy Policy

Security Hall of Fame

Subcontractors

M-Files Community

Support Portal

Help Center

Product Center

Download M-Files

User Guides

Product News