Report - assigned to

We have a request from a user for a report on invoices. The report should include the following details:

  • Invoice number
  • Time the invoice spent in a certain state
  • User the invoice was assigned to in a certain state
  • Current status of the invoice

Our main challenge is exporting the "Assigned To" property from M-Files, as it seems this property cannot be directly included in exports.

We would greatly appreciate any guidance or best practices on how to approach creating this report, especially if there’s a workaround for including the "Assigned To" property.

Thank you in advance for your help!