Using Text Mode with WF Calendars

[David-M-Allen]

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.

[skyehansen]

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

[David-M-Allen]

@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.

[skyehansen]

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.