Text mode filter to capture users based on two criterias | Community
Skip to main content
C
CamiD
March 14, 2025
Solved

Text mode filter to capture users based on two criterias

  • March 14, 2025
  • 2 replies
  • 383 views
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!

 

Best answer by KellieGardner

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

 

2 replies

KellieGardner
Community Advisor and Adobe Champion
KellieGardnerCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
March 14, 2025

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
Community Advisor and Adobe Champion
Daniel_ClarkeCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
March 14, 2025

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}),"")

Terms & ConditionsAccessibility statement

Loading footer...