topic Data Force Workflow status in Fusion Manage Forum

Data Force Workflow status

carsten_maaß — Thu, 20 Feb 2025 05:32:21 GMT

Hi Community,

is it possible to force items to next Workflow Status? We have some older database which still get datas. But now i need to "clean" like 7000 items which are in wrong Workflow-Status. Is there a way for me to force defined items to a special workflow status? Or do you have any other ideas how to clean it? They are in different Workflow states atm. For Example i attached 2 screenshots.

Thanks in advance

Re: Data Force Workflow status

sven.dickmans — Mon, 24 Feb 2025 08:27:58 GMT

While there is no standard feature for such mass workflow transitions, you can use the REST API of Fusion Manage to transition multiple records easily. If you do not want to do the coding yourself, you can use my plm-utilities with the Implementation Helpers which automate various admin tasks. The utility Transition Records would be the right one for your purpose.

This set of utilities is based on node.js and allows for batch operations. The plm-utilities also include a tool to extract the configuration of a tenant and more.

If this is an option for you, I can rework the readme of this library with installation & setup instructions.

Re: Data Force Workflow status

carsten_maaß — Mon, 24 Feb 2025 12:26:48 GMT

Hi Sven,

thanks i installed it and was about to test. If i´m correct with your tool i only can change items from one status to a specific status? The Problem is, i would like to "only change items with deliverydate < 01.02.2025". hm....

Re: Data Force Workflow status

sven.dickmans — Tue, 25 Feb 2025 06:37:47 GMT

This requires an adjustment of the filter condition in the file /admin-helpers/transition-records.js as shown in the screenshot below. While I did not test this example, this should work: Just add a 2nd filter condition that filters by the date field. Replace CREATION_DATE with the fieldId of deliverydate. When providing the filterValue, keep in mind that it has to be in format year/month/date. The comparator '19' will return entries 'earlier than or matching' the defined date.

},{ 'fieldID' : 'CREATION_DATE', 'fieldTypeID' : 0, 'filterType' : { 'filterID' : 19 }, 'filterValue' : '2025/01/31'

Betreff: Data Force Workflow status

carsten_maaß — Tue, 25 Feb 2025 10:32:42 GMT

Works like a charm! and exactly what i need. Thank you very much.

Your the best 😉