Text mode filter to capture users based on two criterias

[CamiD]

Hi all, I'm trying to use text mode in a report to gather all the project users in a column, based on their company ID and their home teams.

I have been using the expression below to gather users based on company ID only, can you help me with also adding home team as criteria?

displayname=xyz
listdelimiter=<br>
listmethod=nested(projectUsers).lists
type=iterate
valueexpression=IF(IN({user}.{companyID},"123"),CONCAT({user}.{name}),"")
valueformat=HTML

Thank you!

[KellieGardner · Accepted solution]

You can include "and" in your value expression.

IF({user}.{companyID}="XYZ"&&{user}.{homeTeamID}="xyz",CONCAT({user}.{name}),"")

Condition operators in calculated custom expressions | Adobe Workfront

[Daniel_Clarke]

If you just want to show the home team alongside the user, that can be appended as well, even stacked along with @KellieGardner's logic to filtering based on that criteria!

IF(IN({user}.{companyID},"XYZ"),CONCAT({user}.{name}, " - ", {user}.{homeTeam}.{name}),"")