Reporting - Who is currently assigned to the workflow.

オフライン

I am trying to create a self-service report that shows who is current assigned to each CN (ECN) and what state each CN is currently in.  I have admin privileges, but I am new to the self-service reporting feature.  I also have access to the aftermarket "InnovatorAdmin" app if someone has AML script that would give me this same information. 

CN Number Assigned To CN State Activity
CN-004589 Bob Smith In Change Final Update

Thank you!

Don

Parents
  • I don't think you can get this information with a single AML request. But if only the "ECN keyed name", "Assigned To" and "Activity name" are enough for you, this AML will give them.

    <Item action='get' type='Workflow' select='related_id'>
      <source_type>85F86794FACF42599F07019F7BEA1D46</source_type>
      <related_id>
        <Item type='Workflow Process' action='get' select='keyed_name'>
          <state>Active</state>
          <Relationships>
            <Item action='get' type='Workflow Process Activity' select='related_id(name)'>
              <related_id>
                <Item type='Activity'>
                  <state>Active</state>
                  <Relationships>
                    <Item action='get' type='Activity Assignment' select='related_id(keyed_name)'/>
                  </Relationships>
                </Item>
              </related_id>
            </Item>
          </Relationships>
        </Item>
      </related_id>
    </Item>

Reply
  • I don't think you can get this information with a single AML request. But if only the "ECN keyed name", "Assigned To" and "Activity name" are enough for you, this AML will give them.

    <Item action='get' type='Workflow' select='related_id'>
      <source_type>85F86794FACF42599F07019F7BEA1D46</source_type>
      <related_id>
        <Item type='Workflow Process' action='get' select='keyed_name'>
          <state>Active</state>
          <Relationships>
            <Item action='get' type='Workflow Process Activity' select='related_id(name)'>
              <related_id>
                <Item type='Activity'>
                  <state>Active</state>
                  <Relationships>
                    <Item action='get' type='Activity Assignment' select='related_id(keyed_name)'/>
                  </Relationships>
                </Item>
              </related_id>
            </Item>
          </Relationships>
        </Item>
      </related_id>
    </Item>

Children