Using Text Mode with WF Calendars | Community
Skip to main content
D
David-M-Allen
Level 3
November 19, 2024
Question

Using Text Mode with WF Calendars

  • November 19, 2024
  • 2 replies
  • 977 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 19, 2024

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

D
David-M-AllenAuthor
Level 3
November 22, 2024

@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
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
November 22, 2024

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.

D
David-M-AllenAuthor
Level 3
December 16, 2024

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.

Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
December 16, 2024

 

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

Terms & ConditionsAccessibility statement

Loading footer...