Add Other Teams as a filter option on reports

[#1]

Some of our reports need to be filtered to only show data from members who belong to a certain Team. Only Home Team is available as a filter in reporting, so, in order for a person's data to display on a report, we have to make sure we remember to make their Home Team match the filter on the Report.

This works OK, but it means that if a person belongs to more than 1 team, they can only show up on 1 report that is filtered by Home Team. If we could select Other Teams as a filter on a report, then we wouldn't have to remember to make the report filter match their home team, and we could also have the person appear on all of the reports that are filtered by Team.

[#2]

@MattMi3 I'm not seeing this as an option for Hour reports, which is where I really need it. When I try just owner Team IDs nothing is there. There's owner ID, home team ID, home group ID, other group IDs but no other team or just team IDs...

@MoniqueEvans @MichelleFr 

[#3]

@MoniqueEvans Thanks for the tag! I'm guessing this is only available in a User Report because of it's reference to a collection, but will confirm. I'm not seeing anything on an Assignment Report for Assigned To > Teams ID, so hang tight. 

[#4]

@Madalyn_Destafney 

...it will not appear in all user references for other object reports. However, it should be available through text mode for other report types.

For example, the a Hours report does not show the `teamIDs` option in the "Owner" section of the accordion menu. However, you should be able to do something like this in textmode:

owner:teamIDs_Mod={SOME_TEAM_ID}
owner:teamIDs=in

[#5]

@MattMi3 thanks for the insight. I've been trying every which way and cannot get it to produce any results when I know the teams I'm using would produce results. When using a home team OR other team filter in text mode, not working, still doesn't work even if I just try to have the teamIDs portion. What's missing here?

OR:1:entryDate=$$TODAYby
OR:1:entryDate_Mod=between
OR:1:entryDate_Range=$$TODAYey
OR:1:owner:teamIDs=76bca8d377d788bce0530a093a0a551e
OR:1:owner:teamIDs_Mod=in
owner:homeTeamID=653191a30681b430670814d98c73a640
owner:homeTeamID_Mod=in

[#6]

I agree with @Madalyn_Destafney (and @NicholeVargas ) this does not currently seem possible on an Assignment report, even in Text Mode. I've tried the following (all separately) with no luck on any of them:

assignedTo:teamIDs=660eaae600039e22146f0c5f9eac7d3b
assignedTo:teamIDs_Mod=in

assignment:teamIDs=660eaae600039e22146f0c5f9eac7d3b
assignment:teamIDs_Mod=in

assignmentsUsersMM:teamIDs=660eaae600039e22146f0c5f9eac7d3b
assignmentsUsersMM:teamIDs_Mod=in

owner:teamIDs=660eaae600039e22146f0c5f9eac7d3b
owner:teamIDs_Mod=in

projectUsersOM:teamIDs=660eaae600039e22146f0c5f9eac7d3b
projectUsersOM:teamIDs_Mod=in

projectUsersOM:user:teamIDs=660eaae600039e22146f0c5f9eac7d3b
projectUsersOM:user:teamIDs_Mod=in

task:teamIDs=660eaae600039e22146f0c5f9eac7d3b
task:teamIDs_Mod=in

teamIDs=660eaae600039e22146f0c5f9eac7d3b
teamIDs_Mod=in

user:teamIDs=660eaae600039e22146f0c5f9eac7d3b
user:teamIDs_Mod=in

workItem:teamIDs=660eaae600039e22146f0c5f9eac7d3b
workItem:teamIDs_Mod=in

workItem:user:teamIDs=660eaae600039e22146f0c5f9eac7d3b
workItem:user:teamIDs_Mod=in