Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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.

1 Reply

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=___________