Filtering on any non-primary team

Question

Hi, we are facing an issue about filtering on Teams field, the thing is when you specify a filter like this:

You only get the records having team_id = 1 (Global). So all the records having Global as "secondary" team (you know, in the teamset) are not being shown. 
 
 Does anyone know the best way to solve this? is there an "official" way to do this? 
 
 The only solution I've seen around is to have a field team_names, to get all team names in the teamset separated by commas and saved in a LH. And then making it filterable. You could make a "contains" filter then. 
 
 But this seems a little convoluted. 
 
 Any help appreciated!

Javier Torón · Accepted Answer

Hi Javier, 
 I can confirm there is only filter capability for the primary team (the team_id saved to the record's row in the database). The teams that make up the teamset are defined elsewhere and are not accessible to the current filtering capabilities in Sugar. 
 We have this on file as Idea 61441. If you have access to the SugarCRM Support portal, you can review this Idea here: portal.sugarondemand.com/ 
 While the alternative approach of copying the teamset to a new field and using filter capabilities against that field can feel convoluted, it is the approach available to us at this time. 
 Regards, Patrick McQueen Director, SugarCRM Support