Skip to main content
N
NickVa7
Level 9
April 14, 2020
Question

Hour Entry Date field Displayed on Assignment Report

  • April 14, 2020
  • 1 reply
  • 449 views

Hi WF Community,

Is there a way, via text mode, to pull in the Hour Entry Date field to an Assignment report? I know that the Assignment and Hour objects don't have a direct relationship; however, I know there's a way to create filters that use EXISTS statements, and can connect non-related objects via 'linking' objects. It's a little confusing to me, but I was curious if someone smarter than me knew of a way to use this method to show data from a non-related object in a report?

Thanks.

Nick

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    April 14, 2020

    Curious if anyone has any ideas. This is difficult because you have to go up one level (task or issue) and then do a collection. So you are going up and down. Even with EXISTS filters, I've never seen anything that goes in both directions. Normally it is up (or down) but multiple levels. Fingers crossed.

    We don't have hours/timesheets in our instance so I can't test. But you might want to try a task report and then use a prompt for Assignment Users ID. That filter will show all tasks assigned to that person whether they are task owner or not. On the Task report, you can then do a collection for an hour's object type's entry date. You can then do the same for issues.

    Just a thought.

    Terms & ConditionsAccessibility statement

    Loading footer...