M-Files is a 2025 Gartner Peer Insights Customers' Choice for Document Management
➡️Download the report!

Options
  • State Not Answered
  • Replies 2 replies
  • Subscribers 16 subscribers
  • Views 52 views
  • Users 0 members are here
Related

View all assignments created from workflows on any object type?

jmondanaro

We use Workflows to generate various "approval" assignments to audit processes. Naturally the Audit team would like to easily access a view to see all the Assignments generated over a period of time per Workflow. However, since the Workflow belongs to the Object and not the assignment, you cannot seem to create a single View that can do this.

What I have is a View with Filter of Object Type = Assignment.

Now unfortunately I need to pull the Workflow from the related Object from the Assignment. But in my case we have multiple types of Objects, not just Documents. So for example, I could set my first Grouping Level to be "Workflow" and the Property used to drive the Grouping is "Document.Workflow". But this then means that only Assignments generated from Workflows on Document Objects get picked up. What I really need is a Wild card operator for the linked object->  [Any Object].Workflow (any property) But this doesn't seem possible. Its more like I want to Union the results of different related object types.Workflow.

I'd rather not resort to simply exporting the data to SQL and making a regular report.

Any ideas?

-Jason

Parents
  • 0

    uhmm... I dont know how many objects you have but I think you can fill up a multi-select from assignment property with "Managed Properties" in compliance kit with as long as "assigned to" is not empty condition... You need to generate as many rules as your objects

    So, in theory ( I did not try this yet), you'd have your objects with relevant metadata (a multi-select property that contains assignments referenced to that object) that you can filter out... This needs testing tho..

    Addendum: did some testing. Trying to write something back to main object after workflow created assignment fails with lock error :\

    Addendum 2.0 : maybe we can do it with property calculator's background job... oh the possibilities Smiley

Reply
  • 0

    uhmm... I dont know how many objects you have but I think you can fill up a multi-select from assignment property with "Managed Properties" in compliance kit with as long as "assigned to" is not empty condition... You need to generate as many rules as your objects

    So, in theory ( I did not try this yet), you'd have your objects with relevant metadata (a multi-select property that contains assignments referenced to that object) that you can filter out... This needs testing tho..

    Addendum: did some testing. Trying to write something back to main object after workflow created assignment fails with lock error :\

    Addendum 2.0 : maybe we can do it with property calculator's background job... oh the possibilities Smiley

Children
No Data
M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.