Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calendar filter for viewing others on the same "secondary" team as you.

Avatar

Level 10

We use a calendar to view PTO for members of our team. Currently I have a filter for managers to view their direct reports, people to view members of their team. Right now members can only view other if a team they are is the other users' Home Team using "Entered By >> Home Team ID Equal $$USER.teamIDs". This does not show other members who are on the same secondary team as you. If only the "Entered By >> Home Team ID" were "Entered By >> Team ID"

Does anyone know the text mode for allowing two users who are on the same secondary team see each others entries?

This is what I'm using now. I only see "Home team" choices. I've looked through the API fields but it's not clear which to use.

0690z000009E2dNAAS.png

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

0 Replies

Avatar

Level 10

Hi Randy,

Conceptually, since EnteredBy is a an object, I believe what you're after is "EnteredBy.teamIDs IN $$USER.teamIDs"...but I suspect that syntax (comparing two collections) is not supported in the type of filter you're using, and I cannot recall seeing anyone whose noodled it out yet using an EXISTS statement (although it might be possible).

Regards,

Doug

Avatar

Level 10

Thanks Doug, that's actually a nice approach I think. If I can get two collections ( the users' and the colleague's) and compare them then that may work.

I wonder if anyone has done this before with any other fields?

Avatar

Level 3

Hi Randy,

Try this in text mode:

EXISTS:A:$$OBJCODE=USER

EXISTS:A:ID=FIELD:enteredByID

EXISTS:A:teamIDs=$$USER.teamIDs

EXISTS:A:teamIDs_Mod=in

Avatar

Level 10

Tried this too:

enteredBy:teamIDs_Mod=in

enteredBy:teamIDs=$$USER.teamIDs

enteredByID=$$USER.ID

enteredByID_Mod=notin

status=SWM

status_Mod=in

No go