Options
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 3 replies
  • Subscribers 12 subscribers
  • Views 976 views
  • Users 0 members are here
Related

reports

Oscar.icaza

Hello everyone, I'm seeking help/advice. We are trying to create a report from Reports and Data Export on assignments. We need to know how long each assignee takes to approve the assignment. We've already figured out the part about seeing the time from creation to acceptance by the user,




but we can't find the field or metadata indicating which users have not yet approved the assignment. Does anyone know how we can obtain those users who are not marked as approved or a field indicating which assignments have been approved or are still pending?


Parents
  • +1

    There's a built-in property called "Marked as completed by" (property definition ID 45), if I recall correctly this is used to track who has already completed the assignment. The users listed in property "Assigned to" (ID 44) who are not listed also in "Marked as completed by" are then still pending perhaps? I don't have a reporting setup to test this right now, but would that make sense based on your reporting data?

  • 0 in reply to Joonas Linkola

    Correct, with that "Marked as completed by history" table, I can obtain the time it took for approval by making some extra calculations in the query to eliminate duplicates and obtain the original check-in, as otherwise, with each version change, it updates the time for all approvers.

    Also, in the assignment table, when an approval is made, that approver disappears from the assigned to table, and from there, I can obtain the assignees who have not yet approved the assignment.

    In the end, it's more complex than one would expect to know this information, but it can be achieved.

Reply
  • 0 in reply to Joonas Linkola

    Correct, with that "Marked as completed by history" table, I can obtain the time it took for approval by making some extra calculations in the query to eliminate duplicates and obtain the original check-in, as otherwise, with each version change, it updates the time for all approvers.

    Also, in the assignment table, when an approval is made, that approver disappears from the assigned to table, and from there, I can obtain the assignees who have not yet approved the assignment.

    In the end, it's more complex than one would expect to know this information, but it can be achieved.

Children
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.