Other Teams field

I can't say I'm responsible for this text but here's 'All Teams' description=Other Teams isInlineEditable=true linkedname=direct listdelimiter= listmethod=nested(teams).lists listsort=nested(team).string(name) name=All Teams querysort=team:name section=0 shortview=false textmode=true type=iterate valuefield=name valueformat=HTML width=150 Here's 'All Groups' displayname=All Groups link.linkproperty.0.name=ID link.linkproperty.0.valuefield=ID link.linkproperty.0.valueformat=int link.lookup=link.view link.value=val(objCode) listdelimiter= listmethod=nested(userGroups).lists namekey=roles.plural textmode=true type=iterate valuefield=group:name valueformat=HTML Here's 'All Roles' displayname=All Job Roles link.linkproperty.0.name=ID link.linkproperty.0.valuefield=ID link.linkproperty.0.valueformat=int link.lookup=link.view link.value=val(objCode) listdelimiter= listmethod=nested(userRoles).lists namekey=roles.plural textmode=true type=iterate valuefield=role:name valueformat=HTML Here's one to show the manager hierarchy: displayname= linkedname=direct namekey=Manager Hierarchy querysort=DE:Manager Hierarchy valuefield=Manager Hierarchy valueformat=customDataLabelsAsString However, to use that you need this calculated field on a custom user form, that is attached to each user: CONCAT(IF(ISBLANK(Manager.Manager.Manager.Manager.Manager Hierarchy),"",CONCAT(Manager.Manager.Manager.Manager.Manager Hierarchy," - ")),IF(ISBLANK(Manager.Manager.Manager ID),"",CONCAT(Manager.Manager.Manager.Name," - ")),IF(ISBLANK(Manager.Manager ID),"",CONCAT(Manager.Manager.Name," - ")),IF(ISBLANK(Manager ID),Name,CONCAT(Manager.Name," - ",Name)))

Thanks Christina!! Very helpful.

I'm going to go out on a limb and say there's no way to show all the teams on an issue report, which is I assume what you're asking for (primary contact's other teams) -- so it's probably the case that you'll have to put a calculated field on your user to show their other teams and then call that in the issue report. BUT if you discover the magic combination of text mode then please share! :) -skye

OK now for the extra bonus question. This gets me the list in a View. But I'm actually trying to Filter to find all Issues that have a Primary Contact that is on a certain Team. So I'm starting in the Issue Object. I'm looking for the Other Teams (really All teams) of the Primary Contact for a specific Team ID. Under the User object the field name is teamIDs. Under the Issue Object the Primary Contact Home ID is owner:homeTeamID So kind of combining those I need something like owner:teamIDs or owner:user:teamIDs But I tried those and they don't work. Basically I'm jumping from the Issue to the User object. Is this not possible or does the syntax need an adjustment?

Would it be an exists statement? Why do you always have the hard questions! -skye

LOL. Yeah I think an exists or contains statement would be appropriate but I'm not sure of the field and join statement to interrogate. The combinations I've tried don't seem to be working. To be sure, you guys only get a question from me after I've exhausted the big brains here (I'm fortunate enough to have two super sharp resources at my disposal). So when they can't figure it out (within a reasonable amount of time). Then I go to the collection of big brains of you lovely people �� – in hopes someone has done this already. Or Doug is looking for a new challenge �� .

Thanks Doug! Actually we dreamed up another solution that works. So we don't NEED to do this. If you already had something I'm sure it would still be useful down the road, but I don't want you to burn any cycles on my account. I just found a different way to solve my problem and successfully tested it. So we're good here. Thank you!

10-4, Vic: gun holstered. Glad you Found A Way. Regards, Doug Doug Den Hoed - AtAppStore