Expand my Community achievements bar.

Got questions about Workfront Governance? Join our upcoming Ask Me Anything session on February 12th!

Using Text Mode with WF Calendars

Avatar

Level 4

In a calendar, I am trying to get a time off filter to display only those users of a specific group (not a home group) who have time off. These are some of the text mode attempts I have made that are not working:

 

userGroups:groupID=6310fe8100a21f9f230041ac89a1e37c
userGroups:groupID_Mod=in

 

user:userGroups:groupID=6310fe8100a21f9f230041ac89a1e37c
user:userGroups:groupID_Mod=in

 

EXISTS:1:$$OBJCODE=USER

EXISTS:1:ID=FIELD:userID

EXISTS:1:userGroups:groupID=6310fe8100a21f9f230041ac89a1e37c

 

I'd appreciate any help.

Thank you.

5 Replies

Avatar

Community Advisor

We discovered that we couldn't do this in a calendar either. A good way to tell for sure is to set up a Time Off report, and then copy the filter right over into the calendar. If it works in one and not in the other, then Calendar reporting won't take the filter because of Calendar-related reasons. 

 

You didn't mention what wasn't working for your attempts, so just in case this isn't working in a Time Off report either, I would suggest trying something more like this sample code below:

 

EXISTS:a:$$OBJCODE=USRGPS

EXISTS:a:userID=FIELD:userID

EXISTS:a:groupID=___________

Avatar

Level 4

@skyehansenthanks for your reply. What is not working is that the Calendar does not show any results when the filter is activated.

 

The text code below works in the Time Off report, but not in the Calendar:

 

EXISTS:1:$$OBJCODE=USER

EXISTS:1:ID=FIELD:userID

EXISTS:1:userGroups:groupID=6310fe8100a21f9f230041ac89a1e37c

 

Also, the report also has an option for otherGroupsNames under columns, but it is not available under filters and is not available in the Calendar at all for some reason.

Avatar

Community Advisor

hi David, as I mentioned in my earlier response: "If it works in one and not in the other, then Calendar reporting won't take the filter because of Calendar-related reasons."

 

I think I actually did submit a case and verified a couple of years ago with Support that this was the case, but you're welcome to submit a case of your own, and talk it through with them -- it would be nice if they updated the functionality to make this possible.

Avatar

Level 4

Pertaining to time-off filtering by a non-home group in Calendars, WF support replied back to me:

 

"It took a bit longer than I'd hoped to get an answer from our engineers, but I have gone over this with a few resources and we have been able to determine that the calendars do not support filtering for other groups. Right now, it can only filter for a user's home group".

 

Note, this also applies to filtering by a Team.

Avatar

Community Advisor

 

Hi @David-M-Allen,

 

Well: having hit that limitation, and noting calendars do not (yet) support the "Run As" concept, I invite you to consider this workaround (#hackalert):

 

  • Create a new user for each Home Group of interest (e.g. First name "Home Group" Last name = the name of the Home Group), each assigned to its corresponding Home Group
  • Log in as each such user and create its Home Group Calendar
  • Click Calendar Actions > Get Shareable Link > Copy the url to your clipboard
  • Log in as SysAdmin (i.e. yourself), create a dashboard > add External Page (bottom right) > Paste the url
  • Save and share the Dashboard as you deem fit

 

NOTE: this approach does "cost a license" for each Home Group, but if the functionality is important enough, might be warranted.

 

Regards,

Doug