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
  • 380 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
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
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
Daniel_ClarkeCommunity Advisor
Community Advisor
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...