Who assigned to who?

Question

I need to generate a report which shows, for every task created in a certain time period, who changed the task from unassigned and who did they first assign it to.

Any ideas? Not even sure where to start with this one!!!

It should be in the task history, but how would I access that to generate a report.

Happy to do number crunching and such in excel if I can get something exportable.

unknown · Answer

Thanks Jobin, that's the conclusion I came to as well (Assignee was EMPTY).

It's not 100% because it picks up results where it was changed from unassigned to assigned to person x and then assigned again to person Y, but it is near enough for the purpose this report is being used for.

Thanks for being so helpful

Jobin Kuruvilla [Adaptavist] · Answer

How about this?

assignee was EMPTY and assignee changed to ABC

You can use the other clauses like AFTER, BEFORE, BY etc along with this.

unknown · Answer

Thanks for your help, but I'm looking to report on assignee/status changes, not time.