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

Text mode filter to capture users based on two criterias

  • March 14, 2025
  • 2 replies
  • 409 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
Adobe Champion and Community Advisor
KellieGardnerAdobe Champion and Community AdvisorAccepted solution
Adobe Champion and 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
Adobe Champion and Community Advisor
Daniel_ClarkeAdobe Champion and Community Advisor
Adobe Champion and 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...