how to track User's previous access Level information | Community
Skip to main content
March 25, 2025
Solved

how to track User's previous access Level information

  • March 25, 2025
  • 1 reply
  • 439 views

Hi team,

 

Iam creating a user decision report where i would like to know when did user move from Contributor to Light like the License modified date . Can any one help me with the expression to find this out ?

 

Thanks in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Sven-iX

Far as i know Workfront doesn't track the date a license changed. 

But you can use a JOURNAL report i think. Something like this? 

 

 

1 reply

Sven-iX
Community Advisor
Sven-iXCommunity AdvisorAccepted solution
Community Advisor
March 25, 2025

Far as i know Workfront doesn't track the date a license changed. 

But you can use a JOURNAL report i think. Something like this? 

 

 

SmithaL1Author
March 25, 2025

Thank you, i shall try

Sven-iX
Community Advisor
Community Advisor
March 25, 2025

Some tips

Report filter

 

column current access level

valueexpression=If(isblank({user}.{accessLevel}.{name}),"No access", {user}.{accessLevel}.{name}) valueformat=HTML linkedname=user namekey=view.relatedcolumn displayname=Current Access Level namekeyargkey.0=user namekeyargkey.1=accessLevel:name querysort=user:accessLevel:name

 

Column Updated from

valueexpression=If(isblank({aux2}),"No access", {aux2}) valueformat=HTML linkedname=direct namekey=aux2 displayname=Updated from querysort=aux2

 

Column Updated to

valueexpression=If(isblank({aux1}),"No access", {aux1}) valueformat=HTML linkedname=direct namekey=aux1 displayname=Updated to querysort=aux1