Options
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 10 subscribers
  • Views 55 views
  • Users 0 members are here
Related

M-Files tool for exporting to SQL

sivan nahon

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.

  • 0

    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
M-Files Support


© 2024 M-Files, All Rights Reserved.