How to Export Assigned to in Reporting & Data Export

Question

Workflow Assigned to Export Assigned to in Reporting & Data Export.

Dr. Martin Lisowski · Answer

You have to be aware that there is a difference between the internal "Assigned To" property with ID 44 and what is displayed on the metadata card as Assigned To. 
 The internal property ID 44 only holds those users who have not yet completed the assignment. 
 Users that have completed (or approved) an assignment are added to property "Completed By" ID 45 and users who have rejected an approval assignment are added to "Rejected By" ID 97. All three properties are multi-select value lists. The metadata card displays a visually more digestible representation of these three properties as "Assigned To". 
 That means, to get the complete picture you need to export all 3 internal properties, ID 44, 45 and 97.

Craig Hawker · Answer

Unfortunately I do not believe that "Assigned to" is available within the data export options. I also briefly additionally checked that it is not one of the built-in columns that are exported. 
 I would assume that the only way to do this would be to create a new property named "Assigned to (export)" whose value is calculated/copied from the default "Assigned to" property. You can do this via script or - better - via the Property Calculator application. The new property can be hidden using Metadata Card Configuration rules so that it does not confuse anyone. This would allow you to then select the property in the export options. 
 I do not currently understand why there is a limitation here. Whilst the data export functionality is not something we are focused on in the upcoming quarter, I will try to find out why this restriction is in place so that I can better understand what options we may have. 
 For now the workaround above should work.

Craig Hawker · Answer

Unfortunately I do not believe that "Assigned to" is available within the data export options. 
 This is an area of the product that I am the Product Manager for, so I am very interested in hearing from others around possible improvements here.

How to Export Assigned to in Reporting & Data Export

Top Replies

Contact Us

Schedule a Demo

Careers

Trust Center

Privacy Policy

Security Hall of Fame

M-Files Community

Support Portal

Help Center

Product Center

Download M-Files

User Guides

Product News