Expand my Community achievements bar.

SOLVED

Need a user report that shows both employee start/entered date and employee deactivated date

Avatar

Level 3

I need to run a report that shows both the date an employee was entered if they are an active employee, or the date their account was deactivated if they are no longer using Workfront/left our company.  I don't see an option for "user term date" or something like that, so how can I get a report with this information??

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

If you pull up the API explorer (https://developer.adobe.com/workfront/api-explorer/) and search for user, you'll see one of the available fields is the actual deactivation date. The other one you're after is the entry date. I think the entry date is available on the user report but the deactivation date might not be, so to create it quickly, I'd just use the entry date field as my starter, switch over to text mode, and then everywhere it says "entryDate" I would swap it over to say "actualDeactivationDate".

View solution in original post

6 Replies

Avatar

Correct answer by
Community Advisor

If you pull up the API explorer (https://developer.adobe.com/workfront/api-explorer/) and search for user, you'll see one of the available fields is the actual deactivation date. The other one you're after is the entry date. I think the entry date is available on the user report but the deactivation date might not be, so to create it quickly, I'd just use the entry date field as my starter, switch over to text mode, and then everywhere it says "entryDate" I would swap it over to say "actualDeactivationDate".

Avatar

Level 3

Thank you!  This is exactly what I needed.  I forgot to look at that.  I wish Workfront would make more of these fields available in the interface! 

Avatar

Level 3

I have one more question.  Is there a way to download the information in the API Explorer?

Avatar

Community Advisor

Not as far as I know. Someone once went through and either took screenshots or copy/pasted (I forget which) all the information for a particular version... that was a labor of love for sure! No, just bookmark the explorer and use that -- it's very easy once you get the hang of it. If you're afraid of losing it, one of our admins made a dashboard out of it and pinned it to their workfront global nav bar... so there's that as well.

Avatar

Level 7

I believe this is the one you are referring to although It's a little old (API 9) but it may be helpful! I think v15 is the current version. :
https://experienceleaguecommunities.adobe.com/t5/workfront-questions/api-explorer-unplugged/m-p/5066...


Avatar

Community Advisor

yes!! That's exactly the one I was thinking of. I think I used to use it to run word searches